问题描述
如何查找是否启用了DB2 Warehouse on Cloud实例以实现Oracle兼容性？从IBM Cloud调配的DB2WoC实例的默认兼容性模式是什么？有没有办法切换模式？谢谢。
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.
推荐答案
Oracle兼容性只能在提供时设置。此后无法更改。如果需要更改设置，则需要举票并查看支持人员是否会将您的数据复制到新实例中。另外，您可以自己提供一个新实例，检查Oracle兼容性选项，然后复制数据。
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'
如果全部打开，则您的数据库是在Oracle兼容模式下创建的
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
这篇关于DB2 Warehouse on Cloud默认PLSQL兼容性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！