db2empfa - Enable multi-page file allocation command
Enables the use of multi-page file allocation for a database. With multi-page file allocation enabled for SMS table spaces, disk space is allocated one extent at a time rather than one page at a time.
Scope
This command only affects the database partition on which it is executed.
Authorization
SYSADM
Required connection
None. This command establishes a database connection.
Command syntax
Command parameters
- database-alias
- Specifies the alias of the database for which multi-page file allocation is to be enabled.
Usage notes
This utility:
- Connects to the database partition (where applicable) in exclusive mode
- In all SMS table spaces, allocates empty pages to fill up the last extent in all data and index files which are larger than one extent
- Changes the value of the database configuration parameter multipage_alloc to YES
- Disconnects.
Since db2empfa connects to the database partition in exclusive mode, it cannot be run concurrently on the catalog database partition, or on any other database partition.