AFS-SELECT

Generates a select list of data sections and indexes that are undersized and would therefore benefit from conversion to automatic file sizing. This list can then be used as input to AFS-ENABLE.

Syntax

AFS-SELECT [ SYSTEM || /account || file-specifier ]

or

AFS-SELECT statFileSection{ account} (S

Syntax Elements

SYSTEMScan all files and indexes.

accountThe name of the account to scan.

file-specifier Specifies the file to scan (see General Conventions for the full syntax of file-specifier). All the data sections and their indexes will be scanned. Any data section you specify is ignored.

statFileSectionThe name of a data section in STAT-FILE that contains a list of files to scan. If account is also specified, only files in that account are scanned.

Options

SSpecifies that the first parameter is the name of a section in STAT-FILE and that the second parameter, if present, is the name of an account.

Restrictions

Can only be run by the database owner.

Comments

The select list generated by AFS-SELECT is saved with the name AFS*portNumber. To use the list as input to AFS-ENABLE, use GET-LIST to make this list the active select list.

If required, the list can be edited with EDIT-LIST before being used. Each entry in the select list generated by AFS-SELECT has the form:

/account/file,dataSection{ index}

Note that the only files in the select list are those that are not already set for resizing and that need resizing; files that are not AFS but are already the correct size are not included.

If no files are in suitable condition, then the following is returned:

AFS-SELECT: No suitable files found