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
- 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.