What is the logical entity between plan and Package?
- 5 Answers
- 6974 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 |
How to solve S0C7 abend with out using DISPlay in 10 mins?
What do you mean by commit and rollback?
Describe the elements of the SELECT query syntax?
Where to download IBM DB2 Certification Dumps for the below: C2090-311 : IBM DB2 10.5 DBA for LUW Upgrade from DB2 10.1 C2090-312 : IBM DB2 11 DBA for z/OS C2090-313 : DB2 11 Application Developer for z/OS C2090-317 : DB2 11 System Administrator for z/OS C2090-541 : DB2 9.7 DBA for Linux UNIX and Windows C2090-543 : DB2 9.7 Application Development C2090-544 : DB2 9.7 Advanced DBA for LUW C2090-545 : DB2 9.7 SQL Procedure Developer C2090-546 : DB2 9.7 Database Administrator for Linux UNIX or Windows Upgrade C2090-610 : DB2 10.1 Fundamentals C2090-611 : DB2 10.1 DBA for Linux, UNIX, and Windows C2090-612 : DB2 10 DBA for z/OS C2090-614 : DB2 10.1 Advanced DBA for Linux UNIX and Windows C2090-615 : DB2 10.5 Fundamentals for LUW C2090-617 : DB2 10 System Administrator for z/OS C2090-730 : DB2 9 Family Fundamentals C2090-733 : DB2 9 Application Developer C2090-735 : DB2 9.5 SQL Procedure Developer C2090-737 : DB2 9 System Administrator for z/OS Exam
Explain the EXPLAIN statement?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
What is a buffer pool?
What are the functions of Bind?
Define buffer pool.
What is reorg and runstats in db2?
Can i insert bulk records into a db2 table using qmf of spufi only............!!!
What if we fail to give values in columns declared as NOT NULL ?
COBOL 
