IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

-805 error saying load module is not able to find the PLAN


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ranjani
Warnings : 1

New User


Joined: 25 Oct 2006
Posts: 13

PostPosted: Sat Feb 24, 2007 8:04 am
Reply with quote

halo everyone,

i have a dbrm bound into a package. the Bind package is successful. When i try to run my cobol-db2 program i get a -805 error saying the load module is not able to find the plan. I dont know how to find in which plan, my package is bound.

how do i find the list of packages in a particular plan?

how do i link a set of packages to a plan?

thanks in advance
Back to top
View user's profile Send private message
wanderer

Active User


Joined: 05 Feb 2007
Posts: 199
Location: Sri Lanka

PostPosted: Sat Feb 24, 2007 10:00 am
Reply with quote

Usually a PLAN connects to a Package using Collection-id(also called packlist or pklist). When a PLAN is bound, in such a scenario, usually packlist is given a wild card or *. And no package name is given.

So check in a catalog table called sysibm.syspacklist to see if you have a PLANNAME that matches your plan name and it has a matching COLLID. By matching COLLID I mean the value you use to do SET PACKAGESET in the program.

Then check in sysibm.syspackage if you have a NAME and COLLID that match the package you are calling.

Usually the error also gives you the

location-name.collection-id.dbrmname.consistency -token that is not found. This should give you some clues.
Back to top
View user's profile Send private message
sachin_star3
Warnings : 1

New User


Joined: 30 Sep 2006
Posts: 78
Location: pune

PostPosted: Tue Feb 27, 2007 12:50 pm
Reply with quote

IF YOU SEE THE JCL FOR THE COBOLDB2 THERE IS BIND AND PLANE
ie.member name when you not give this properly then you will get -805
for you furter information i will give the whole jcl
//job
//jcllib order=ggg.db2proj.pds
//s1 exec db2
//trn.sysin dd dsn=ggfhh,disp=shr
//PC.SYSLIB DD DSN=DFG.PDS,DISP=SHR
//COB.SYSLIB DD DSN=SDF.PDS,DISP=SHR
//LKED.SYSLMODE DD DSN=SFD.PDS,DISP=SHR
//LKED.SYSIN DD*
INCLUDE SYSLIB(DSNCL1)
NAME VNEW55(R)
/*
//BILD EXEC PGM=IKJEFTO1,
//STEPLIB DD DSN=PDS
//SYSPRINT DD SYSOUT=*
//SYSIN DD *
DSN SYSTEM(DSN2)
BIND PLAN(BBB456) if you givw wronge plane name then you
MEMBER(M1) will get -805
VALIDATE(BIND)
ISOLATION(CS)
RELEASE(C)
EXPLAINE(NO)
OWENER(NEW)
LIB(B1-DRMLIB)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Error when install DB2 DB2 2
No new posts To find whether record count are true... DFSORT/ICETOOL 6
No new posts CLIST - Virtual storage allocation error CLIST & REXX 5
Search our Forums:

Back to Top