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

book

Article ID: 213302

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

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.  

 

Environment

Release : 20.0

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

Resolution

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'

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/reference/ifcid-records/record-list/event-trace-records/lock-information.html     

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

Https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0.html

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

https://techdocs.broadcom.com/us/en/ca-mainframe-software/database-management/ca-sysview-performance-management-option-for-db2/20-0/configuring/data-collector-dc/how-dc-uses-db2.html