DB2 - Binding to Plan Vs Binding to Package



IBM's flagship relational database management system

DB2 - Binding to Plan Vs Binding to Package

Postby srikkanth.lovable » Mon Apr 18, 2011 2:26 pm

Hello,

I have a question say there are COBOL programs A,B,C & D.

A is calling B , B is calling C & C is calling D.( All are static calls & no dependency w.r.t DB2 tables )

A----->B----->C----->D

Case i : All modules are Bound to a single Plan ( Say Plan A )

Case ii :All modules are Bound to a single Package

Now, there is a change in the program C .

Now,what it makes difference in Binding in Case i and Case ii.

Simply,What if bind to package and what if bind to plan.Grateful for the answer.
srikkanth.lovable
 
Posts: 12
Joined: Wed Mar 16, 2011 12:34 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 - Binding to Plan Vs Binding to Package

Postby NicC » Mon Apr 18, 2011 3:39 pm

Suggest you do a search on the forum for the information as this sort of question has been asked several times before including one just last week or the week before just looked it up - March 30). Of course you should have searched the forum before posting and consulted with Google and the DB2 User Guide. Having done all that and found your answer then there is no need to post unless there is something in the answer that you are unclear about.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times

Re: DB2 - Binding to Plan Vs Binding to Package

Postby srikkanth.lovable » Mon Apr 18, 2011 4:04 pm

Pls explain me briefly.. in few words.i know that one can access the manuals or Google. Thank u..
srikkanth.lovable
 
Posts: 12
Joined: Wed Mar 16, 2011 12:34 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 - Binding to Plan Vs Binding to Package

Postby Robert Sample » Mon Apr 18, 2011 4:39 pm

http://www.google.com
Enter db2 user guide for your search field. IBM's manuals come back in the search results, very fast.
Robert Sample
Global moderator
 
Posts: 3719
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: DB2 - Binding to Plan Vs Binding to Package

Postby alexm » Mon Apr 18, 2011 6:22 pm

You'll find this information in the DB2 for z/OS Version 9 Installation Guide:
Releases of DB2 after Version 9.1 do not support plans that contain DBRMs. [...] ensure that all of your plans contain only package lists.

If you're free to select both case i and ii in your shop, you should focus on the package approach. Learning about DBRMs in plans might be a waste of time.
User avatar
alexm
 
Posts: 35
Joined: Wed Oct 13, 2010 6:40 pm
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 - Binding to Plan Vs Binding to Package

Postby Suny » Thu Apr 21, 2011 4:26 pm

Binding DBRMs to a plan is an old way. The DBRM and package has 1 to 1 relationship. You cannot bind multiple DBRMs to a single package (your case 2). Now if you have created seperate package for all DBRMs, you can bind them in a plan. the advantage is that you do not have to rebind the plan if C has changed. you just need to rebind the package. But the catch here is itsok if your calls are dynamic. If your call is static, you must be recompiling A to include the changed C's code in it. there your consistency token will change and you need to bind all packages again. The only way of skipping this is to have LEVEL option during precompile(NOT RECOMMENDED), so we won't discuss about it.
Hope this answers your question.
Suny
 
Posts: 8
Joined: Thu Apr 21, 2011 3:57 pm
Has thanked: 0 time
Been thanked: 0 time


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post