dft_extent_sz - Default extent size of table spaces configuration parameter

Configuration type

Database

Parameter type

Configurable Online

Propagation class

Immediate

Default [range]

32 [2 - 256 ]

Note: The default value is subject to change by the DB2® Configuration Advisor after initial database creation.

Unit of measure

Pages

When a table space is created, EXTENTSIZE n can be optionally specified, where n is the extent size. If you do not specify the extent size on the CREATE TABLESPACE statement, the database manager uses the value given by this parameter.

Recommendation: In many cases, you will want to explicitly specify the extent size when you create the table space. Before choosing a value for this parameter, you should understand how you would explicitly choose an extent size for the CREATE TABLESPACE statement.

In a DB2 pureScale® environment, you should use an extent size of at least the default (32 pages). This minimum extent size reduces the amount of internal message traffic within the DB2 pureScale environment when extents are added for a table or index. Examples of cases where new extents are allocated frequently, and where a larger extent size is beneficial, include the load and import utilities, the CREATE INDEX statement, and bulk insert operations from applications.