Interested to Buy Any Domain ? << Click Here >> for more details...
What is the logical entity between plan and Package?
- 5 Answers
- 8690 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 |
Is db2 a mainframe?
Can we install 2 different versions of Db2 on same mainframe?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What does the REORG Utility do?
What is a page in db2?
How can you display the current date & current time ?
What is the maximum No of rows per page?
Why do chiropractors use drop table?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
What is RUNSTATS?
Why db2 is called db2?
Explain in brief how does db2 determine what lock-size to use?
COBOL 
