DB2 10.5 for Linux, UNIX, and Windows

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

Read syntax diagramSkip visual syntax diagram
>>-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.