DB2: How to bind Package versions

I am busy with my project work. However, I provided this packages concept blog for your reference..

The version in simple terms means adding the timestamp to your package.

Package.timestamp

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. Read how to create Package Versioning.

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.