Interested to Buy Any Domain ? << Click Here >> for more details...
can any body explain about plan and pakage in detail....
- 2 Answers
- 10013 Views
- HSBC, IBM, I also Faced
- E-Mail Answers
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
Explain correlated sub-queries.
How do you stop a db2 database in linux?
What is view db2?
What is db2 command?
What is the difference between dbm cfg and db cfg file in db2 ?
What is dbrm library?
What is data manager?
Explain the benefits you can get from mainframe connect?
How do I import a csv file into db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
How to check last update on table in db2?
How and when does the db2 enforces the unique key?
What is collection in db2 bind?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What are packages in db2?
