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

Answer 2

Depends on which plan you are on. IBM Documents that Oracle-compatibility does not apply to the entry plan for the managed service of Db2 warehouse on cloud

Depending on what you've got, and deployment timing,there are configuration options (including ENABLE_ORACLE_COMPATIBILITY), see https://www.ibm.com/support/knowledgecenter/en/SS6NHC/com.ibm.swg.im.dashdb.doc/admin/configuring_Local.html#configuring_Local__config_options