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 |
what are the SQL codes u freequently got?
How to find the number of rows in a db2 table?
Suppose the outcome of executing a query results in a row having null. Based on the answer how you use it? Its declaration and inclusion?
What is the format (internal layout) of ?TIMESTAMP??
How many clustering indexes can be defined for a table?
What is the use of dclgen in db2?
What is meant by a unit of recovery?
Define db2.
What is performance tuning db2?
What is a db2 cursor?
What is the use of COMMAREA ?Minimum how much data we can pass from it?
What's the difference between DB2 active log and archive log? Thanks a lot...