> 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.

Please look again at gfix output - there are two participants and both
is prepared. Such transaction may be committed or rolled back and gfix
asks what to do.

Regards,
Vlad