Progress
Database Administration
Guide and Reference


Detecting Limbo Transactions

When a limbo transaction occurs, PROUTIL writes information about the failed transactions to the log (.lg) file and displays one of the following messages:

Part of the distributed transaction might have failed.(2022) 
Cannot roll back a limbo transaction.(2030) 

Figure 12–4 illustrates where messages are displayed.

Figure 12–4: How PROUTIL Processes React To Limbo Transactions

Limbo transactions can occur without any messages being displayed on screen, for example, if a hardware or software failure occurs while a user is running a PROUTIL application or if a user powers off a client machine. If possible, users on client machines should inform the system administrator when these events occur. If such an event occurs, examine all of the databases that might be involved to determine whether any limbo transactions occurred. You can use PROMON or PROUTIL to examine a database for limbo transactions.

CAUTION: If an application is performing a distributed transaction when a client machine fails or shuts down, the transaction remains open. If this continues unchecked, the BI files of the databases involved in the transaction could grow to fill the disk, as with any other long-running transaction.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095