The logging_stats_prim table contains logging system activity statistics for the current installation. One row is returned for each vnode in the current IMA management domain.
| Attribute Name | Key | Datatype | Description |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| dual_read_ios | 0 | integer4 | Count read operations from the dual transaction log since installation startup. |
| dual_write_ios | 0 | integer4 | Count of write operations to the dual transaction log since installation startup. |
| txn_ends | 0 | integer4 | Count of transactions completed since installation startup. |
| log_forces | 0 | integer4 | Count of force operations to the current transaction log since installation startup. |
| kbytes | 0 | integer4 | Measure of logging data written to the transaction log since installation startup, units are Kbytes. |
| log_read_ios | 0 | integer4 | Count of read operations from the primary transaction log since installation startup. |
| log_write_ios | 0 | integer4 | Count of physical writes to the primary transaction log. |
| split_waits | 0 | integer4 | Count of log waits initiated by split write operations. |
| log_waits | 0 | integer4 | Count of log wait operations since installation startup. |
| log_writes | 0 | integer4 | Count of logical writes to logging system buffers. |
| writeio | 0 | integer4 | Count of physical writes to the transaction log. |
| lfb_status | 0 | integer4 | Numeric value for transaction log file status. |
| prim_last_block | 0 | integer4 | Most recent block written to the primary transaction log. |
| dual_last_block | 0 | integer4 | Last block read or written to/from the primary transaction log. |
| lfbb_size | 0 | integer4 | Maximum number of log file blocks which can be allocated by the logging system. |
| ldb_inuse | 0 | integer4 | Number of log database blocks currently in use, this is the number of open databases. |
| ldbb_count | 0 | integer4 | Number of log database blocks allocated by the logging system. |
| lfbb_count | 0 | integer4 | Count of lof file block allocated by the logging system. |
| lpb_inuse | 0 | integer4 | Count of log process blocks currently in use. |
| lpb_allocated | 0 | integer4 | Count of log process blocks allocated by the logging system. |
| lpd_inuse | 0 | integer4 | Count of log process database blocks currently in use. |
| lpd_allocated | 0 | integer4 | Count of log process database blocks allocated by the logging system. |
| lxb_inuse | 0 | integer4 | Count of transaction blocks currently in use. |
| lxbb_allocated | 0 | integer4 | Count of transaction blocks allocated by the logging system. |
| no_bcp | 0 | integer4 | If 1, consistency point is in progress and a new one cannot be started. |
| protect_count | 0 | integer4 | Current count of protect transactions, that is transactions which must be rolled back if aborted. |
| db_add | 0 | integer4 | Count of database add operations since installation startup. |
| bcp_stall_waits | 0 | integer4 | Log stalls caused by BCP (begin consistency point) writes. |
| txn_begins | 0 | integer4 | Count of transactions started since installation startup. |
| dual_readio | 0 | integer4 | Count of read operations from the dual transaction log since installation startup. |
| dual_writeio | 0 | integer4 | Count of write operations to the dual transaction log since installation startup. |
| lgd_txn_ends | 0 | integer4 | Count of transactions completed by the logging system since installation startup. |
| force | 0 | integer4 | Count of log buffers forced to the transaction log. |
| free_waits | 0 | integer4 | Count of waits for free log buffers since installation startup. |
| group_count | 0 | integer4 | Count of log buffers written during group commit processing. |
| group_force | 0 | integer4 | Count of log buffers forced to the transaction log during group commit processing. |
| inconsistent_db | 0 | integer4 | Count of databases marked inconsistent since installation startup. |
| kbytes_written | 0 | integer4 | Measure of logging data written to all active transaction logs since installation startup, units are Kbytes. |
| log_readio | 0 | integer4 | Count of read operations from all configured transaction logs since installation startup. |
| log_writeio | 0 | integer4 | Count of physical writes to the transaction log. |
| pgyback_check | 0 | integer4 | Count of piggyback write checks since installation startup. |
| pgyback_write | 0 | integer4 | Count of write operations initiated by piggyback write. |
| readio | 0 | integer4 | Count of physical read operations from the transaction log. |
| db_remove | 0 | integer4 | Count of database remove operations since installation startup. |
| split | 0 | integer4 | Count of split write operations since installation startup. |
| stall_wait | 0 | integer4 | Count of log write operations stalled. |
| wait | 0 | integer4 | Count of log waits since installation startup. |
| log_write | 0 | integer4 | Count of logical log writes performed since installation startup. |
| lgd_writeio | 0 | integer4 | Count of physical writes to all transaction logs performed by the logging system since installation startup. |