DB2 10.5 for Linux, UNIX, and Windows

dft_table_org - Default table organization

This parameter specifies whether a user table is created as a column-organized table or a row-organized table when you do not specify an ORGANIZE BY clause for a CREATE TABLE, CREATE GLOBAL TEMPORARY TABLE, or DECLARE GLOBAL TEMPORARY TABLE statement.

Configuration type: Database
Parameter type: Configurable online
Default [range]: ROW [COLUMN, ROW]

COLUMN

Specifies that regular user tables are to be created as column-organized tables unless you specify the ORGANIZE BY ROW clause for the statement that creates the table. A default setting of COLUMN is ignored for the following types of tables, which can be created only as row-organized tables:

Materialized query table
Range clustered table
Multidimensional clustering table
Insert time clustering table
Global temporary table
Typed table

Starting from the DB2® Cancun Release, you can create a materialized query table as a column-organized MQT, but the ORGANIZE BY COLUMN clause must be specified when creating the MQT, even when dft_table_org is set to COLUMN.

ROW

Specifies that regular user tables are to be created as row-organized tables unless you specify the ORGANIZE BY COLUMN clause for the statement that creates the table. The ROW option is the default setting, unless the default table organization was set to COLUMN automatically by setting the DB2_WORKLOAD registry variable to ANALYTICS before creating the database.

If you set the DB2_WORKLOAD registry variable to ANALYTICS and you do not disable the AUTOCONFIGURE option, a newly created database or a database that you configure by using the Configuration Advisor uses a value of COLUMN for the dft_table_org configuration parameter. Note that a newly created database will be auto-configured by default unless the DB2_ENABLE_AUTOCONFIG_DEFAULT registry variable is set to NO, or the AUTOCONFIGURE APPLY NONE clause is specified on the CREATE DATABASE command.