Transaction (_Trans)

The _Trans VST includes information such as transaction number, state, start time, duration, user number, coordinator name, and transaction.1

Field name Data type Description
_Trans-BIRecReads INT64 Number of notes read for the current transaction
_Trans-BIRecWrites INT64 Number of notes written for the current transaction
_Trans-Coord CHARACTER Name of the coordinator database
_Trans-CoordTx INTEGER Current coordinator transaction number
_Trans-Counter INTEGER Transaction count
_Trans-Duration INTEGER Number of seconds the transaction required to complete
_Trans-Flags CHARACTER Transaction flags
_Trans-JTA-State CHARACTER State of the current JTA transaction. Values include:
  • JTA-Active
  • JTA-Idle
  • JTA-Prepared
  • JTA-RollbackOnly
  • JTA-NonExistent
_Trans-Flags CHARACTER
_Trans-Misc INTEGER Miscellaneous information
_Trans-Num INTEGER Transaction number
_Trans-State CHARACTER Transaction state
_Trans-TenantID INTEGER Tenant ID of the user that is in the transaction
_Trans-Txtime CHARACTER Transaction start time
_Trans-Usrnum INTEGER User number of the user running the distributed transaction
_Trans-XID CHARACTER Global transaction ID for the JTA transaction