Returns a list of transactions that are currently active.
|Column name||Data type||Description|
|connection_num||INT||The connection ID for the connection the transaction is running on.|
|transaction _id||INT||The ID that uniquely identifies the transaction as long as the database server keeps track of it. IDs are reused as old transaction information is discarded.|
|start_time||TIMESTAMP||The TIMESTAMP for when the transaction started.|
|start_sequence_num||UNSIGNED BIGINT||The start sequence number for the transaction.|
|end_sequence_num||UNSIGNED BIGINT||Then end sequence number for the transaction if it has been committed or rolled back, otherwise, NULL.|
|committed||bit||The state of the transaction: true if the transaction ended with a COMMIT, false if it ended with a ROLLBACK, and NULL if the transaction is still active.|
|version_entries||unsigned INT||The count of the number of row versions the transaction has saved.|
This procedure provides information about the transactions that are currently running against the database.
DBA authority required
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|