Database Management Technology 
The transactions_prim 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.
| Attribute Name | Key | Datatype | Description |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| txn_index | 0 | integer4 | Internal index for the current transaction. |
| cp_address | 0 | varchar(32) | Log address of the most recent consistency point affecting the 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_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_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_trip | 0 | integer4 | High order part of the LSN for the transaction. |
| last_lsn_offset | 0 | integer4 | Low order part of the most recent 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. |
| 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_split_waits | 0 | integer4 | Count of split waits caused by the transaction. |
| log_waits | 0 | integer4 | Count of log waits caused by the transaction. |
| log_writes | 0 | integer4 | Count of logical write operations initiated by the transaction. |
| status_s | 0 | varchar(64) | Transaction status string. |
| status | 0 | integer4 | Numeric status for the current transaction. |
| txn_id_s | 2 | 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. |
