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.