• No replies
1 Post

Pinned topic Oracle Compatibility and Column Organized Table

‏2013-05-22T20:54:58Z | 10.5 blu columnar db2

We were running the sample instance for some time with no issues, however when we set the DB2_COMPATIBILITY_VECTOR=ORA for the instance we no longer could use CREATE TABLE with ORGANIZE BY COLUMN. Is this a known limitation? Will column oriented tables be permitted in the full release with DB2_COMPATIBILITY_VECTOR=ORA? Anyone else run into the same issue?

DB2 Database Error: ERROR [] [IBM][DB2/LINUXX8664] The CREATE TABLE STATEMENT failed because functionality that is not compatible with the specified type of table is currently enabled for the database.  Incompatible functionality keyword: "DB2_COMPATIBILITY_VECTOR".

Thanks, Daniel

Updated on 2013-05-22T20:55:34Z at 2013-05-22T20:55:34Z by whogotdafunk