DB2 compatibility features


DB2 offers many compatibility features that can be turned on individually based on your need. To enable all the compatibility features applicable to Oracle databases, set the registry variable DB2_COMPATIBILITY_VECTOR = ORA. You can then create an Oracle compatible database.

Follow the steps below to create a compatible database:

  1. db2stop force to stop the DB2 instance
  2. db2set DB2_COMPATIBILITY_VECTOR=ORA to set the compatibility registry variable
  3. db2start to start DB2 instance
  4. db2 create db compat to create a COMPAT database.
  5. db2 connect to compat to connect to COMPAT database