Database Management Technology 
The log_header_stats_prim table contains transaction log header statistics for the current installation. This table returns one row for each vnode in the current IMA domain.
| Attribute Name | Key | Datatype | Description |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| active_log_s | 0 | varchar(64) | Active transaction log(s). |
| active_log | 0 | integer4 | Numeric value of active transaction log. 0x01 LGD_II_LOG_FILE, 0x02 LGD_II_DUAL_LOG |
| arc_end_s | 0 | varchar(32) | Archive window end address in the transaction log. |
| arc_end_offset | 0 | integer4 | Block offset for ending address of the transaction log archive window. |
| arc_end_trip | 0 | integer4 | Archive window end log sequence number. |
| arc_pcp_s | 0 | varchar(32) | Transaction log address of most recent CP (consistency point). |
| arc_pcp_offset | 0 | integer4 | Block offset for latest CP address prior to the archive window. |
| arc_pcp_trip | 0 | integer4 | Log sequence number for CP prior to archive window. |
| arc_start_s | 0 | varchar(32) | Archive window start address. |
| arc_start_offset | 0 | integer4 | Block offset of archive window start address. |
| arc_start_trip | 0 | integer4 | Archive window start address sequence number. |
| forced_s | 0 | varchar(32) | |
| forced_offset | 0 | integer4 | |
| forced_trip | 0 | integer4 | |
| forced_lsn_s | 0 | varchar(32) | |
| forced_lsn_offset | 0 | integer4 | |
| forced_lsn_trip | 0 | integer4 | |
| active_logs | 0 | integer4 | Defines which transaction logs are active in a dual logging installation. |
| begin_s | 0 | varchar(32) | Transaction log BOF address. |
| begin_offset | 0 | integer4 | Block offset for transaction log BOF mark. |
| begin_trip | 0 | integer4 | Transaction log BOF sequence number. |
| header_checksum | 0 | integer4 | Log file header checksum. |
| cp_s | 0 | varchar(32) | Current CP log address. |
| cp_offset | 0 | integer4 | Block offset for current CP. |
| cp_trip | 0 | integer4 | Current CP log sequence number. |
| archiver_interval | 0 | integer4 | Number of consistency points to invoke the archiver. |
| end_s | 0 | varchar(32) | Transaction log EOF mark. |
| end_offset | 0 | integer4 | Block offset for transaction log EOF mark. |
| end_trip | 0 | integer4 | Transaction log EOF mark sequence number. |
| percent_full | 0 | integer4 | Percentage of the transaction log in use. |
| log_status_s | 0 | varchar(64) | Log file status. |
| log_status | 0 | integer4 | Numeric log file header status. |
| last_txid_s | 0 | varchar(32) | Most recent transaction id. |
| last_tx_id_high | 0 | integer4 | High order bytes of most recent transaction id. |
| last_tx_id_low | 0 | integer4 | Low order bytes of the most recent transaction id. |
| last_record_s | 0 | varchar(32) | |
| last_record_trip | 0 | integer4 | |
| last_record_offset | 0 | integer4 | |
| reserved_bytes | 0 | integer4 | Count of bytes reserved in the transaction log for CLRs (compensating log records). |
| status_s | 0 | varchar(64) | String representation of logging system status. |
| status | 0 | integer4 | Numeric value of logging system status. |
