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
- 6855 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the full forms of spufi and dclgen and why are they used?
what is a corelated subquerry?
What is the use of predicate?
Name the various locking levels available?
What is the difference between oracle and db2?
What is a db2 cursor?
Describe major components of db2?
How to create backup table in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is ibm db2 database?
What does runstats do in db2?
What are the various data types available in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is dbrm library?
What is the use of commit in db2?
