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.
Required connection
None. This command establishes
a database connection.
Command syntax
>>-db2empfa--database-alias------------------------------------><
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.