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 |
QUEUEMAXUSED |
FIXED(5) |
Number of write transactions |
QUEUEINSERTCOUNT |
FIXED(20) |
Number of log entries inserted into the log queue |
QUEUEOVERFLOWCOUNT |
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