The new DB2 registry variable, DB2_COMPATIBILITY_VECTOR
, can be used to enable one or more compatibility features. These features bottom out the effort of an application developer, while migrating the code written for other relational databases to DB2 9.5 or later.
You need to have the SYSADM
privilege on the instance, which needs the compatibility feature to be enabled.
The DB2 registry variable, DB2_COMPATIBILITY_VECTOR
, takes hexadecimal value 00
to FFFF
. To take advantage of the DB2 compatibility feature for Oracle applications, use ORA
, and for Sybase applications use SYB
. The first step towards setting the DB2 9.7 database for the other data server compatibility, includes setting the registry settings at instance level.
1. Setting the instance-level registry for compatibility, we can only set any one of the following, based on the requirement,
ORA
in case of Oracle to DB2, andSYB
in case of Sybase...