Database Management Technology

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

logging_config_prim

The logging_config_prim table contains logging system configuration statistics for the current installation.  This table returns one row per vnode in the current IMA management domain.  Configuration values do not change while the installation is running.

 
Attribute Name Key Datatype Description
vnode 1 varchar(64) Ingres virtual node name
log_buffers 0 integer4 Count of allocated log buffers used to transfer logging records to the transaction log.
abort_blocks 0 integer4 Count of blocks in use to invoke Force Abort processing.
cp_blocks 0 integer4 Count of blocks between consistency points, defines the frequency of consistency points.
full_blocks 0 integer4 When blocks in use exceeds this value transactions are suspended until log file space can be reclaimed.
block_size 0 integer4 Transaction log block size in bytes, this is the transfer size from memory to the transaction log.
block_count 0 integer4 Count of log blocks in the transaction log (log file size in block units).
db_limit 0 integer4 Maximum number of databases registered with the logging system, limits the number of open databases.
server_limit 0 integer4 Maximum number of servers registered with the logging system.
proc_db_limit 0 integer4 Maximum number of server to database connections in the logging system.
tx_limit 0 integer4 Maximum number of transactions in the logging system.
logwriter_threads 0 integer4 Count of log writer threads, this is the sum of log writer threads for all servers in the installation.
file_version 0 integer4 Transaction log format version.
check_stall 0 integer4 When transaction log blocks in use exceeds this value begin checking for log full and stall conditions.
node_id 0 integer4 Node id for the local node in a clustered installaiton.
cpstall 0 integer4 Limit of transaction log usage while executing consistency point, if blocks in use exceeds this value a CP stall is trigerred.
csp_pid 0 integer4 Process id of the Cluster Server Process (CSP), valid in clustered installations only.
gcmt_numticks 0 integer4 How long to wait before forcing a group commit buffer to the transaction log, units are processor ticks.
gcmt_threshold 0 integer4 When the count of participating transactions in a log buffer exceeds this value group commit processing is enabled.

 


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