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

Well, i don't know what to answer because all this sounds greek to me.
Also i just started to use gfix for two phase recovery recently, when
i discovered that just windows version works for this task.
Up to now i had tried many times with linux version with no success,
so i'm not used with this procedure.
Is there some document i can study about it?

Regards,

Fabiano.