VERSION ID

saravanans4 · New User Joined: 01 Sep 2003 Posts: 16

Sir,
what is the use of the VERSIONID in the case of the DB2....
generally we will be specifying the VERSION ID while we r using the EXPLAIN statement in the PACKAGE.....what is the advantage of having the VERSIONID.

Thanks and regards,
saravanan

harikrishnanrajeev · EXPERT Joined: 28 Jan 2004 Posts: 40 Location: Trivandrum

Hello saravanan,

I am noting certain details about Version ID.

Multiple versions of the same package can be supported in a single system by using the new version option for packages.

The intent of this option is to allow multiple packages that share both the schema and package-id to co-exist in the system catalogs. This option will allow you to introduce and test a new version of a package on the system without affecting users of the existing version of the package. The support of the version option will allow ongoing package maintenance to occur without interruption of end-user access to the system.

The PREP, BIND, REBIND and DROP PACKAGE facilities have been enhanced to support package versioning.

This link can help u

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0009203.htm

http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0009203.htm

Hope i have given some details

Thanks and regards

Hari.