Resolving Limbo Transactions
From InterBase
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:
Action | Meaning |
---|---|
|
Commits the limbo transaction specified by ID or commits all limbo transactions |
|
Rolls back the limbo transaction specified by ID or rolls back all limbo transactions |
|
Performs automated two-phase recovery, either for a limbo transaction specified by ID or for all limbo transactions |
|
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);