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.
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. Once set to YES, the parameter cannot be changed back to NO.