Show TOC

Object documentationLOCKSTATISTICSRESET

 

The system table SYSINFO.LOCKSTATISTICSRESET describes the degree to which lock management is being utilized and the number of special events that have occurred during lock management since the last RESET LOCKSTATISTICS or RESET ALL.

Structure

LOCKSTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

AVGUSEDENTRYCOUNT

FIXED(10)

Average number of entries used

AVGUSEDENTRYCOUNTPERCENTAGE

FIXED(3)

Average percentage of entries used

MAXUSEDENTRYCOUNT

FIXED(10)

Maximum number of entries used

MAXUSEDENTRYCOUNTPERCENTAGE

FIXED(3)

Maximum percentage of entries used

LOCKESCALATIONCOUNT

FIXED(10)

Number of lock escalations executed

SQLLOCKCOLLISIONCOUNT

FIXED(10)

Number of lock collisions for SQL database objects

OMSLOCKCOLLISIONCOUNT

FIXED(10)

Number of lock collisions for OMS objects

DEADLOCKCOUNT

FIXED(10)

Number of dead locks recognized

SQLREQUESTTIMEOUTCOUNT

FIXED(10)

Number of unfulfilled lock requests for SQL database objects

OMSREQUESTTIMEOUTCOUNT

FIXED(10)

Number of unfulfilled lock requests for OMS objects

More Information

LOCKSTATISTICS

Concepts of the Database System, SQL Locks