IBM Books

Total Lock List Memory In Use


Snapshot Information Level
Database

API Structure(s)
sqlm_dbase

Monitor Group
Basic

Resettable

No

 

API Element Name
Element Type

lock_list_in_use
gauge

 

Description:  The total amount of lock list memory (in bytes) that is in use.

Usage:  This element may be used in conjunction with the locklist configuration parameter to calculate the lock list utilization. If the lock list utilization is high, you may want to consider increasing the size of that parameter. See the Administration Guide for more information.
Note:When calculating utilization, it is important to note that the locklist configuration parameter is allocated in pages of 4K bytes each, while this monitor element provides results in bytes.

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]