Multipage file allocation

When using SMS table spaces, DB2 uses the operating system file system to
allocate space. By default this space allocation is acquired in small increments
that can introduce a great deal of overhead when insert activity for a table 
space is high. Multipage file allocation is used to improve insert performance 
for SMS table spaces. If enabled, all SMS table spaces are affected: there is 
no selection possible for individual SMS table spaces.

The default for the parameter is No — multipage file allocation is not enabled.
Following database creation, the parameter may be set to Yes, which indicates
that multipage file allocation is enabled. This is done using the db2empfa tool.

The db2empfa tool can be executed from a command prompt, with the name of
the database to enable multipage file allocation as a parameter as follows:
DB2EMPFA SAMPLE
Important: Once set to Yes, the parameter cannot be changed back to No.