Object documentationLOCKSTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.LOCKSTATISTICS describes the degree to which lock management is being utilized and the number of special events that have occurred during lock management since the database system was started.

Structure

LOCKSTATISTICS

ENTRYCOUNT

FIXED(10)

Number of entries available for locks and lock requests

USEDENTRYCOUNT

FIXED(10)

Number of entries used

USEDENTRYCOUNTPERCENTAGE

FIXED(3)

Percentage of entries used

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

TABLELOCKCOUNT

FIXED(10)

Number of table locks held

ROWLOCKCOUNT

FIXED(10)

Number of row locks held

HOLDERCOUNT

FIXED(10)

Number of transactions holding locks

REQUESTORCOUNT

FIXED(10)

Number of transactions for which there are lock requests

LOCKESCALATIONVALUE

FIXED(10)

Number of row locks from which the row locks are converted into table locks (lock escalation)

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

TRANSACTIONREGIONCOUNT

FIXED(5)

Number of regions used to administer the transaction

TABLEREGIONCOUNT

FIXED(5)

Number of regions used to administer the table locks

ROWREGIONCOUNT

FIXED(5)

Number of regions used to administer the row locks

More Information

LOCKSTATISTICSRESET

Concepts of the Database System, Locks