What is the logical entity between plan and Package?

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


Please Help Members By Posting Answers For Below Questions

What is db2 command?

775


What kind of database is db2?

783


Why select is not preferred in embedded sql programs?

949


what is the responsibility of the construction superintendent

1887


What is concurrency?

916


What is the syntax for FETCH in DB2 ?

926


What is multi row fetch in db2?

782


Is ibm db2 open source?

825


What is a db2 package?

799


Explain about rct.

861


What is ibm db2 used for?

831


What is page size in db2?

743


What is a system catalog table in db2?

844


Is db2 a database?

745


How can the firstname and the lastname from the emp table be concatenated to generate complete names?

960