PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PAC

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT
IS THE USE OF PACKAGE?

Question Posted / shaikdada

2 Answers
16138 Views
Tech Mahindra, Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?..

See there is not doubt that PLAN is an executable form of
DBRM and package is not the executable form.
Basically a DBRM can be linked to PLAN directly or a DBRM
can be linked to Package and that package can further linked
to the PLAN
Now if we directly link the DBRM with the plan then every
time we recompile the program(DBRM) we have to regenerate
the plan.
Whereas if we link the DBRM via package then every time we
recompile the program(DBRM) we only require to recompile the
Package.
Hence Binding through package prevents regeneration of plan.

1 more line I want to add just for knowledge.
If we regenerate the PLAN every time then all the other
Programs(DBRMs) which are attached to that same PLAN
required to be rebind thus take waste time.

Hope this answers your query...

Is This Answer Correct ?

27 Yes

2 No

PLAN IS EXECUTABLE AND PACKAGE IS NOT EXECUTABLE . THEN WHAT IS THE USE OF PACKAGE?..

Answer / shaikdada

please give me the answer

Is This Answer Correct ?

0 Yes

1 No

Post New Answer

More DB2 Interview Questions

My sql statement select avg(salary) from emp yields inaccurate results. Why?

0 Answers

What does a deadlock mean in DB2?

0 Answers

EXPLAIN has output with MATCHCOLS = 0. What does it mean?

2 Answers

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

1 Answers Mphasis,

is there any restrictions for unions ?

4 Answers Patni,

What do you mean by cursor?

0 Answers

what is the Foreign key? explain?

2 Answers

What is a recovery log?

1 Answers

How to connect to db2 database from windows command line?

0 Answers

can any one expalin check point with an example?