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

How to run db2 command in windows?

0 Answers  


What is COPY PENDING status?

6 Answers  


What is the difference between nvl and coalesce?

0 Answers  


Is schema the same as database?

0 Answers  


is it compulsory commitment control in journal?

0 Answers   TCS,






If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  


I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).

10 Answers   Cap Gemini, Wipro,


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,


What is collection in db2 bind?

0 Answers  


What Utility is used to migrate DB2 from one release to the next?

1 Answers  


Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?

1 Answers  


how can u retrieve the data from null values using applicaion program.

3 Answers   TCS,


Categories