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.
| Attribute Name | Key | Datatype | Description |
| vnode | 1 | varchar(64) | Ingres virtual node name |
| 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_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_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_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_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. |
| lxb_count | 0 | integer4 | Count of transactions operating on the database. |
| lxbo_count | 0 | integer4 | Count of ongoing transactions during an online checkpoint. |
| back_rec | 0 | varchar(32) | Database backup log sequence number (LSN). |
| back_trip | 0 | integer4 | High order part of database backup LSN. |
| back_offset | 0 | integer4 | Low order part of database backup LSN. |
| backup_rec | 0 | varchar(32) | 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_end | 0 | integer4 | Count of transactions completed in the database. |
| log_forces | 0 | integer4 | Count of log force operations for the database. |
| log_reads | 0 | integer4 | Count of log read operations for the database. |
| log_waits | 0 | integer4 | Count of log waits for the database. |
| log_writes | 0 | integer4 | Count of logical log writes for the database. |
| status_s | 0 | varchar(64) | Database status. |
| status | 0 | integer4 | Numeric database status. |