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
- 7175 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 we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?
What is consistency token in db2?
What is the use of predicate?
How to update more then one record using update?
How can you count the number of rows from a table tab?
What is release/acquire in bind?
Can All Users Have The Privilege To Use The SQL Statement Select (DML)?
how can i pull up a query which was previously stored in qmf
What if we fail to give values in columns declared as NOT NULL ?
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What do you mean by storage group (stogroup)?
What is the clustering index in the db2 database?
COBOL 
