Determining when connections have committed transactions

Command/File	Information
ADMIN COMMAND 'trace'	Shows if a transaction gets committed at the server
ADMIN COMMAND 'report filename.txt'	Obtain a list of internal variables containing connection and status information. To find out 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

ADMIN COMMAND 'report filename.txt'

Obtain a list of internal variables containing connection and status information. To find out 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.