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 |
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What keyword does an SQL SELECT statement use for a string search?
What are delete-connected tables?
How many types of page locks can be held in db2?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
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
What is the SQL Communications Area and what are some of its key fields?
Why use RUNSTAT Utility?
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?
What are packages in db2?
What is REORG? When is it used?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?