DB2 top differences Bind Package Vs Bind Plan

Bind Package:

A package is a single, bound DBRM with optimized access paths. By using packages, the table access logic is “packaged” at a lower level of granularity than a plan.

Plan==> Package

As we all know “Bind Package” is not executable.  Exceptions: UDFs and Triggers.

32 complex SQL Queries

32 Complex SQL Queries

Useful for interview and projects.

$1.00

Bind Plan:

A plan is an executable module containing the access path logic produced by the DB2 optimizer. It can be composed of one or more DBRMs and packages.

So plan is higher in level than package.

A plan can consist of one or more DBRMs, one or more packages or, a combination of packages and DBRMs.

Related Posts

Author: Srini

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