Where to turn on IFCID221 IFCID222 IFCID342 IFCID343

book

Article ID: 102978

calendar_today

Updated On:

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 Plan Analyzer for DB2 for z/OS CA Subsystem Analyzer for DB2 for z/OS

Issue/Introduction

Where can IFCIDS221,222 and 342 and 343 be turned on in IDDCPRMS if that's possible? Will their records be available in the product or is it better to run the trace for these IFCIDS outside the product?
 

Environment

Release:
Component: CIDB

Resolution

The IDB2 sysparms HIST-STATS-RECS= parm is where you can add the IFCIDs but before making that change make sure to understand the performance impact of the IFCIDs being added. The recommendation is to  start these trace outside of IDB2 instead of having them done in the product.