DB2: How to Bind Package Versions

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

Package.timestamp

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