Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Usage/Utiliy of Plan in DB2

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

New User


Joined: 20 Feb 2017
Posts: 2
Location: India

PostPosted: Thu Jun 21, 2018 8:16 pm    Post subject: Usage/Utiliy of Plan in DB2
Reply with quote

Hi,
It might seems a basic question but what is the advantage of using plan in COBOL - DB2 program ? In many shops I have seen that an individual program is using an individual plan to run COBOL - DB2 program . Can we use package instead of using plan in this case? What additional advantage does plan gives in this scenario?
Back to top
View user's profile Send private message

RahulG31

Active User


Joined: 20 Dec 2014
Posts: 429
Location: USA

PostPosted: Thu Jun 21, 2018 8:27 pm    Post subject: Reply to: Usage/Utiliy of Plan in DB2
Reply with quote

Read this: https://www.ibm.com/developerworks/data/library/dmmag/DMMag_2011_Issue3/Programmers/index.html

.
Back to top
View user's profile Send private message
arijitS

New User


Joined: 20 Feb 2017
Posts: 2
Location: India

PostPosted: Thu Jun 21, 2018 8:35 pm    Post subject:
Reply with quote

Hi,
RahulG31, Thanks for your reply. I have read this article and i an quoting from it
Quote:

Many PACKAGEs have characteristics in common. Maybe one group of PACKAGEs is used by the payroll application. Maybe another group is very popular and called by every program regardless of application area. Maybe they share a special, not so common BIND parameter like OPTHINT or REOPT(ALWAYS). DB2 has anticipated this situation by providing a high-level grouping name for your PACKAGEs.


Here i can understand that similar kind of packages are grouped together and is accessed by a plan . But couldn't we directly use package instead of going through the additional step of adding a plan ? Cant we use package directly for an individual program when there are no sub programs involved?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8361
Location: Dubuque, Iowa, USA

PostPosted: Thu Jun 21, 2018 9:49 pm    Post subject:
Reply with quote

From https://www.ibm.com/support/knowledgecenter/en/SSEPEK_10.0.0/intro/src/tpc/db2z_packagesandapplicationplans.html with emphasis added by me
Quote:
An application plan contains one or both of the following elements:

A list of package names

DB2 applications require an application plan. Packages make application programs more flexible and easier to maintain.
When IBM says something is required, they pretty much always mean that it is not optional.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 1939
Location: NY,USA

PostPosted: Thu Jun 21, 2018 10:10 pm    Post subject:
Reply with quote

You certainly required to go back to DB2 basics and therefor start from here.
Packages and application plans
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 Program usage statistics? John Poulakos CICS 6 Wed May 16, 2018 2:22 am
No new posts How do you attach a DB2 plan to a CIC... John Poulakos DB2 0 Wed Apr 18, 2018 1:49 am
No new posts How do I define a DB2 plan for a web ... John Poulakos CICS 5 Sat Apr 14, 2018 1:58 am
No new posts Finding the plan when code compiled u... Ahemad DB2 2 Fri Dec 01, 2017 6:38 pm
No new posts how can i move s9(9) to s9(9) usage comp HARENDRA CHOUDHARY COBOL Programming 3 Mon Nov 06, 2017 12:10 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us