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
 
Execution Process when using packages

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

New User


Joined: 23 Apr 2005
Posts: 13
Location: Bangalore

PostPosted: Mon May 09, 2005 2:44 pm    Post subject: Execution Process when using packages
Reply with quote

Hi all,

I have a question in using Packages.

When we use the concept of 'PLAN' in program process, we will be doing like COMPILE+BIND PLAN+RUN PLAN.

If we use PACKAGE instead of PLAN, how the execution flow should be done and what other components will get involved during the process such as COLLECTION etc.

Thanks in advance
Balasubramanian S
Back to top
View user's profile Send private message

King

New User


Joined: 10 May 2005
Posts: 1

PostPosted: Tue May 10, 2005 1:02 am    Post subject: Re: Execution Process when using packages
Reply with quote

When you use the concept of 'PACKAGE' in program process, we will be doing COMPILE+BIND PACKAGE+RUN PLAN.

There is no need to do any BIND PLAN.

The Plan will have multiple Packages for "same" program in the same PLAN, if Package Version feature is supported. Otherwise in BIND Package there is a parameter "ACTION (REPLACE)" will replace existing package with new package created. So when you run the program using PLAN proper package will be selected using time stamp matching procedure.

I hope I am correct, I answered your question.
Back to top
View user's profile Send private message
Balasubramanian

New User


Joined: 23 Apr 2005
Posts: 13
Location: Bangalore

PostPosted: Fri May 13, 2005 2:57 pm    Post subject: Re: Execution Process when using packages
Reply with quote

Then which name will be reffered for PLAN while RUN.

And Where the COLLECTIONS parameter shall be used.

Expecting your reply

Thanks in advance
Balasubramanian S


King wrote:
When you use the concept of 'PACKAGE' in program process, we will be doing COMPILE+BIND PACKAGE+RUN PLAN.

There is no need to do any BIND PLAN.

The Plan will have multiple Packages for "same" program in the same PLAN, if Package Version feature is supported. Otherwise in BIND Package there is a parameter "ACTION (REPLACE)" will replace existing package with new package created. So when you run the program using PLAN proper package will be selected using time stamp matching procedure.

I hope I am correct, I answered your question.
Back to top
View user's profile Send private message
pnk519

New User


Joined: 13 Nov 2003
Posts: 5

PostPosted: Sun May 15, 2005 2:17 pm    Post subject: info about package and plan
Reply with quote

Hi,

U cannot execute a program without PLAN...
suppose if we R using PACKAGE then we will be doing

Precompile+ BIND PACKAGE + BIND PLAN + RUN

your packages will be stored in DB2 Directory, in the form of collections, i.e. collection is a set of packages.
we will give the collection id at the time of BIND PACKAGE...

PACKAGE contains optimized access path to your data...
PACKAGE is not executable. it can be only executed via a PLAN

PLAN or APPLICATION PLAN contains set of pointers to PACKAGES
and provides collections where the PACKAGE should be searched at
execution time

We will give
BIND PLAN(plan-name) PKLIST(col1.*,col2.*)

then at execution time package will be searched in these columns (by run time supervisor) if PACKAGE is not found we will get SQLCODE = -805
i.e program name not found in PLAN.

and at last remember that there will be one DBRM per program
and one PACKAGE per DBRM, and name of DBRM, Program name , package-id will be same

---Naren
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 Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Storing huge volume of data, compare ... Pradeep K M All Other Mainframe Topics 3 Mon Jan 16, 2017 5:08 pm
No new posts Viewing executing process in NDM .. q... Debb.Brant IBM Tools 0 Wed Dec 14, 2016 10:55 pm
This topic is locked: you cannot edit posts or make replies. JCL MULTIPLE STEP EXECUTION QUERY Susanta JCL & VSAM 18 Sat Jul 30, 2016 1:17 pm
No new posts output DDname JESMSGLG job during exe... italo_pm TSO/ISPF 16 Tue Jun 21, 2016 11:13 am

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