What is the logical entity between plan and Package?
Answers were Sorted based on User's Feedback
Answer / kamal
plan is an optimized access path,but it is an executable component,package contains optimized access path,which is generated by optimizer of bind & it is a non-executable component.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / 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 |
Answer / vamsi
Plan is an executabel one which provides access path to
access the DBRM's.
Is This Answer Correct ? | 0 Yes | 1 No |
Answer / praveen
plan contains address of package.
package contains data set.
Is This Answer Correct ? | 0 Yes | 1 No |
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is a clustering index?
Is db2 a database?
How connect db2 database to datastage?
What is the function of the Data Manager?
What is ALTER ?
How to insert more than one record using insert?
What is meant by index cardinality?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
difference between group clause and order clause
What are data types?
What is a synonym? How is it used?