can any body explain about plan and pakage in detail....
Answer Posted / srinivasa gudla
A package is single bound DBRM with optimized access paths.
It contains location identifier, collection Identifier and
package identifier.
A package can have multiple versions, each with it's own
version identifier
Advantages of Packages,
Reduce the Bind Time.
Versioning.
Can provide BIND options at programmer level.
As Ashish mentioned above, Plan contains packages list which
is nothing but Pointers. whenever you are doing changes in
SQL staetments related to particular DBRM . Then only that
particular Packages needs to be rebind not the Plan. This is
similar to recompiling a sub program not the main program.
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
What types of tables are there in the db2 database?
What is isolation level in db2?
How does cobol compile db2 program?
What is ibm db2 client?
What is data manager?
What is deadlock in db2?
Differentiate between cs and rr isolation levels? Where do you specify them?
define clustering index.
What does runstats do in db2?
What is the reason behind not using select * in embedded sql programs?
What do you mean by between and in? Is between inclusive of specified range values?
What is database reorganization?
What is dbrm?
What is the difference between oracle and db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...