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 meant by explain?
Before you give the explain statement, what are the prerogatives?
How and when does the db2 enforces the unique key?
Explain the contention situations caused by locks?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is cursor with hold option in db2?
What is buffer pool and list some of them?
How to find the number of rows in a db2 table?
Can you tell me how can you find out the # of rows updated after an update statement?
Are view updateable?
Is db2 a mainframe?
What is the syntax for FETCH in DB2 ?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is a plan and package in db2?
What is the usage of open cursor command?
