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
- 6983 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 db2 plan table?
What information is contained in a SYSCOPY entry?
What is a collection?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
what is the role of the cursor in db2?
Which isolation level provides maximum concurrency?
What does the REORG Utility do?
If we have 100 records in the PF, we deleted all the records then what is the Size of the PF?
What is package versioning? Please give an example.
What is the syntax required for the creation of a cursor?
What is the reason behind not using select * in embedded sql programs?
What do the initials DDL and DML stand for and what is their meaning?
COBOL 
