ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.
If two DB2 versions (V11.1 and V12.1) are mixed in a SMF file, how should the DB2VER parameter in the IDRWPRM JOB (Batch report job) be specified? (Sysview Performance Management Option for DB2 for z/OS)
Article ID: 187044
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/OSDatabase Management for DB2 for z/OS - Performance SuiteDatabase Management for DB2 for z/OS - SQL Performance SuiteDetector for DB2 for z/OSInsight Performance Monitor for DB2 UDB for z/OS
If two DB2 versions (V11.1 and V12.1) are mixed in a SMF file, how should the DB2VER parameter in the IDRWPRM JOB (Batch report job) be specified?
Release : 20.0
Component : CA Insight Database Performance Monitor for DB for z/OS
It (the DB2VER in the IDRWPRM) depends on the SMF records that customer wanted to process. DB2VER=11.1 for DB2 11 SMF records. DB2VER=12.1 for DB2 12 SMF records. The SMF record layout is different for each DB2 Version, so the Batch Reports have to know which record layout has to be used. You can see several samples about how DB2VER parameter works in the Batch Reports in R200.CDBATREQ library, see members BTSTASM1 and BTSTASM2.
If the input SMF file contains both the records of the DB2V12 and records of the DB2V11, you have to run two Jobs to select the appropriate SMF records. One with DB2VER=11.1 for DB2 11 SMF records and the other with DB2VER=12.1 for DB2 12 SMF records.