LOCKSTATISTICS 
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
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 |