The logging_config_prim table contains logging system configuration statistics for the current installation. This table returns one row per vnode in the current IMA management domain. Configuration values do not change while the installation is running.
| Attribute Name | Key | Datatype | Description |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| log_buffers | 0 | integer4 | Count of allocated log buffers used to transfer logging records to the transaction log. |
| abort_blocks | 0 | integer4 | Count of blocks in use to invoke Force Abort processing. |
| cp_blocks | 0 | integer4 | Count of blocks between consistency points, defines the frequency of consistency points. |
| full_blocks | 0 | integer4 | When blocks in use exceeds this value transactions are suspended until log file space can be reclaimed. |
| block_size | 0 | integer4 | Transaction log block size in bytes, this is the transfer size from memory to the transaction log. |
| block_count | 0 | integer4 | Count of log blocks in the transaction log (log file size in block units). |
| db_limit | 0 | integer4 | Maximum number of databases registered with the logging system, limits the number of open databases. |
| server_limit | 0 | integer4 | Maximum number of servers registered with the logging system. |
| proc_db_limit | 0 | integer4 | Maximum number of server to database connections in the logging system. |
| tx_limit | 0 | integer4 | Maximum number of transactions in the logging system. |
| logwriter_threads | 0 | integer4 | Count of log writer threads, this is the sum of log writer threads for all servers in the installation. |
| file_version | 0 | integer4 | Transaction log format version. |
| check_stall | 0 | integer4 | When transaction log blocks in use exceeds this value begin checking for log full and stall conditions. |
| node_id | 0 | integer4 | Node id for the local node in a clustered installaiton. |
| cpstall | 0 | integer4 | Limit of transaction log usage while executing consistency point, if blocks in use exceeds this value a CP stall is trigerred. |
| csp_pid | 0 | integer4 | Process id of the Cluster Server Process (CSP), valid in clustered installations only. |
| gcmt_numticks | 0 | integer4 | How long to wait before forcing a group commit buffer to the transaction log, units are processor ticks. |
| gcmt_threshold | 0 | integer4 | When the count of participating transactions in a log buffer exceeds this value group commit processing is enabled. |