ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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

book

Article ID: 7541

calendar_today

Updated On:

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.

 

 

Powered by Wolken Software