AFS-ENABLE

Converts a specified data section or index to use automatic file sizing.

Syntax

AFS-ENABLE {file-specifier {index-name}}

Syntax elements

file-specifierSpecifies the required data section or the data section containing the required index.

See General Conventions for the full syntax of file-specifier.

If used without a file name, AFS-ENABLE converts all the data sections and indexes specified in the currently active select list (see AFS-SELECT).

index-nameOptional. The name of the required index.

Restrictions

Can only be run by the database owner.

Comments

AFS-ENABLE does not resize the specified data section or index, it just converts it to use automatic file sizing.

A data section and its indexes can be independently configured for automatic file sizing.

The AFS-ENABLE command can also be used to re-enable automatic file sizing for a data section or index that has automatic sizing suspended with AFS-HOLD.

The CREATE-FILE command allows you to create a new automatically sized data section. Similarly, automatically sized indexes can be created with CREATE-INDEX.

AFS-ENABLE is not transaction logged.