what is a plan and how do you refer the plan in the
program?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
The DBRM name is the program name and should be bound to a
plan before the DB2 program can be executed. The plan is
nothing but bound DBRMs or packages.
| Is This Answer Correct ? | 0 Yes | 1 No |
How would you find out the total number of rows in a db2 table?
How could one combine a set of incremental image copies into a single copy?
What is innodb buffer pool?
What is a system catalog table in db2?
What are types of indexes?
What is a bind in db2?
i have cobol+ db2 program but it contains n number of subprograms for this how many dbrm members i need to mention in bind process
When reorg is used?
how to identify the pseudo conversation by seeing the program
If I have a view which is a join of two or more tables, can this view be updatable?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
Which is faster delete or truncate?