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
B37 abend during spufi?
How can you classify the locks in db2?
How can deadlocks be resolved?
What is database reorganization?
How can we retrieve the total number of records in RPG & CLLE?
Why cursor is used in db2?
Define sqlca.
How do I create a view in db2?
What does db2 blu stand for?
What is a Foreign Key?
What is the difference between cursor and select statement?
What does a deadlock mean in DB2?
How do I change the column size in db2?
How to find the number of rows in db2 tables?
How would you find out the total number of rows in a db2 table?
