DB2 10.5 for Linux, UNIX, and Windows

Supported system and database configurations for column-organized tables

Before you start using column-organized tables, ensure that you have a system and database configuration that is supported.

The following operating systems support column-organized:

Linux (x86-x64, Intel and AMD processors)
Linux on zSeries
AIX® (POWER® processors)
Windows operating systems that are supported by DB2® Advanced Enterprise Server Edition and DB2 Advanced Workgroup Server Edition

The following system and database configurations do not support column-organized tables in the DB2 Version 10.5 release.

Databases in a DB2 pureScale® environment
Partitioned databases
Databases that are created without automatic storage enabled
Table spaces that are not enabled for reclaimable storage
Databases whose code set and collation are not UNICODE and IDENTITY or IDENTITY_16BIT

The following additional restrictions apply to column-organized tables in the DB2 Version 10.5 release:

Schemas that include column-organized tables cannot be transported.
Data federation with column-organized tables is not supported.
For data replication with column-organized tables as source:
- A CREATE TABLE statement with the DATA CAPTURE CHANGES clause is not supported.
Automatic tuning of sort memory is not supported in environments using column-organized tables.
For label-based access control (LBAC), the following syntax is not supported: ALTER TABLE...SECURITY POLICY policyname
For row and column access control (RCAC), the following syntax is not supported:
- ALTER TABLE...ACTIVATE ROW | COLUMN ACCESS CONTROL
- CREATE PERMISSION / CREATE MASK
The following SQL statements do not support column-organized tables as target or source tables:
- CREATE EVENT MONITOR
- CREATE GLOBAL TEMPORARY TABLE
- CREATE INDEX and ALTER INDEX
- CREATE MASK
- CREATE PERMISSION
- CREATE TRIGGER
- When processing a trigger, INSERT, UPDATE or MERGE to a column-organized table
- DECLARE GLOBAL TEMPORARY TABLE
- SET INTEGRITY
Queries using the RR or RS isolation level are not supported with column-organized tables.
XA transactions are not supported.