Interview Questions

What are the advantages of using a PACKAGE?

DB2 ( IBM Database 2 ) Interview Questions


(Continued from previous question...)

What are the advantages of using a PACKAGE?

The advantages of using PACKAGE are :
1. Avoid having to bind a large number of DBRM members into a plan
2. Avoid cost of a large bind
3. Avoid the entire transaction being unavailable duing bind and automatic rebind of a plan
4. Minimize fallback complexities if changes result in an error.

(Continued on next question...)

Other Interview Questions