Interested to Buy Any Domain ? << Click Here >> for more details...
can any body explain about plan and pakage in detail....
- 2 Answers
- 10014 Views
- HSBC, IBM, I also Faced
- E-Mail Answers
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 is plan in cobol db2?
What is db2 instance?
Which component is responsible for db2 startup and shutdown?
What are foreign keys in db2?
What is copy pending status in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
What is image copy in db2?
What is the use of commit in db2?
How to get the ddl of a table in db2?
What is the use of predicate?
What is database reorganization?
What is performance tuning db2?
What is bind plan?
Can we delete records from view?
What is a cursor in programming?
