What is the logical entity between plan and Package?
- 5 Answers
- 7952 Views
- I also Faced
- E-Mail Answers
Answer Posted / sridhar reddy
When ever a main progran is executed it is going to create
a DBRM for example if the main program calls n sub programs
then these n sub program need N DBRM's A total of N+1 DBRMs
are needed. A Plan is required to run These DBRM's .
Instead of placing all these DBRM's in a plan , for each
DBRM one package is created & these packages inturn call a
plan.
Instead of placing DBRM's in a plan a package is created
because if we modify any thing no need recompile all the
DBRM's
posted by Sridhar BhumiReddy
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is db2 look?
What is clone table?
What is sqlca?
What is db2 and what is the use of db2 optimizer?
What is explain plan in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What is cobol db2?
Is db2 relational database?
Explain the function done by data manager?
Mention the different locking levels that are available in db2.
What is db2 stogroup?
What is difference between alias and synonym in db2?
What is an instance in db2?
Which isolation level provides maximum concurrency?
How would you find out the total number of rows in a db2 table?
