Monitoring Pending Transactions

How To:

To view pending transactions
To commit pending transactions

To abort pending transactions

In a distributed database environment, transactions can be made across multiple databases. To effectively manage this, DBMaker uses a two-phase commit method. The user inputs a command affecting the remote databases at the coordinator database. First, the coordinator database sends the command to the appropriate remote databases where they prepare to commit the transaction. After confirmation that all remote databases are prepared, the coordinator database sends a COMMIT transaction command to the remote databases, where the transaction is completed. It is possible that a network failure can occur between these two phases. The global transaction recovery daemon is responsible for logging all such errors and holding them as pending transactions until they can be committed at a later time. Pending transactions can be viewed using the JDBA Tool and can also be committed or aborted.


Related topic:

Database Monitor (Tree)