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 |
Explain the contents that are a part of dclgen.
What are the full forms of spufi and dclgen and why are they used?
What is clone table?
What is the connection string to connect to the DB2 Database ?
What is the maximum length of sqlca?
Explain dclgen.
What is runstats db2?
What is an alias and how does it differ from a synonym?
Which isolation level provides maximum concurrency?
How do you stop a db2 database in linux?
What is cursor stability in db2?
What is Skeleton cursor table (SKCT)?