DB2 Warehouse on Cloud默认PLSQL兼容性 [英] DB2 Warehouse on Cloud default PLSQL compatibility

问题描述

如何查找是否启用了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兼容性的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！