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 syscat in db2?
What is ibm db2 connect?
Before you give the explain statement, what are the prerogatives?
What is dbrm? When it will be created?
What is multi row fetch in db2?
Why cursor is used in db2?
What is database alias db2?
What is scrollable cursor in db2?
What is package in db2 mainframe?
How do we specify index to include or not during bind process.
What is db2 optimizer?
Explain how can you do the explain of a dynamic sql statement?
What is access path in db2?
what is diffrence b/w file-aid tool and file-aid utility???
What is the difference between using bind () and rebind () methods of naming class?
