DB2 What is the difference between a package and

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

DB2 What is the difference between a package and a plan ?

Q: DB2 What is the difference between a package and a plan ? How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

AN:
Package and plan are usually used synonymously, as in this site. Both contain optimized code for SQL statements- a package for a single program, module or subroutine contained in the database request module (DBRM) library. A plan may contain multiple packages and pointers to packages. The one CICS module would then exist in a package that could be referenced in two different plans.

(Continued on next question...)

Other Job Interview Questions

• MAX number of columns in a DB2 table
• What happens to a tablespace when its recovery information has been removed and a full recovery is no longer possible?
• What is an intent lock?
• If I have a view which is a join of two or more tables, can this view be updatable?
• What are the disadvantages of PAGE level lock?
• What are the disadvantages of using VARCHAR ?
• What is referential integrity ?
• Why use RUNSTAT Utility?
• What are the three tyes of page locks that can be held?
• What will the DB2 optimizer do?
• More...