Interested to Buy Any Domain ? << Click Here >> for more details...
can any body explain about plan and pakage in detail....
- 2 Answers
- 9909 Views
- HSBC, IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / ashish kumar
A DB2 bind is a process that builds an access path to DB2
tables.
A BIND process establishes a relationship between an APPLICATION
PROGRAM and its RELATIONAL DATA.
A plan is an executable module containing the access path logic
produced by the Db2 optimizer. It can be composed of one or
more DBRMs and packages.
The plans are available in the Catalog table SYSIBM.SYSPLAN
DB2 Bind compiles all your sql statements(dbrm) into an
executable format.
It uses DB2 Optimizer to create the better access path.
Package is the executable access path code for the sql
statements in the DBRM
Plan contains package list which is nothing but pointers to
packages.
| Is This Answer Correct ? | 13 Yes | 0 No |
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 |
What is the database descriptor?
Which catalog table stores referential constraints?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
How do you pull up a query which was previously saved in qmf?
how to get duplicate records from tables?write qurey for this?
What is the syntax for FETCH in DB2 ?
What is -904 sql code? How to resolve it?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
Explain transactions, commits and rollbacks in DB2.
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
when we are tying to update a table having 100 rows. if the program abends when updating 51 row . how to start updating again from the 51 row .what was the logic
What does DML stand for and what are some examples of it?
COBOL 
