View previous topic :: View next topic
|
Author |
Message |
saravanans4
New User
Joined: 01 Sep 2003 Posts: 25
|
|
|
|
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 |
|
Back to top |
|
|
harikrishnanrajeev
EXPERT
Joined: 28 Jan 2004 Posts: 37 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
publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/core/c0009203.htm
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. |
|
Back to top |
|
|
|