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

book

Article ID: 7541

calendar_today

Updated On:

Products

CA Bind Analyzer for DB2 for z/OS CA Detector CA SQL-Ease for DB2 for z/OS CA Sysview Performance Management Option for DB2 for z/OS CA Database Detector for DB2 for z/OS CA Plan Analyzer for DB2 for z/OS CA 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.