6 Must Read DB2 PLAN Interview Questions

What is DB2 PLAN, and why do we need it? Below, you will find detailed answers. These are helpful for your interviews.

DB2 PLAN Interview Questions

PLAN –  Is an executable DB2 object. A DBRM you can bind directly to a PLAN or a PACKAGE you can bind it to a plan. In the BIND cards, you need to give PLAN name and PACKAGE name.

You can check PLAN details in SYSPLAN catalog table.

PACKAGE It is basically a DB2 object. All the similar DBRMs, we can keep in a PACKAGE. It is itself is not executable.

You can check PACKAGE details in SYSPACKAGE catalog table.

COLLECTION  It is again DB2 object, during BIND, you need to give PACKAGE and COLLECTION id details.

You can check all the details in SYSCOLLECTIONS catalog table.

DBRM This is load of DB2 code. This will be generated during pre-compilation. There will be one DBRM for each program.

VERSIONS It is a concept for PACKAGE versions.  You may keep different versions of a packages. Since, each update in PACKAGE will put different version and keep old version of PACKAGE. In the production, it is always useful keeping old version as backup.

Also read: 32 complex SQL interview questions


Python: How to Filter List Best Example

Python Filter function example that shows filter list items based on specific criteria.


Something went wrong. Please refresh the page and/or try again.

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.