Bind Analyzer for DB2 for z/OSSQL-Ease for DB2 for z/OSSYSVIEW Performance Management Option for DB2 for z/OSPlan Analyzer for DB2 for z/OSSubsystem Analyzer for DB2 for z/OS
Issue/Introduction
How to run Reports BTPLIOSM and BTPSIOSM against SMF records?
We want to run Reports BTPLIOSM and BTPSIOSM against SMF records instead of insight trace records. We tried statistics CLASS(8) IFCID(199) but no results. We don't want to use the insight trace records because of the volume of records created. So can you tell us what SMF records we need ?
Environment
z/os db2
Resolution
These reports BTPLIOSM and BTPSIOSM do not read IFCID 199. They read Ifcids's 6,7,8,9 and 10 So you would need a trace like this START TRACE (PERFM) DEST(SMF) IFCID(6,7,8,9,10)