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 if you do not specify the ORGANIZE BY COLUMN or the ORGANIZE BY ROW clause for the CREATE TABLE statement.

Configuration type
Database
Parameter type
Configurable online
Default [range]
ROW [COLUMN, ROW]
COLUMN
Specifies that regular user tables are created as column-organized tables unless you specify the ORGANIZE BY ROW clause for the CREATE TABLE statement. A default setting of COLUMN is ignored for the following types of tables:
  • Materialized query table
  • Range clustered table
  • Multidimensional clustering table
  • Insert time clustering table
  • Typed table
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 created as row-organized tables unless you specify the ORGANIZE BY COLUMN clause for the CREATE TABLE statement. 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 prior to 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.