Database Management Technology

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

logging_stats_prim

The logging_stats_prim table contains logging system activity statistics for the current installation.  One row is returned for each vnode in the current IMA management domain.  

 
Attribute Name Key Datatype Description
vnode 1 varchar(64) Ingres virtual node name
dual_read_ios 0 integer4 Count read operations from the dual transaction log since installation startup.
dual_write_ios 0 integer4 Count of write operations to the dual transaction log since installation startup.
txn_ends 0 integer4 Count of transactions completed since installation startup.
log_forces 0 integer4 Count of force operations to the current transaction log since installation startup.
kbytes 0 integer4 Measure of logging data written to the transaction log since installation startup, units are Kbytes.
log_read_ios 0 integer4 Count of read operations from the primary transaction log since installation startup.
log_write_ios 0 integer4 Count of physical writes to the primary transaction log.
split_waits 0 integer4 Count of log waits initiated by split write operations.
log_waits 0 integer4 Count of log wait operations since installation startup.
log_writes 0 integer4 Count of logical writes to logging system buffers.
writeio 0 integer4 Count of physical writes to the transaction log.
lfb_status 0 integer4 Numeric value for transaction log file status.
prim_last_block 0 integer4 Most recent block written to the primary transaction log.
dual_last_block 0 integer4 Last block read or written to/from the primary transaction log.
lfbb_size 0 integer4 Maximum number of log file blocks which can be allocated by the logging system.
ldb_inuse 0 integer4 Number of log database blocks currently in use, this is the number of open databases.
ldbb_count 0 integer4 Number of log database blocks allocated by the logging system.
lfbb_count 0 integer4 Count of lof file block allocated by the logging system.
lpb_inuse 0 integer4 Count of log process blocks currently in use.
lpb_allocated 0 integer4 Count of log process blocks allocated by the logging system.
lpd_inuse 0 integer4 Count of log process database blocks currently in use.
lpd_allocated 0 integer4 Count of log process database blocks allocated by the logging system.
lxb_inuse 0 integer4 Count of transaction blocks currently in use.
lxbb_allocated 0 integer4 Count of transaction blocks allocated by the logging system.
no_bcp 0 integer4 If 1, consistency point is in progress and a new one cannot be started.
protect_count 0 integer4 Current count of protect transactions, that is transactions which must be rolled back if aborted.
db_add 0 integer4 Count of database add operations since installation startup.
bcp_stall_waits 0 integer4 Log stalls caused by BCP (begin consistency point) writes.
txn_begins 0 integer4 Count of transactions started since installation startup.
dual_readio 0 integer4 Count of read operations from the dual transaction log since installation startup.
dual_writeio 0 integer4 Count of write operations to the dual transaction log since installation startup.
lgd_txn_ends 0 integer4 Count of transactions completed by the logging system since installation startup.
force 0 integer4 Count of log buffers forced to the transaction log.
free_waits 0 integer4 Count of waits for free log buffers since installation startup.
group_count 0 integer4 Count of log buffers written during group commit processing.
group_force 0 integer4 Count of log buffers forced to the transaction log during group commit processing.
inconsistent_db 0 integer4 Count of databases marked inconsistent since installation startup.
kbytes_written 0 integer4 Measure of logging data written to all active transaction logs since installation startup, units are Kbytes.
log_readio 0 integer4 Count of read operations from all configured transaction logs since installation startup.
log_writeio 0 integer4 Count of physical writes to the transaction log.
pgyback_check 0 integer4 Count of piggyback write checks since installation startup.
pgyback_write 0 integer4 Count of write operations initiated by piggyback write.
readio 0 integer4 Count of physical read operations from the transaction log.
db_remove 0 integer4 Count of database remove operations since installation startup.
split 0 integer4 Count of split write operations since installation startup.
stall_wait 0 integer4 Count of log write operations stalled.
wait 0 integer4 Count of log waits since installation startup.
log_write 0 integer4 Count of logical log writes performed since installation startup.
lgd_writeio 0 integer4 Count of physical writes to all transaction logs performed by the logging system since installation startup.

 


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