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 the picture clause of null indicator variable?
can all users have the privilage to use the sql statement select * (dml)?
What is the reason behind not using select * in embedded sql programs?
Is the primary key a clustered index?
What is cursor stability in db2?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is schema in db2?
What is the clustering index in the db2 database?
Explain in brief how does db2 determine what lock-size to use?
Give a brief description of db2 isolation levels?
Mention some fields that are a part of sqlca.
What is host variable in db2 cobol?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
How do you find the maximum value in a column in db2?
What is a db2 table?
