How to bind Package versions in DB2

I am very busy with my project now a days. I am spending some of my busy time with my beautiful readers for improving their knowledge.

The best point is what is version – in simple terms versions means adding timestamp to your package.


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

Author: Srini

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