First step towards enabling Oracle application to DB2 9.7
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.
Getting ready
You need to have the SYSADM privilege on the instance, which needs the compatibility feature to be enabled.
How to do it...
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,
ORAin case of Oracle to DB2, andSYBin case of Sybase...
