How to resolve -805 error in DB2?



How to resolve -805 error in DB2?..

Answer / lakshmi

Reason for Sql Code -805: The application program attempts
to use a DBRM package that is not found ('location-
name.colection-id.dbrm-name.consistency-token').

Solution:
1. Rebind the program with the correct DBRM library name.
2. The plan name used in the JCL and the plan used for bind
should be same.

Is This Answer Correct ?    39 Yes 3 No

Post New Answer

More DB2 Interview Questions

what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx

2 Answers   IBM,


What keyword does an SQL SELECT statement use for a string search?

2 Answers  


What are delete-connected tables?

1 Answers  


How many types of page locks can be held in db2?

0 Answers  


If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?

2 Answers  






if there is a table with huge number of records and if i want to extract only first 3 records from the table, what query i have to provide to retreive first 3 records

4 Answers   UST,


What is the SQL Communications Area and what are some of its key fields?

1 Answers  


Why use RUNSTAT Utility?

3 Answers   Merrill Lynch,


Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?

8 Answers  


What are packages in db2?

0 Answers  


What is REORG? When is it used?

4 Answers  


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  


Categories