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 |
what is db2 restart?
What is db2?
How to update more then one record using update?
How is the SUBSTR keyword used in sql?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
What is reorg and runstats in db2?
Where would you find information about the type of database authority held by the user?
What is a trigger in the db2 database?
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
what happend with out using Commit,when closing cursor and program?
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
What is sqlcode -922 ?