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
Differentiate between cs and rr isolation levels? Where do you specify them?
What is the use of dclgen in db2?
What are the benefits of using the db2 database?
What is ibm db2 client?
What is bind and rebind in db2?
What is dclgen (declaration generator)?
What is null in db2?
What is the difference between bind and rebind in db2?
What is bufferpool in db2?
What does a deadlock mean in DB2?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is dbrm library?
What is the role of data manager in the db2 database?
How to check table size in db2 sap?
What is a storage group (stogroup)?
