Try OpenEdge Now
skip to main content
Database Administration
Reference : PROMON Utility : R&D Administrative Functions : Resolve Limbo Transactions
 
Resolve Limbo Transactions
Lets you resolve a limbo transaction by either committing or aborting the transaction.

PROMON Resolve Limbo Transactions menu

When you choose this option, PROMON displays the following menu.
     1 Abort a Limbo Transaction
     2 Commit a Limbo Transaction
     Q Quit

     Enter choice>
Choose one of the following options:
*Abort a Limbo Transaction — When you choose Abort a Limbo Transaction, PROMON prompts you to enter the user number of the transaction you want to abort. PROMON displays the user's number in the User column of the Transaction Control option screen. Type the user number, then press RETURN.
*Commit a Limbo Transaction — When you choose Commit a Limbo Transaction, PROMON prompts you to enter the user number of the transaction you want to commit. (PROMON displays the user number in the Usr column of the Transaction Control option screen.) Type the user number, then press RETURN. PROMON displays a message similar to the following:
User 1: commit transaction and disconnect.
Note: To commit transactions on a database that is shut down, you must use the 2PHASE RECOVER qualifier of PROUTIL.