multipage_alloc - Multipage file allocation enabled configuration parameter

Multipage file allocation is used to allocate a full extent when growing SMS table spaces rather than a single page. It is used to improve insert performance, and it applies to SMS table spaces only. If enabled, all SMS table spaces are affected: there is no selection possible for individual SMS table spaces.

Configuration type
Parameter type

The default for the parameter is Yes: multipage file allocation is enabled.

Following database creation, this parameter cannot be set to No. Multipage file allocation cannot be disabled once it has been enabled. The db2empfa tool can be used to enable multipage file allocation for a database that currently has it disabled.