Command Reference

db2empfa - Enable Multi-page File Allocation

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 rather than one page at a time.

Scope

This command only affects the node on which it is executed.

Authorization

sysadm

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 on a node (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 on a node in exclusive mode, it cannot be run concurrently on the catalog node, or on any other node.