SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME...NOT FOUND IN PLAN IDBSPLAN

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 attempting to read a trace following the following steps:  

Step 1.  From TPX menu go into insight

Step 2.  Choose option 8 (user started reports)

Step 3.  Choose option 2 (Start Menu)

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

Step 5. Setup report options.

Step 6: let report run til pauses.

Step 7.  Select report 

Step 8. Select plan.

Step 9. Place a T next to program to show sql text the following error is displayed after pressing enter:

Error encountered trying to OPEN the CURSOR for READING TE STSSTMT TABLE

DSNT4080I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME...NOT FOUND IN PLAN IDBSPLAN REASON 03

 

Environment

Release:
Component: CIDB

Resolution

Usually rebinding the PLAN fixes this problem but for this particular case the cause was user pointing to the wrong DBRM.