can any body explain about plan and pakage in detail....
Answer Posted / 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 |
Post New Answer View All Answers
What are union and union all?
Which command is used to connect to a database in DB2 ? Give the Syntax.
How to compare data between two tables in db2?
Define predicate?
What are the contents of a dclmgen?
What is ibm db2 connect?
What type of database is db2?
What is schema in db2?
What is difference between isnull and coalesce?
Explain about dbrm.
What is sqlca’s maximum length?
How will you return the number of records in table?
How to execute stored procedures?
What is scrollable cursor in db2?
Explain the function of data manager.