Where to turn on IFCID221 IFCID222 IFCID342 IFCID343
book
Article ID: 102978
calendar_today
Updated On:
Products
CA Bind Analyzer for DB2 for z/OSCA DetectorCA SQL-Ease for DB2 for z/OSCA Sysview Performance Management Option for DB2 for z/OSCA Database Detector for DB2 for z/OSCA Plan Analyzer for DB2 for z/OSCA 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.