The log_dbs table contains statistics for each database registered with the logging system. The first user to open a database adds that database to the registered database list and the last user to disconnect from the database causes that database to be removed from the registered database list. Delta columns represent the change in counter values since 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 |
| delta_seconds | 0 | integer4 | Elapsed time (seconds) since the previous refresh. |
| ldb_index | 2 | integer4 | Logging system internal identifier for the database. |
| buffer | 0 | varchar(32) | Database information buffer, the database name. |
| first_log_rec | 0 | varchar(32) | Log address of the first dump record for the database. |
| first_log_block | 0 | integer4 | Block number of the first dump record for the database. |
| first_log_offset | 0 | integer4 | Block offset of the first dump record for the database. |
| first_log_trip | 0 | integer4 | Trip counter for the log address of the first dump record. |
| last_log_rec | 0 | varchar(32) | Log address of the last dump record for the database. |
| last_log_block | 0 | integer4 | Block number for the log address of the last dump record. |
| last_log_offset | 0 | integer4 | Block offset for the log address of the last dump record. |
| last_log_trip | 0 | integer4 | Trip counter for the log address of the last dump record. |
| db_id | 0 | integer4 | External database id for the database. |
| db_name | 0 | varchar(32) | Database name. |
| db_owner | 0 | varchar(32) | Database owner. |
| instance | 0 | integer4 | Instance identifier. |
| first_jnl_rec | 0 | varchar(32) | Starting log address of the database journal window. |
| first_jnl_block | 0 | integer4 | Block number for the starting address of the database journal window. |
| first_jnl_offset | 0 | integer4 | Block offset for the starting address of the database journal window. |
| first_jnl_trip | 0 | integer4 | Trip counter for the starting address of the database journal window. |
| last_jnl_rec | 0 | varchar(32) | Ending log address for the database journal window. |
| last_jnl_block | 0 | integer4 | Block number of the log address for the end of the database journal window. |
| last_jnl_offset | 0 | integer4 | Block offset of the log address for the end of the database journal window. |
| last_jnl_trip | 0 | integer4 | Trip counter of the log address for the end of the database journal window. |
| l_buffer | 0 | integer4 | Database information block length. |
| lpd_count | 0 | integer4 | Reference count for the database. |
| lpd_count_d | 0 | integer4 | Change in database reference count in the last interval. |
| lxb_count | 0 | integer4 | Count of transactions operating on the database. |
| lxb_count_d | 0 | integer4 | Change in database transaction count in the last interval. |
| lxbo_count | 0 | integer4 | Count of ongoing transactions during an online checkpoint. |
| lxbo_count_d | 0 | integer4 | Change in ongoing transaction count in the last interval. |
| back_rec | 0 | varchar(32) | Database backup log sequence number (LSN). |
| back_block | 0 | integer4 | High order part of database backup LSN. |
| back_offset | 0 | integer4 | Low order part of database backup LSN. |
| back_trip | 0 | integer4 | High order part of database backup LSN. |
| backup_rec | 0 | varchar(32) | Database start backup log address. |
| backup_block | 0 | integer4 | Block number of the database start backup log address. |
| backup_offset | 0 | integer4 | Block offset of the database start backup log address. |
| backup_trip | 0 | integer4 | Trip counter of the database start backup log address. |
| txn_begins | 0 | integer4 | Count of transactions started in the database. |
| txn_begins_d | 0 | integer4 | Count of transactions started in the database in the last interval. |
| txn_end | 0 | integer4 | Count of transactions completed in the database. |
| txn_end_d | 0 | integer4 | Count of transactions completed in the database in the last interval. |
| log_forces | 0 | integer4 | Count of log force operations for the database. |
| log_forces_d | 0 | integer4 | Count of log force operations for the database in the last interval. |
| log_reads | 0 | integer4 | Count of log read operations for the database. |
| log_reads_d | 0 | integer4 | Count of log read operations for the database in the last interval. |
| log_waits | 0 | integer4 | Count of log waits for the database. |
| log_waits_d | 0 | integer4 | Count of log waits for the database in the last interval. |
| log_writes | 0 | integer4 | Count of logical log writes for the database. |
| log_writes_d | 0 | integer4 | Count of logical log writes for the database in the last interval. |
| status_s | 0 | varchar(64) | Database status. |
| status | 0 | integer | Numeric database status. |