What is the class for Detector trace and ICFID records

Products

• Detector for DB2 for z/OS

Issue/Introduction

Detector for Db2 for z/OS (PDT) Initialize SQL trace IFCID records.

Resolution

For Detector using Option 8, Additional features:

When selecting all the options the full Trace Request will "normally" look like this:

-START TRACE(PERFM) TDATA(CORRELATION,CPU) CLASS(30 )
DEST(OPX) BUFSIZE(0600) PLAN(pppppppp) AUTHID(aaaaaaaa)
IFCID(15,16,17,18,21,22,53,55,58,59,60,61,62,63,64,65,
66,68,69,70,71,72,73,74,75,84,85,86,87,88,89,95,96,105,
107,21,157,158,159,160,161,162,163,165,166,167,168,169,
180,181,182,183,233)


The IFCIDs with no options selected will be:
15,16,17,18,22,53,55,58,59,60,61,62,63,64,65,
66,68,69,70,71,72,73,74,75,84,85,86,87,88,89,95,96,105,107


Selecting LOCKING will add the following to the IFCID list:
21

Selecting DISTRIBUTED DATA will add:
157,158,159,160,161,162,163,165,166,167,168,169,180,181,182,183,233