Lock avoidance reporting in Sysview for Db2

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

How to obtain information about lock avoidance in Sysview Performance Management Option for Db2 for z/OS (IDB2)?

Resolution

Due to the high overhead of collecting this information, IDB2 does not have any capture of this data enabled by default.
If you want to see this information, enable the RECTRACE request (=8.2.6.7 using the UI menu) and it will show you this data.


The following is what you will see for each IFCID 223 produced: 

R/RECTRACE DETAIL TRACE OF DB2 ACTIVITY Row 279-309/27665 

Event Time Event Dur Event CPU Rtrn Lk Lck Lock Req/Ret Lock Req Lock 
Corr-ID Planname MM:SS.TTTT SS.TTTT Event zIIP Event Action Code Dr Ste Type Token Type Scope 
-------- -------- ---------- --------- ---------- ------------- ---- -- --- ---- -------- -------- ------ 
db2jcc_a DISTSERV 22:58.4391 xxx xxx xxxx Database: DSNDB06 Pageset: SYSTSTSP Pg#: 0000001D 

The following is what you will see for each IFCID 218 produced: 

R/RECTRACE DETAIL TRACE OF DB2 ACTIVITY Row 7940-7970/27665 

Event Time Event Dur Event CPU Rtrn Lk Lck Lock Req/Ret Lock Req Lock 
Corr-ID Planname MM:SS.TTTT SS.TTTT Event zIIP Event Action Code Dr Ste Type Token Type Scope 
-------- -------- ---------- --------- ---------- ------------- ---- -- --- ---- -------- -------- ------ 
db2jcc_a DISTSERV 22:58.4536 xxx xxx UOW Successful Test: Y 
Database: DSNDB06 Pageset: SYSUSER Successful Test: Y 
Database: DSNDB06 Pageset: SYSTSDBU Successful Test: N 
Database: DSNDB06 Pageset: SYSTSDBA Successful Test: N 
Database: DSNDB06 Pageset: SYSTSTAU Successful Test: N 
Database: DSNDB06 Pageset: SYSSTATS Successful Test: N 
Database: DSNDB06 Pageset: SYSTSFLD Successful Test: N 
Database: DSNDB06 Pageset: SYSTSKEY Successful Test: N 
Database: DSNDB06 Pageset: SYSTSIXS Successful Test: N 
Database: DSNDB06 Pageset: SYSTSTSP Successful Test: Y 
Database: DSNDB06 Pageset: SYSTSCOL Successful Test: N 
Database: DSNDB06 Pageset: SYSTSTAB Successful Test: Y 
Database: DSNDB06 Pageset: SYSTSQRY Successful Test: N 
Database: DSNDB06 Pageset: SYSTSPKS Successful Test: N 

Be careful not to let this request run all the time. The overhead for this request is quite high.