If two Db2 versions (v11 and v12) are mixed in a SMF file how should the Sysview for Db2 DB2VER parameter in the IDRWPRM JOB (Batch report job) be specified
search cancel

If two Db2 versions (v11 and v12) are mixed in a SMF file how should the Sysview for Db2 DB2VER parameter in the IDRWPRM JOB (Batch report job) be specified

book

Article ID: 187044

calendar_today

Updated On:

Products

SYSVIEW Performance Management Option for DB2 for z/OS Insight Performance Monitor for DB2 UDB for z/OS

Issue/Introduction

If two Db2 versions (v11 and v12)  are mixed in a SMF file, how should the DB2VER parameter in the IDRWPRM JOB (Batch report job) be specified
for Sysview Performance Management Option for Db2 for z/OS (IDB2).

Resolution

The DB2VER in 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 must know which record layout has to be used.
You can see several samples about how DB2VER parameter works in the Batch Reports in hlq.CDBATREQ library members BTSTASM1 and BTSTASM2.

If the input SMF file contains both the records of the Db2 12 and records of the Db2 11, you must 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.