Some SCRT reports for Sysview Performance Management Option for Db2 indicate version 00.00.00.

Products

• SYSVIEW Performance Management Option for DB2 for z/OS
• Database Management for DB2 for z/OS - Administration Suite
• Database Management for DB2 for z/OS - Performance Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Recovery Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

Some SCRT reporting for Sysview Performance Management Option for Db2 for z/OS (IDB2) indicate version 00.00.00. This occurs when the IDB2 batch report writer NSIGHTRW
is run and the JCL does NOT include a //PTILIB DD statement. (This DD has always been optional for the IDB2 report writer)

Resolution

Without PTILIB:

STC68563-------FRIDAY,  05/07/2024--------
STC68563       IEF695I  START IDB2AR11 WITH JOBNAME IDB2AR11 IS ASSIGNED TO USER
STC68563       $HASP373 IDB2AR11 STARTED
STC68563       IEF403I IDB2AR11 STARTED -TIME=01.04.02
STC68563       CAJR250I STEPNAME STEP   PGM=      CCODE EST-COST EXCPS ELAPSED TOT-CPU PAGE-IN P
STC68563       IEF170I 1 IDB2AR11 CAJR250I STEPNAME STEP PGM=  CCODE EST-COST   E
STC68563        CAJR251 I UNLOAD 1  IDCAMS       0000                $  .00        0          00:00:00.04
STC68563       IEF170I 1 IDB2AR11 CAJR251I UNLOAD            1 IDCAMS 0000     $  .00
STC68563       DBG39049I         01:04:02    INITIALIZING SYSVIEW FOR DB2 20.0
STC68563        CAJR251 I UNLOAD 2  IDB2UIFI      0000                $ 1.43             0          00:00:00.04.91   00:00:00.22
STC68563       IEF170I 1 IDB2AR11 CAJR251I UNLOAD            2 IDB2UIFI   0000     $  1.43
STC68563       IEC130I  PTILIB     DD STATEMENT MISSING <=====================================================
STC68563        CAJR251 I UNLOAD 3  INSIGHTRW   0004                $ 17.11             0          00:00:00.05.82   00:00:00.38 

  

With PTILIB:

STC68563-------TUESDAY,  09/07/2024--------
STC68563       IEF695I  START IDB2AR11 WITH JOBNAME IDB2AR11 IS ASSIGNED TO USER
STC68563       $HASP373 IDB2AR11 STARTED
STC68563       IEF403I IDB2AR11 STARTED -TIME=13.31.03
STC68563       CAJR250I STEPNAME STEP   PGM=      CCODE EST-COST EXCPS ELAPSED TOT-CPU PAGE-IN P
STC68563       IEF170I 1 IDB2AR11 CAJR250I STEPNAME STEP PGM=  CCODE EST-COST   E
STC68563        CAJR251 I UNLOAD 1  IDCAMS       0000                $  .00        0          00:00:00.04
STC68563       IEF170I 1 IDB2AR11 CAJR251I UNLOAD            1 IDCAMS 0000     $  .00
STC68563       DBG39049I         13:31:03    INITIALIZING SYSVIEW FOR DB2 20.0
STC68563       CAJR251 I UNLOAD 2  IDB2UIFI      0000                $ 1.43             0          00:00:00.04.91   00:00:00.22
STC68563       IEF170I 1 IDB2AR11 CAJR251I UNLOAD            2 IDB2UIFI   0000     $  1.43
STC68563       DBG39049I         13:31:10    HIGHEST MAINT LEVELSET IS 20.0.12 <====================================== 
STC68563        CAJR251 I UNLOAD 3  INSIGHTRW   0004                $ 21.75             0          00:00:00.05.05   00:00:00.48 
STC68563       IEF170I 1 IDB2AR11 CAJR251I UNLOAD            3 INSIGHTRW   0004     $  21.75

 

Note: If a PTILIB DD is added a PTIPARM DD must also be included.