Database Management Technology 
The transactions table contains statistics about all current logging system transactions. One row is returned for each transaction of all vnodes in the current IMA management domain. Delta columns represent counter changes for the last interval.
| Attribute Name | Key | Datatype | Description |
| timestamp | 0 | date | Date and time the data was collected |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| txn_index | 0 | integer4 | Internal index for the current transaction. |
| delta_seconds | 0 | integer4 | Elapsed time (seconds) since the previous refresh. |
| cp_address | 0 | varchar(32) | Log address of the most recent consistency point affecting the transaction. |
| cp_block | 0 | integer4 | Block number of the log address for the most recent consistency point affecting this transaction. |
| cp_offset | 0 | integer4 | Block offset of the log address for the most recent consistency point affecting this transaction. |
| cp_trip | 0 | integer4 | Trip counter of the log address for the most recent consistency point affecting this transaction. |
| db_id | 0 | integer4 | Internal database id for the database opened by the transaction. |
| db_name | 0 | varchar(32) | Database name of the database opened by the transaction. |
| db_owner | 0 | varchar(32) | Database owner of the database opened by the transaction. |
| dst_txn | 0 | varchar(32) | Hex representation of the distributed transaction id for the transaction. |
| first_log_rec | 0 | varchar(32) | Log address for the first log record of the transaction. |
| first_log_block | 0 | integer4 | Block number for the log address of the first transaction log record. |
| first_log_offset | 0 | integer4 | Block offset for the log address of the first transaction log record. |
| first_log_trip | 0 | integer4 | Trip counter for the log address of the first log record for the transaction. |
| instance | 0 | integer4 | Transaction instance id. |
| prepared | 0 | varchar(32) | Flag indicating transaction in a WILLING_COMMIT state. |
| dist_txid | 0 | varchar(16) | Distributed transaction id for the transaction. |
| last_log_rec | 0 | varchar(32) | Log address for the last log record of the transaction. |
| last_log_block | 0 | integer4 | Block number for the log address of the last log record for the transaction. |
| last_log_offset | 0 | integer4 | Block offset for the log address of the last log record for the transaction. |
| last_log_trip | 0 | integer4 | Trip counter for the log address of the last log record for the transaction. |
| last_lsn | 0 | varchar(32) | Latest log sequence number (LSN) generated by the transaction. |
| last_lsn_block | 0 | integer4 | |
| last_lsn_offset | 0 | integer4 | Low order part of the most recent LSN for the transaction. |
| last_lsn_trip | 0 | integer4 | High order part of the LSN for the transaction. |
| pid | 0 | integer4 | Process id of the transaction owner (database server). |
| pr_id | 0 | integer4 | Internal id for the owner process block. |
| reserved_bytes | 0 | integer4 | Amount of log file space reserved by the transaction for CLR records. |
| reserved_bytes_d | 0 | integer4 | Amount of log file space reserved by the transaction for CLR records in the last interval. |
| sequence | 0 | integer4 | Transaction sequence number. |
| session_id | 0 | varchar(16) | Internal identifier of the database server session |
| log_forces | 0 | integer4 | Count of log force operations initiated by the transaction. |
| log_forces_d | 0 | integer4 | Count of log force operations initiated by the transaction in the last interval. |
| log_split_waits | 0 | integer4 | Count of split waits caused by the transaction. |
| log_split_waits_d | 0 | integer4 | Count of split waits caused by the transaction in the last interval. |
| log_waits | 0 | integer4 | Count of log waits caused by the transaction. |
| log_waits_d | 0 | integer4 | Count of log waits caused by the transaction in the last interval. |
| log_writes | 0 | integer4 | Count of logical write operations initiated by the transaction. |
| log_writes_d | 0 | integer4 | Count of logical write operations initiated by the transaction in the last interval. |
| status_s | 0 | varchar(64) | Transaction status string. |
| status | 0 | integer4 | Numeric status for the current transaction. |
| txn_id_s | 0 | varchar(16) | String representation of the transaction id. |
| txn_id_high | 0 | integer4 | High order part of the transaction id. |
| txn_id_low | 0 | integer4 | Low order part of the transaction id. |
| user_name | 0 | varchar(32) | Username of the transaction owner. |
| wait_reason_s | 0 | varchar(64) | String representation of the wait reason. |
| wait_reason | 0 | integer4 | Numeric wait reason. |
