Resolving Limbo Transactions

Go Up to Performing Database Maintenance

You can correct transactions in a limbo state using the GlobalAction property of the TIBValidationService to perform one of the following actions of type TTransactionGlobalAction on the database specified by the DatabaseName property:

TIBValidationService actions

Action	Meaning
CommitGlobal	Commits the limbo transaction specified by ID or commits all limbo transactions
RollbackGlobal	Rolls back the limbo transaction specified by ID or rolls back all limbo transactions
RecoverTwoPhaseGlobal	Performs automated two-phase recovery, either for a limbo transaction specified by ID or for all limbo transactions
NoGlobalAction	Takes no action

For example, to set the global action using radio buttons:

with IBValidationService1 do
try
  if RadioButton1.Checked then GlobalAction := (CommitGlobal);
  if RadioButton2.Checked then GlobalAction := (RollbackGlobal);
  if RadioButton3.Checked then GlobalAction := (RecoverTwoPhaseGlobal);
  if RadioButton4.Checked then GlobalAction := (NoGlobalAction);

Advance To:

• Requesting Database and Server Status Reports