CA-PPA Package Reports Output Inaccurate

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

Issue/Introduction

When comparing the reports generated by PPA Package Reports with RC/Q , there were discrepancy between the two reports. The PPA Package Reports do not seem to be accurate.
DB2 Object ===> PK Option ===> L Where => N Package ===> GETPRCOL > Owner ===> * > Collection ===> * > Grantor ===> * > Version ===> * >

PQPKL 19.0 -------- RC/Q Application Package List -------- 18/06/11 14:35 COMMAND ===> SCROLL ===> CSR DB2 Object ===> PK Option ===> L Where => N Package ===> GETPRCOL > Owner ===> * > Collection ===> * > Grantor ===> * > Version ===> * > Loc: LOCAL ---------- SSID: DBXU ----
------PRGISAA - LINE 1 OF 6 > CMD NAME OWNER COLLECTION V O E BINDDATE BINDTIME ________ GETPRCOL DB2DBA BSCADPOP Y Y Y 2018/06/11 14:27:17 ________ GETPRCOL TOGRP BSCADPOP N Y Y 2017/04/11 16:59:45 ________ GETPRCOL DB2DBA BSCADPOP Y Y Y 2018/02/18 16:59:36 ________ GETPRCOL TOGRP BSCOP Y Y Y 2018/06/11 14:27:40 ________ GETPRCOL TOGRP BSCOP N Y Y 2017/04/11 17:01:44  Why the difference between the two?
 

Environment

Release:
Component: ANLDB2

Resolution

The difference was caused by the following Plan Analyzer Explain Profile options,
Changing  thePackage version(s) default ===) L (A=All, L=Latest version) to Package version(s) default ===) A (A=All, L=Latest version) resolved the difference.