Linking Deadlocks to SQL with Insight

book

Article ID: 16011

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

linking Deadlocks to the problematic SQL causing the Deadlock. 



A user would like to know if she can link deadlocks to the problematic SQL using 

CA SYSVIEW for DB2?

Environment

z/os DB2

Resolution

In the LOCKCONT screen you can put a "T" against an entry to see the SQL statement(if it is available). 

 

The HELP for the LOCKCONT screen gives more info. 

Here it is. 

 

**************** 

Starting with DB210,you may use the T line command to retrieve SQL information based on the statement ID in the trace record. 

If the SQL is dynamic SQL, using the T line command will cause CA SYSVIEW for DB2 to display the performance information, 

including the dynamic SQL statement text(DYNSQLTX IQL request),for the 

selected statement if it is available in the cache. 

 

If the SQL is static SQL, the T line command will cause CA SYSVIEW for DB2 to retrieve and display the SQL statement text 

from the DB2 catalog.