Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 447
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: 8479
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: 2247
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 FORMATTIME - CPU usage Nileshkul CICS 3 Sun Aug 18, 2019 5:22 am
No new posts ALTERNATE RECORD KEY usage for KSDS AIX sophia.lee COBOL Programming 1 Thu Jul 25, 2019 7:28 am
No new posts Storage usage in a web service provider. John Poulakos CICS 0 Tue Jun 04, 2019 8:12 pm
No new posts zIIP usage for IIB components yogi.47eie Testing & Performance analysis 0 Thu Jan 03, 2019 4:46 pm
No new posts Log an Plan name/id or Job Id using D... SENTHIL MURUGAAN DB2 1 Mon Oct 22, 2018 4:17 pm

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