Interested to Buy Any Domain ? << Click Here >> for more details...
Plan is an executable form of sql statements,But what
exactly resides inside a Plan. what are the details inside
Plan.
- 2 Answers
- 7181 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 |
How do you do the EXPLAIN of a dynamic SQL statement?
What is isolation level?
What is a db2 schema?
What is bind in db2?
What is buffer pool and list some of them?
How does cobol compile db2 program?
How do you insert a record with a nullable column?
How to resolve -917 sql code in DB2?
What are the two types of logging in the db2 database? Explain them.
What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?
What is DCLGEN?
What is the difference between using bind () and rebind () methods of naming class?
COBOL 
