DB2 Version 9.7 for Linux, UNIX, and Windows

dft_extent_sz - Default extent size of table spaces configuration parameter

This parameter sets the default extent size of table spaces.

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.