View previous topic :: View next topic
|
Author |
Message |
t1nt1n
New User
Joined: 08 Jul 2005 Posts: 31
|
|
|
|
Hello,
I know the basic difference between bind package & plan but Can someone tell me the exact difference between bind package & plan in terms of the options.
Thanks.... |
|
Back to top |
|
|
baru
New User
Joined: 08 Sep 2005 Posts: 4 Location: Mumbai
|
|
|
|
BIND reads SQL statements from DBRMs and produces a code to access data as directed by SQL statements.
There are two types of BINDs ? BIND PLAN & BIND PACKAGE
BIND PLAN ? Accepts one or more DBRMs produced from previous DB2 pre-compilations, one or more packages produced from previous BIND PACKAGE commands or a combination of DBRMs and Package lists as input. The output of BIND PLAN is application plan
An application plan is executable only with the corresponding load module. Before running a DB2 program, an application plan must be specified.
BIND PACKAGE ? Accepts DBRM as input and produces a single package containing the optimized access path logic. The package then can be bound into application plan using BIND PLAN command. A package is not executable and cannot be specified when DB2 program is being run, the package must be bound into a plan before using it. |
|
Back to top |
|
|
amalli
New User
Joined: 06 Sep 2005 Posts: 17
|
|
|
|
plan is executable
package is not executable |
|
Back to top |
|
|
Anbudan
New User
Joined: 07 Sep 2005 Posts: 26 Location: Germany
|
|
|
|
Hi t1nT1n
Packages have a one-to-one relationship to source modules. A plan is a group of packages; it will correspond to one or more load modules.
Anbudan |
|
Back to top |
|
|
|