How to resolve -805 error in DB2?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of rollback and commit?

587


What db2 400?

670


What kind of database is db2?

563


Mention the location where the output received from explain statement is stored.

624


What is an instance database?

590






What are host variables in db2?

614


How connect db2 database to datastage?

754


What language is db2 written in?

591


i want to maintain uniqueness on pdf without make lf??????????

1624


Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

617


What is a db2 tablespace?

591


What is db2 bind?

631


What os does db2 run on?

565


Is db2 free?

676


Is db2 relational database?

567