Try OpenEdge Now
skip to main content
Database Administration
Reference : Virtual System Tables : Virtual system table summaries : Transaction (_Trans)
 
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
1 Activity and status of ABL temp-tables is available in this virtual system table. The statistics gathered allow you to monitor the operation and performance of deployed client temp-tables. Specify the range of temp-tables to track with the -ttbasetable and -tttablerangesize startup parameters. Specify temp table indexes with -ttbaseindex and -ttindexrangesize startup parameters. For more information monitoring and debugging temp tables with VSTs, see OpenEdge Development: Debugging and Troubleshooting.