LOGQUEUESTATISTICS
The system table SYSINFO.LOGQUEUESTATISTICS specifies the number of times certain logging-related events were counted per log queue since the last start of the database.
|
QUEUEID |
FIXED(5) |
ID of the log queue |
|
QUEUE MAXUSED |
FIXED(5) |
Number of write transactions |
|
QUEUEI NSERTCOUNT |
FIXED(20) |
Number of log entries inserted into the log queue |
|
QUEUE OVERFLOWCOUNT |
FIXED(10) |
Number of wait situations due to log queue overflow |
|
GROUPCOMMITCOUNT |
FIXED(10) |
Number of log pages whose writing was waited for by more than one transaction |
|
WAITCOUNT |
FIXED(10) |
Number of COMMIT-/ROLLBACK entries |
|
MAXWAITCOUNTPERPAGE |
FIXED(10) |
Maximum number of transactions that simultaneously waited for the same log page to be written |
|
PHYSICALWRITECOUNT |
FIXED(10) |
Number of write operations |
Evaluating System Tables, LOGQUEUESTATISTICS
Concepts of the Database System, How Databases Log Data Changes