Lets you resolve a two-phase commit limbo transaction by either committing or aborting the transaction.
Sample output for PROMON Resolve 2PC Limbo Transactions option
When you choose this option, PROMON displays the menu shown in the following figure.
1 Abort a Limbo Transaction
2 Commit a Limbo Transaction
Q Quit
Enter choice>
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 2PC Transaction Control screen.) Enter the user's 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 2PC Transaction Control screen.) Enter 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.
