Determining when connections have committed transactions

Command/File	Information
ADMIN COMMAND 'trace'	Shows if a transaction gets committed at the server, see TRACE.
ADMIN COMMAND 'report filename.txt'	Obtain a list of internal variables containing connection and status information, see REPORT. To find connections that have not committed their transaction, look for the Readlevel for each connection. If the transaction at a particular connection is properly closed, the Readlevel should be zero (0) for that connection. To find those statements with active status, look under USER SEARCHES with column "Act" having a value of 1. If the active status remains at the same Readlevel for a lengthy period, the statement has not closed or committed during this interval.

Command/File

Information

ADMIN COMMAND 'trace'

Shows if a transaction gets committed at the server, see TRACE.

ADMIN COMMAND 'report filename.txt'

Obtain a list of internal variables containing connection and status information, see REPORT.

To find connections that have not committed their transaction, look for the Readlevel for each connection. If the transaction at a particular connection is properly closed, the Readlevel should be zero (0) for that connection.

To find those statements with active status, look under USER SEARCHES with column "Act" having a value of 1. If the active status remains at the same Readlevel for a lengthy period, the statement has not closed or committed during this interval.