The system table SYSINFO.LOGQUEUESTATISTICSRESETspecifies the number of times certain logging-related events were counted per log queue since the last RESET LOGQUEUESTATISTICS of the database.
RESETDATE |
TIMESTAMP |
Time of the last RESET for these entries |
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 |
Concepts of the Database System, How Databases Log Data Changes