Database Management Technology

Architecture | Monitor | Sentinel | Query | Testimonials | Documentation | Downloads
Courses | On-Site Courses | Course Schedule | Testimonials |
DBAnalyzer | JVM
Contact Info

log_dbs

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.

 


About DMT | Contact Us | ©2004 Database Management Technology, Inc. All rights reserved.