Interested to Buy Any Domain ? << Click Here >> for more details...
What is the logical entity between plan and Package?
- 5 Answers
- 8729 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 the difference between nvl and coalesce?
What is the use of commit in db2?
How to fetch the last row from the table in SQL (db2)?
What is buffer pool?
Describe major components of db2?
What is runstats and reorg in db2?
How do you find the maximum value in a column in db2?
Explain package in db2 and its advantages?
What is bind and rebind in db2?
What is explain plan in db2?
Comment whether the cursor is closed during commit or not.
What is host variable in db2 cobol?
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
Explain packages.
What is rct?
