exact definetion bindplan and bind package

sarojini · New User Joined: 08 Dec 2005 Posts: 10 Location: India

hai friends,
i want exact difference bitween bindplan and bind package.

itssreehere · New User Joined: 10 Jan 2006 Posts: 65 Location: chennai

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

appasi · New User Joined: 12 Dec 2005 Posts: 20 Location: Bangalore

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.

anandss6 · New User Joined: 12 Dec 2005 Posts: 7 Location: trivandrum

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.

martin9 · Posted: Wed Mar 01, 2006 5:27 pm

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

Preetha Ramkumar · New User Joined: 07 Mar 2006 Posts: 9 Location: Hyderabad

Hi Sarojini,

The following two sites can help in this:

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

Regards,
Preeth

KS · New User Joined: 28 Feb 2006 Posts: 91 Location: Chennai

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