Interested to Buy Any Domain ? << Click Here >> for more details...
What is the logical entity between plan and Package?
- 5 Answers
- 8919 Views
- I also Faced
- E-Mail Answers
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 are simple, segmented and partitioned table spaces ?
What are the isolation levels possible ?
Can we use select * statement in cobol program without giving field names ???
what is diffrence b/w file-aid tool and file-aid utility???
What is view db2?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How many databases can be created inside an instance in db2 ?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is image copy in db2?
what is plan? is plan executable or package?
What are some SQL aggregates and other built-in functions?
What is dbrm? What it contains? When it will be created?
COBOL 
