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
- 7053 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 |
Can we update view in db2?
Describe the elements of the SELECT query syntax?
What is the function of the Data Manager?
what is load and unload in db2
Mention the definition of cobol in varchar field.
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
What is a db2 package?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What do you need to do before you do EXPLAIN?
How are write I/Os from the buffer pool executed?
How is a typical DB2 batch program executed ?
explain about index with examples
COBOL 
