How to enble the trace for particuler DB2 transaction from BTSQLSM1?

book

Article ID: 17170

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

We need the batch report BTSQLSM1 based on DB2 transaction instead of job(CORR-ID)



We need the batch report BTSQLSM1 based on DB2 transaction instead of job(CORR-ID)

So we need a GLOBAL filter WHERE class for DB2 transaction instead of the CORR-ID. 

 

Environment

z/os db2

Resolution

The transaction name is not available directly for the WHERE 

clause so you will need to use the corr id. 

 

As the CICS transaction name seems to be part of the correlation ID, 

you can just use a substring match in the WHERE 

 

WHERE: CORR-ID(,4,5) = 'KM43' 

 

It goes field-name(occurrence,length,position). Occurence is optional, position starts with 1.