Fabiano Bonin wrote:

> Hi all,
>
> Why sometimes when doing two phase recovery gfix ask for what
> operation should be done (commit, rollback ou neither) and sometimes
> it doesn't ask anything?

If all participants in the original transaction are available,
Firebird will determine on its own whether the transaction should
be committed or rolled back. If any sub-transaction has not prepared,
then everyone rolls back. If everyone has prepared, everyone
commits. If anyone can't be found, then gfix has to ask.

Do you really want to commit regardless of the state of the other
sub-transactions?


Best regards,


Ann