Supporting Oracle compatibility mode in DB2 Enterprise Edition and DB2 Connector stage.

Technote (troubleshooting)


Support for DB2_COMPATIBILITY_VECTOR=ORA in DB2 Enterprise Edition and DB2 Connector stage in IBM InfoSphere Information Server.


As we do not support DB2_COMPATIBILITY_VECTOR registry variable, setting it at the database end using 'db2set' could cause the DB2EE or DB2Connector jobs to fail with incompatible datatypes or incompatible functions.

Please refer to the related technote attached in the Related Section for further details on the error.

Resolving the problem

As of now, DB2_COMPATIBILITY_VECTOR=ORA registry variable is not supported by DB2 Enterprise Edition or DB2 Connector stages.

Related information


Cross reference information
Segment Product Component Platform Version Edition
Information Management InfoSphere Information Server

Document information

More support for:

InfoSphere Information Server

Software version:

8.0, 8.0.1,,,, 8.0.2, 8.1,,,, 8.5,,,, 8.7,,, 9.1,

Operating system(s):

AIX, HP-UX, Linux, Solaris, Windows

Reference #:


Modified date:


Translate my page

Content navigation