Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / jessica
A plan is an executable module containing the access path
logic produced by the DB2 optimizer. It can be composed of
one or more DBRMs and packages. Before a DB2 for z/OS
program (with static SQL) can be run, it must have a plan
associated with it.
Plans are created by the BIND command. The plan is stored in
the DB2 directory and accessed when its program is run.
Information about the plan is stored in the DB2 catalog.
| Is This Answer Correct ? | 88 Yes | 5 No |
Post New Answer View All Answers
What is cloudant database?
What is multi row fetch in db2?
How do I connect my db2 database to ibm?
Outputs of explain are with matchcols = 0. What does this signify?
How do I delete a table in database?
What do you mean by rollback?
What is the use of reorg in db2?
What parameters are used to control the free space in DB2?
What are catalog tables in db2?
What is an instance database?
How to get the ddl of a table in db2?
What is bind in db2?
What are the various data types available in db2?
What is scrollable cursor in db2?
What is load utility in db2?
