Show TOC

LOGQUEUESTATISTICSRESETLocate this document in the navigation structure

Definition

The system table SYSINFO.LOGQUEUESTATISTICSRESET specifies the number of times certain logging-related events were counted per log queue since the last RESET LOGQUEUESTATISTICS of the database.

Structure

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

More Information

Concepts of the Database System, How Databases Log Data Changes