DROP of PTDB Tables effect on SYSVIEW FOR DB2 AKA INSIGHT(IDB2).

Products

• 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 - Recovery Suite
• Database Management for DB2 for z/OS - SQL Performance Suite
• Database Management for DB2 for z/OS - Utilities Suite

Issue/Introduction

As part of Pre-DB2 13 Work is to convert SIMPLE to UTS.

PTI.PTRCQ_SAVED_RPTS

PTDB.PTIRCQTS

Table is defined in a Simple TS they were trying to convert and dropped it.

Only product we use for DB2 purposes is SYSVIEW aka INSIGHT for Z/OS.

Does INSIGHT need that Table for any reason? Can we not recreate it?

Environment

Release : 20.0

Resolution

Table is defined in a Simple TS they were trying to convert and dropped it. Insight(IDB2) or Sysview for Db2 Performance for Z/OS doesn't use PTDB. IDB2 has its own objects located in HIGHLVL.CDBASKL0(ARCDDL) or HGHLVL.SOURCE(ARCDDL). PTDB is for the rest of CA/Broadcom db2 tools products like Detector, Plan Analyzer, etc...