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
 

 

Do we have to give the Plan path in run jcl of COB+db2?

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

New User


Joined: 08 Jun 2005
Posts: 27

PostPosted: Wed Feb 08, 2006 4:09 pm    Post subject: Do we have to give the Plan path in run jcl of COB+db2?
Reply with quote

Hi,

Generally we are giving the plan name only in the Run JCL of cobol+db2 pgm.
e.g Plan((Plan name)
But we don't give the path(dataset lib) for that plan as we are giving for cobol load module. the question is How the JCL will find the paln where it is residing? How is it possible only with the plan name?

Please clarify this with e.g .


Thanks,
Sona.
Back to top
View user's profile Send private message

ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Wed Feb 08, 2006 4:16 pm    Post subject: Re: Do we have to give the Plan path in run jcl of COB+db2?
Reply with quote

Hi,
The job will get plan details from sstem catalog of subsytem you mentioned in the JCL.
Back to top
View user's profile Send private message
sonasheetal

New User


Joined: 08 Jun 2005
Posts: 27

PostPosted: Wed Feb 08, 2006 4:39 pm    Post subject: Do we have the more than one plan in the same system?
Reply with quote

Hi rags,

Thanks for ur quick reply, still I have one more doubt.

So U mean to say the plan will get stored in system cataloge from there the job will fetch. IS it?

Do we have the more than one plan with the same name in the sstem catalog of subsytem?

Thanks,
Sona.
Back to top
View user's profile Send private message
ragshere

New User


Joined: 20 Dec 2004
Posts: 70

PostPosted: Wed Feb 08, 2006 10:02 pm    Post subject: Re: Do we have to give the Plan path in run jcl of COB+db2?
Reply with quote

Hi sona,
plan name is Unique at subsytem level.So it will fetch its details easily.

If you want create plan for a program under same subsytem but different test region, you can put add a different suffix to plan name(one character to distinguish) in those regions while creating the plans.


Hope you got me.

Thanks
Rags
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 scheduling between OPC and TWS give u... nsbl IBM Tools 4 Sun Mar 12, 2017 5:35 pm
No new posts Bind plan as a member to another bind... rexx77 DB2 0 Thu Feb 16, 2017 2:02 am
No new posts Program and its corresponding plan vickey_dw DB2 4 Thu Apr 07, 2016 9:27 pm
No new posts Should we Rebind Plan if no SQL changes sappy_mf DB2 2 Thu Mar 03, 2016 2:13 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm


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