search cancel

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)

book

Article ID: 187044

calendar_today

Updated On:

Products

Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Management for DB2 for z/OS - Performance Suite Database Management for DB2 for z/OS - SQL Performance Suite Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

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?

Environment

Release : 20.0

Component : CA Insight Database Performance Monitor for DB for z/OS

Resolution

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.