Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Error - plan not found

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
arunshan04

New User


Joined: 25 Apr 2009
Posts: 25
Location: chennai

PostPosted: Tue Nov 03, 2009 12:36 am    Post subject:
Reply with quote

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
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 03, 2009 12:55 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 03, 2009 1:27 am    Post subject:
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Nov 03, 2009 1:30 am    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts IDC2902I Error tzeche ABENDS & Debugging 2 Tue Mar 28, 2017 11:39 am
No new posts Record Not found in AlX but record re... mukun264 COBOL Programming 7 Fri Mar 24, 2017 9:28 am
No new posts Need help with below DB2 error ashek15 DB2 3 Sat Mar 18, 2017 5:56 am
No new posts FINDREP Syntax Error seahawk789 DFSORT/ICETOOL 4 Thu Mar 09, 2017 10:11 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us