Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
- 2 Answers
- 6400 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vaibhav
Plan contains DBRM(machine level SQL statements) and
Optimized Access Path.
| Is This Answer Correct ? | 6 Yes | 0 No |
Answer / mehdee
. Plans are created by BIND command on sysibm.sysplan. To
execute a package, you must 1st include it in the package
list of a PLAN, so they are only executed when the plan in
which they are contained executes.
PACKAGEs are related to a PLAN, and PLANs are related to
a COLLECTION-ID. So when we REBIND a Package we do not need
to BIND REPLACE the Plan.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is a synonym ?
How to get the ddl of a table in db2?
where can we use index and subscript ? with example ?
what is the use of cursors?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is DCLGEN ?
What is precompiler in db2?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
List out the buffer pools in db2
What will happen, while trying to close the closed cursor.
Highlight all the advantages that are attached to a package.
What is the use of reorg in db2?
COBOL 
