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
Can we delete records from view?
What is drop table?
Name the lockable units in DB2?
What is alias in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is dbrm? When it will be created?
How do I copy a table in db2?
What are union and union all?
What is a trigger in the db2 database?
What is the physical storage length of time data type?
What is consistency token in db2?
Outputs of explain are with matchcols = 0. What does this signify?
Define db2 and its databases?
What is a db2 tablespace?
What are the two types of logging in the db2 database? Explain them.