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
- 7008 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 is cursor with hold option in db2?
Is ibm db2 free?
Explain db2.
What is release/acquire in bind?
What is the connection string to connect to the DB2 Database ?
List down the data types in the db2 database.
What is dpf in db2?
What is dbrm? What it contains?
How can you count the number of rows from a table tab?
What is dbrm? What it contains? When it will be created?
What is a Foreign Key?
What action db2 takes when a program aborts in the middle of a transaction?
What is db2 command?
What is the use of with ur in db2?
What is null indicator in db2?
