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 do you need to do before you do EXPLAIN ?
What are the contents of a dclmgen?
What is null indicator in db2?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Explain the benefits you can get from mainframe connect?
What are the two types of logging in the db2 database? Explain them.
What is clone table?
What do you do to keep the cursor from closing after a commit?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What are the benefits of using the db2 database?
How to rename a table in DB2 ?
Is ibm db2 free?