Database Management Technology

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

log_procs

The log_procs table contains logging system statistics specific to each server registered with the logging system.  One row is returned for each registered logging system server, this includes the archive, recovery, and database servers.  Delta columns represent changes 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.
lpb_index 2 integer4 Internal log process block identifier.
buffer_mgr_id 0 integer4 Internal identifier of the buffer manager used by the server.
cond 0 integer4 Fast commit server condition, 1 LPB_CPREADY, 2 LPB_CPWAIT, 3 LPB_RECOVER.
force_abort_sid 0 integer4 Session id of the servers Force Abort Thread.
gcmt_asleep 0 integer4 Group commit thread sleep counter.
gcmt_sid 0 integer4 Session id for the server Group Commit Thread.
instance 0 integer4 Internal instance identifier for the process block.
lpd_count 0 integer4 Count of databases currently opened by the server.
lpd_count_d 0 integer4 Change in the open database count in the last interval.
pid 0 integer4 Operating system process id for the server.
txn_begins 0 integer4 Count of transactions started by the server.
txn_begins_d 0 integer4 Count of transactions started by the server in the last interval.
txn_ends 0 integer4 Count of transactions completed by the server.
txn_ends_d 0 integer4 Count of transactions completed by the server in the last interval.
log_forces 0 integer4 Count of log force operations performed by the server.
log_forces_d 0 integer4 Count of log force operations performed by the server in the last interval.
log_readios 0 integer4 Count of log read operations performed by the server.
log_readios_d 0 integer4 Count of log read operations performed by the server in the last interval.
log_waits 0 integer4 Count of log waits for the server.
log_waits_d 0 integer4 Count of log waits for the server in the last interval.
log_writes 0 integer4 Count of logical log write operations initiated by the server.
log_writes_d 0 integer4 Count of logical log write operations initiated by the server in the last interval.
lpb_status_s 0 varchar(64) Server status string.
lpb_status 0 integer4 Numeric status for server.

 


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