Answer Posted / vira raguram.i
a plan is an executable module containing the access path
logic produced by the db2 optimizer.it can have one or more
DBRMs or packages.
| Is This Answer Correct ? | 14 Yes | 2 No |
Post New Answer View All Answers
What is table space in db2?
What is the max length of sqlca?
What are foreign keys in db2?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What is a db2 schema?
How and when does the db2 enforces the unique key?
How do you eliminate duplicate values in db2?
What is difference between isnull and coalesce?
What are concurrency issues?
Which component is responsible for processing sql statements and selecting access paths?
What is db2 plan table?
Is it possible using max on a char column?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
Explain in brief how does db2 determine what lock-size to use?
What is temporal table in db2?