DB2: How to Bind Package Versions

The package version means it adds the timestamp to your package. Here is the syntax.


Package Version

When new package version is created for your new program, then without rebinding you can use your old program. This is the great advantage of using packages in DB2. The version identifier stored in the DBRM and link is generated from Precompiler.

Version acts as a parameter to the DB2 Precompiler.  No manual intervention is needed in creating version.

  1. When package is bound with new plan, all versions of that package are bound to new plan
  2. When you are running a program with a plan , then based on version identifier link, it gets package version

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.