vwinfo Transactions Display
The information provided by vwinfo -o can answer question such as:
• How many active sessions are there?
• Do some sessions use vast amount of memory? Which ones?
• How much memory is used for updates?
• Are there transactions with uncommitted changes?
Fields are as follows:
x100_session_id
X100 session ID
ingres_session_id
Ingres session ID in hex
x100_thread_id
X100 thread ID in hex
x100_tx_id
X100 transaction ID. In between sessions with open transactions, sessions without open transactions (x100_tx_id = 0) are listed with the most recently connected shown first.
total_memory
Total memory, in bytes, consumed by the transaction
pdts_memory
Memory, in bytes, consumed by PDTs
has_updates
Whether transaction has uncommitted updates
read_only
Whether the transaction is read only (1) or read write (0)
x100_query
Currently executed X100 query
Last modified date: 01/30/2023