SQLCODE -805 error DBRM or PACKAGE NAME NOT FOUND in Sysview for Db2 plan IDBSPLAN

Products

• SYSVIEW Performance Management Option for DB2 for z/OS

Issue/Introduction

When attempting to read a Sysview Performance Management Options for Db2 for z/OS (IDB2) trace encountering a SQL-805 error using the following steps:  

1. From the IDB2 main menu choose option 8 (User Started Reports)

2. Choose option 2 (Start Menu)

3. Chose option 4 (Hierarchical Application Probe (pauses when full))

4. Setup report options.

5. Let the report run until it pauses.

6.  Select report 

7. Select plan

8. Place a T next to program to show SQL text and the following error is displayed after pressing enter:

Error encountered trying to OPEN the CURSOR for READING TABLE
DSNT4080I SQLCODE = -805 ERROR: DBRM OR PACKAGE NAME...NOT FOUND IN PLAN IDBSPLAN REASON 03

Resolution

Rebinding the IDB2 plan typically resolves this SQL-805 error but for this particular case the cause was the incorrect hlq.CDBADBRM was used when the bind was completed.