Command Reference

db2empfa - Enable Multi-page File Allocation

Enables multi-page file allocation for a database.

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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]