Was this helpful?
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