rajasekhar24

 Profile Answers by rajasekhar24 

• May 9th, 2008

 

Bind the database to avoid the -805 error.

The package was not bound or it was dropped. If attempting to run a DB2 utility or CLI application, the DB2 utilities may need to be rebound to the database.

'%.pkgname' if the CURRENT PACKAGE PATH is set but no package with the name 'pkgname' could be found in any of the schemas in the CURRENT PACKAGE PATH.

yuvaevergreen

 Profile Answers by yuvaevergreen 

• Mar 26th, 2010

 

Be sure that the program has been preprocessed with no errors. If not, correct any errors which caused the preprocess to fail, preprocess the program and rerun it.

pawan_singh

 Profile Answers by pawan_singh 

• May 14th, 2010

 

He should rebind and new copy his program. -805 is a bind error.

pawan_singh

 Profile Answers by pawan_singh 

• May 14th, 2010

 

-805 is a bind error user needs to bind it again and some time we do the bind but forgot to new copy a online module in that case you can see -805 error.
Step to avoid same.
Do the rebind and new copy your module.

prakharsrivastava

 Profile Answers by prakharsrivastava 

• Jan 9th, 2011

 

SQL return -805 is because the program-name is not found in the plan,
We have to check for the correct program-name and then re-bind the pre-compiled program.

nishant

• Jul 26th, 2011

 

-805 means there is some bind issue.

talluri

 Profile Answers by talluri 

• Jul 27th, 2011

 

packeg not found in plan, we want to rebind that

Babjee Talluri

jzmoonrock56

 Profile Answers by jzmoonrock56 

• Aug 31st, 2011

 

Rebind the plan.

Mandar Dindorkar

 Profile Answers by Mandar Dindorkar 

• Jul 27th, 2012

 

-805 will never occur if a DBRM is directly bound to a PLAN. -805 occurs when

1) Source Program is changed and per-compiled and new LOAD Module created as a result of change is used at Run time, but BIND is not done using the latest created DBRM when change was done

2) If the collection Id (Package List) referred during the BIND PACKAGE is de-associated from the PLAN

3) For online programs, a CICS NEW COPY or CICS PHASE IN is not done after the first BIND after Program is created and invoked at Run-time. (Also Depends on PPT parameters used for module loading into CICS region at CICS startup)

There are many others. Check the IBM source PDF which lists all SQL codes, and Messages for DB2 zOS for more information

Yaswanth

• Jul 12th, 2021

 

Dbrm or package not found in olan