DB2 Version 9.7 for Linux, UNIX, and Windows

multipage_alloc - Multipage file allocation enabled configuration parameter

Multipage file allocation is used to improve insert performance. 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: Database
Parameter type: Informational

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.