IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search Log in to check your private messages Log in
 

Usage/Utiliy of Plan in DB2


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
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
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: 446
Location: USA

PostPosted: Thu Jun 21, 2018 8:27 pm
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
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: 8568
Location: Dubuque, Iowa, USA

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

From Use [URL] BBCode for Links 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

Global Moderator


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

PostPosted: Thu Jun 21, 2018 10:10 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 

Search our Forum:

Similar Topics
Topic Forum Replies
No new posts DB2 group member usage DB2 0
No new posts current batch plan DB2 3
No new posts Any limit on usage of cursors ? DB2 1
No new posts Usage of processor directive and firs... PL/I & Assembler 4
No new posts usage of CASE in WHERE clause DB2 10

Back to Top