View previous topic :: View next topic
|
Author |
Message |
arunshan04
New User
Joined: 25 Apr 2009 Posts: 25 Location: chennai
|
|
|
|
can any one clear this i am working in cobol db2 stored procedure conversion project.
when i compiled my program i got the error plan not found.
i dont understand this the plan is created ?
and also let me know from the pakage how the plan is created ? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forum,
When you have a question, you should start a new topic rather than post a reply to some topic that has been inactive for more 2.5 years. . . It is also best to post in an appropriate part of the forum.
You need to speak with your dbas to learn how resources are managed on your system. Specifics vary greatly from site to site and you need to know what is used on your system. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
From arunshan04
Copied from the unrelated topic
000001 //DB2BND JOB LEM01,'MAC',CLASS=Q,MSGCLASS=X,
000002 // NOTIFY=&SYSUID,REGION=0M
000003 //*
000004 //PACKBND EXEC PGM=IKJEFT01,REGION=4096K,
000005 // DYNAMNBR=75
000006 //STEPLIB DD DSN=DSN510.SDSNLOAD,DISP=SHR
000007 // DD DSN=SYS1.DSN510.SDSNEXIT,DISP=SHR
000008 // DD DSN=DSN510.RUNLIB.LOAD,DISP=SHR
000009 // DD DSN=IBMMF.CICS410.LOADLIB,DISP=SHR
000010 //DBRMLIB DD DSN=IBMMFS.MACC.DBRM,DISP=SHR <= DBRM LIBRARY
000011 //SYSTSPRT DD SYSOUT=A
000012 //SYSPRINT DD SYSOUT=A
000013 //SYSUDUMP DD SYSOUT=A
000014 //SYSTSIN DD *
000015 DSN SYSTEM(DSN)
000016 BIND PACKAGE(DB2IBMC) MEM(PGM158L) - <= VALID CICS PACKAGE
000017 LIBRARY('IBMMFS.MACC.DBRM') - <= DBRM LIBRARY
000018 RELEASE(COMMIT) ISOLATION(CS) -
000019 VALIDATE(RUN)-
000020 OWNER(IBMMFS) ACTION(REPLACE) <= USER/SQL ID
000021 /*
in this jcl they are creating package from the bdrm
so how they are creating plan for this package. is there any syntax is there to create the plan.
i am sorry i am very new to db2 but i want to know in and out in db2
or suggest me any materiel.
______________
Arun S |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Please do not post more replies to the "other" topic.
At the top of the page is a link to "IBM Manuals" among which are multiple sets of DB2 manuals. Pick the ones fro your release of DB2.
Also, look in the DB2 part of the forum as there are very many topics that have a wealth of info. |
|
Back to top |
|
|
|