Resolving Limbo Transactions

From InterBase
Jump to: navigation, search

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: