How to solve -805 error?



Get solution for your ABEND Codes & System Error Messages, SQL Codes, File Status etc...

How to solve -805 error?

Postby abkumarch » Tue Oct 30, 2007 8:36 pm

how to solve -805 ?
if u r telling tat change the name of plan or pgm , how ?
abkumarch
 
Posts: 21
Joined: Tue Oct 30, 2007 3:14 am
Has thanked: 0 time
Been thanked: 0 time

Re: How to solve -805 error?

 

Re: How to solve -805 error?

Postby dick scherrer » Wed Oct 31, 2007 2:26 am

Hello,

If you post complete info, we can better provide help.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 92 times

Re: How to solve -805 error?

Postby abkumarch » Wed Oct 31, 2007 4:41 pm

i got -805 sqlcode error while binding an embedded sql pgm,, how to solve it ?
abkumarch
 
Posts: 21
Joined: Tue Oct 30, 2007 3:14 am
Has thanked: 0 time
Been thanked: 0 time

Re: How to solve -805 error?

Postby dick scherrer » Wed Oct 31, 2007 9:39 pm

Hello,

To repeat
If you post complete info, we can better provide help.
You have not provided the complete info. More diagnostic info was presented when you received this error and you need to post it here.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 92 times

Re: How to solve -805 error?

Postby abhishek.kumar » Mon Nov 09, 2009 5:41 pm

The plan name you are reffering does not exists, check that you are referring to the correct plan name in SYSIN parameter

//SYSIN DD *
DSN SYSTEM(DB2B)
RUN PROGRAM(ABC) PLAN(ABC)
END

PLEASE MAKE SURE THAT PLAN NAME IS CORRECT WHICH YOU HAVE CREATED.
abhishek.kumar
 
Posts: 1
Joined: Tue Oct 13, 2009 5:28 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to solve -805 error?

Postby pmartyn » Thu Feb 28, 2013 8:15 pm

On the abend you should see a timestamp that corresponds to the plan/package in error. to deterine if it is missing you can either go to the DBRM LIBS and search or the DB2 catalog in the DBRM table. Even if found you may have the timestamp mis-match. You might have to have the DBA examine the versions and see why your version is missing (fell off the end maybe?). You may just need to re-compile/bind your program to pick up the latest version.
pmartyn
 
Posts: 42
Joined: Thu Feb 28, 2013 7:11 pm
Has thanked: 5 times
Been thanked: 3 times

Re: How to solve -805 error?

Postby c62ap90 » Thu Feb 28, 2013 8:25 pm

-805 DBRM or package not found in plan. { re-bind ? }
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 6 times

Re: How to solve -805 error?

Postby enrico-sorichetti » Thu Feb 28, 2013 8:33 pm

any reason to resurrect paleontological topics :geek:
abends-sql-codes/topic309.html
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2702
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 139 times


Return to ABENDS & SQL Codes

 


  • Related topics
    Replies
    Views
    Last post