DB2 Warehouse on Cloud default PLSQL compatibility

Question

How can I find if a DB2 Warehouse on Cloud instance is enabled for Oracle compatibility? What is the default compatibility mode for DB2WoC instance which was provisioned from IBM Cloud? Is there a way to toggle the mode? Thanks.

Answer 1

Oracle compatibility can only be set at the time of provision. It can't be changed afterwards. If you need to change the setting, you would need to raise a Ticket and see if support will copy your data into a new instance. Alternatively, provision a new instance yourself, checking the Oracle compatibility option, and copy your data over.

A quick way to check if you have compatibility mode enabled is to look at the following parameters

select distinct name, value from sysibmadm.dbcfg where name like '%compat'

If they are all on, then your database was created in Oracle Compatibility mode

 NAME            VALUE
 --------------- -----
 date_compat     ON
 number_compat   ON
 varchar2_compat ON