Try OpenEdge Now
skip to main content
SQL Development
Working with JTA Transactions : Planning for JTA transaction support : Monitoring JTA transactions

Monitoring JTA transactions

Database administrators of JTA-enabled databases must be able to monitor the status of those transactions. Both the promon utility and the virtual system tables are used to display JTA transaction and lock statuses.
JTA transaction locks belong to the transaction and not to any of the users who may have participated in the work of the transaction.
The promon utility identifies the JTA transaction states, as shown in the following table.
Table 18. JTA transaction states
Active JTA
The transaction is currently active
Idle JTA
The transaction is not currently executing
Prepared JTA
The transaction is prepared
Rollback-only JTA
The transaction has encountered an error
Commit JTA
The transaction is in the commit process