ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Question on Sysview for Db2 (IDB2) monitoring ability


Article ID: 213302


Updated On:


SYSVIEW Performance Management Option for DB2 for z/OS


Can Sysview for Db2 (IDB2) monitor DB2 lock information?  Specifically on what job and or transaction is holding the lock and its length plus the data impacted.  



Release : 20.0

Component : CA SYSVIEW Performance Management Option for DB2 for z/OS


It is IFCID149 LOCK-HOLDERS that will provide this information (LOCK-HOLDERS records lock information, such as threads that hold locks on a resource and 
threads that are waiting for locks on a resource to be released, for a given resource.)


Additional Information

The following link provides 'Lock Information'     

Also, the complete Sysview Performance Management Option for Db2 documentation is here:


Another link of interest for your understanding on how IDB2 interfaces with Db2: