DESCRIPTION

CHAR(40)

Description of how to interpret the content of the VALUE column (see table Column DESCRIPTION)

VALUE

CHAR(12)

Value

MAX LOCKS

VALUE contains the number of available locks in the lock list

TRANS LIST REGIONS

VALUE contains the number of semaphores for transactions

TABLE LIST REGIONS

VALUE contains the number of semaphores for tables

ROW LIST REGIONS

VALUE contains the number of semaphores for rows

ENTRIES

VALUE contains an internal measure (entries) for the lock list size

USED ENTRIES

VALUE contains the number of entries for locks and lock requests

USED ENTRIES(%)

VALUE contains the percentage of entries used for locks and lock requests

AVG USED ENTRIES

VALUE contains the average number of entries used for locks and lock requests

AVG USED ENTRIES(%)

VALUE contains the average percentage of entries used for locks and lock requests

MAX USED ENTRIES

VALUE contains the maximum number of entries used for locks and lock requests

MAX USED ENTRIES(%)

VALUE contains the maximum percentage of entries used for locks and lock requests

OMS SHARE LOCK CONTROL ENTRIES

VALUE contains the number of control entries for OMS shared locks

OMS SHARE LOCK CONTROL ENTRIES USED

VALUE contains the number of control entries used for OMS shared locks

OMS SHARE LOCK ENTRIES

VALUE contains the number of OMS shared locks

OMS SHARE LOCK ENTRIES USED

VALUE contains the number of OMS shared locks used

OMS SHARE LOCK COLLISION ENTRIES USED

VALUE contains the number of control entries used for OMS shared locks

CONSISTENT VIEW ENTRIES

VALUE contains the number of consistent views

OPEN TRANS ENTRIES

VALUE contains the number of open transactions

LOCK ESCALATION VALUE

VALUE contains the number of table rows from which the lock rows are converted into table locks (lock escalation)

LOCK ESCALATIONS

VALUE contains the number of lock escalations

SQL LOCK COLLISIONS

VALUE contains the number of SQL lock requests that could not be satisfied (immediately)

OMS LOCK COLLISIONS

VALUE contains the number of OMS lock requests that could not be satisfied (immediately)

DEADLOCKS

VALUE contains the number of situations where at least two transactions collided with each other due to held and requested locks in such a way that this collision can be resolved only by implicitly ending a transaction

SQL REQUEST TIMEOUTS

VALUE contains the number of SQL lock requests that could not be satisfied because they had exceeded the maximum wait time

OMS REQUEST TIMEOUTS

VALUE contains the number of OMS lock requests that could not be satisfied because they had exceeded the maximum wait time

TRANSACTIONS HOLDING LOCKS

VALUE contains the number of transactions with assigned SQL locks

TRANSACTIONS REQUESTING LOCKS

VALUE contains the number of transactions requesting locks

TRANSACTIONS HOLDING OMS LOCKS

VALUE contains the number of transactions with assigned OMS locks

CHECKPOINT WANTED

If the VALUE column contains the value TRUE, the lock list is closed, that is, no exclusive lock can be assigned to a transaction without exclusive lock because a checkpoint was requested

SHUTDOWN WANTED

If the column VALUE contains the value TRUE, the lock list is closed because a shutdown was requested