Report on QTXAQRY - Lock Queries

Article Id: 7276

Status: Published

Updated On: 14-02-2018 08:14

Legacy Id: TEC1212377

Products:

CA Bind Analyzer for DB2 for z/OS , 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:

Is there any way to report on the Lock Queries for DB2 field QTXAQRY?

Environment:

Release:
Component: CIDB

Resolution:

Batch report BTACTSML provides info on the LOCK Queries for DB2 field QTXAQRY. It's in the HGHLVL.CDBATREQ.