what is a plan and how do you refer the plan in the
program?
Answer Posted / harsha
plan is executable.it contains access path.we will refer
plan in jcl as plan name.generally all information abt the
plan will be there in sysibm.sysplan
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is dbrm? What it contains? When it will be created?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is database reorganization?
What is the role of the data page in the db2 database?
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 query_cache_limit?
Explain the function done by data manager?
What is db2 instance?
How does coalesce work?
What is dbrm? When it will be created?
How to find the maximum value in a column in the db2 database?
What is db2 optimizer?
what is the role of the cursor in db2?
Is it possible using max on a char column?
What is package in db2 mainframe?