Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

exact definetion bindplan and bind package

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

New User


Joined: 08 Dec 2005
Posts: 10
Location: India

PostPosted: Thu Jan 26, 2006 5:13 pm    Post subject: exact definetion bindplan and bind package
Reply with quote

hai friends,
i want exact difference bitween bindplan and bind package.
Back to top
View user's profile Send private message

itssreehere
Warnings : 1

New User


Joined: 10 Jan 2006
Posts: 65
Location: chennai

PostPosted: Fri Jan 27, 2006 6:24 pm    Post subject:
Reply with quote

earlier version of DB2 had only bind plan.New versions have both.

package is not executable, while plan is the executable path to access your database in an optimized way.

Difference is that, if you have a program A and a sub pgm B.
If you have separate packages for both, when you change sub pgm you have to compile and bind only the sum program.Not the pgm A. Basically it makes the sub program independent.

Sreejith
Back to top
View user's profile Send private message
appasi

New User


Joined: 12 Dec 2005
Posts: 20
Location: Bangalore

PostPosted: Mon Feb 13, 2006 3:54 pm    Post subject:
Reply with quote

Hi sarojini,

I just want to add one more difference between BIND PLAN and BIND PACKAGE to what all given by itssreehere .

We can BIND only one pgm DBRM as one Pakage,
But any number of DBRM or any number of Packages
or any number of DBRM and any number of Packages
can be BIND as ONE PLAN .

If am i wrong please correct me.
Back to top
View user's profile Send private message
anandss6

New User


Joined: 12 Dec 2005
Posts: 7
Location: trivandrum

PostPosted: Fri Feb 17, 2006 5:32 pm    Post subject:
Reply with quote

Hi,

Bind package consists complied form of sql statments which are placed

in DBRM.where as a Bind plan is list of packages which are used to

execute that program.
Back to top
View user's profile Send private message
martin9

Active User


Joined: 01 Mar 2006
Posts: 287
Location: Basel, Switzerland

PostPosted: Wed Mar 01, 2006 5:27 pm    Post subject:
Reply with quote

one program with sql-statements gives one dbrm, which must be bound (BIND), for db2 will recognize it. Thus, if you have a run-unit with, let's suppose 10 subprograms with sql-statements, you will also have 10 packages in db2 (one dbrm gives one package after the BIND).

in the package, there is the optimized access path for the desired data requests upon the last RUNSTATS (i.e. data statistics)

in the plan you define which package-lists are allowed to access,
therefore if you have all existing package-lists in your plan defined,
you will never need to BIND your plan again.

thus the relation between a plan and its packages is 1:n, ok...?

martin9
Back to top
View user's profile Send private message
Preetha Ramkumar

New User


Joined: 07 Mar 2006
Posts: 9
Location: Hyderabad

PostPosted: Tue Mar 21, 2006 2:55 pm    Post subject: Re: exact definetion bindplan and bind package
Reply with quote

Hi Sarojini,


The following two sites can help in this:

http://www.db2mag.com/story/showArticle.jhtml?articleID=15300107
http://www.db2mag.com/story/showArticle.jhtml?articleID=17602333


Regards,
Preeth
Back to top
View user's profile Send private message
KS

New User


Joined: 28 Feb 2006
Posts: 91
Location: Chennai

PostPosted: Wed Mar 22, 2006 12:59 pm    Post subject:
Reply with quote

Hi ,

The bind process establishes a relationship between an application program and its relational data. This step is necessary before you can execute your program. Currently,DB2 allows you two basic ways of binding a program: to a package, or
directly to an application plan.

BIND PACKAGE subcommand allows you to bind DBRMs individually. It gives you the ability to test different versions of an application without extensive rebinding.

BIND PLAN establishes the relationship between DB2 and all DBRMs or packages in that plan. Plans can specify explicitly named DBRMs, packages,collections of packages, or a combination of these elements. The plan contains information about the designated DBRMs or packages and about the data the application program intends to use. It is stored in the DB2 catalog.

Thanks,
KS
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts JCL to delete component in a package sundaram.naveen Compuware & Other Tools 14 Tue Nov 29, 2016 6:21 pm
No new posts What's plan, package, bind ? jackzhang75 DB2 2 Sun Feb 28, 2016 7:29 pm
No new posts Cobol DB2 package accessing differen... Mainak_Dalal DB2 1 Tue Jan 26, 2016 12:57 am
No new posts What is Bind Error? Chetan Kumar Mainframe Interview Questions 1 Fri Oct 16, 2015 7:00 pm
No new posts Can not find SQL statement of package... chaoj DB2 2 Wed Mar 11, 2015 12:00 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us