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 alias in db2?
What is the reason behind not using select * in embedded sql programs?
How and when does the db2 enforces the unique key?
Explain the benefits you can get from mainframe connect?
define clustering index.
How can we retrieve the total number of records in RPG & CLLE?
What is the role of schema in the db2 database?
How do I connect my db2 database to ibm?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
Which component is responsible for processing sql statements and selecting access paths?
What are the different types of base tables?
What are types of indexes?
How many databases can be created inside an instance in db2 ?
What is phantom read in db2?
What is db2? Explain.
