RESIZE-FILE

Enables resizing of a Reality file while allowing database users continuous access to it.

Syntax

RESIZE-FILE file-name {index}{modulo}{(options}

Parameters

file-name Name of file to be resized.

index Index section to be resized.

modulo New modulo for resized file/index. For guidelines on how to determine the optimum modulo, refer to File and File Index Management.

Options

R Restart a resize that has been discontinued, for example, by a database shutting down. No modulo should be supplied.

B Background mode (that is, disconnect from terminal).

V Verbose mode.

Restrictions

The following restrictions apply to the use of the RESIZE-FILE command:

• The database must be a Partition Database.
• You must be logged on to Reality as the database owner.
• Can only be executed from the SYSMAN account.
• Only data or index sections that are not configured for automatic file sizing (AFS) can be resized.
• Data sections cannot be accessed sequentially while a file is being resized. Any attempt to do so (for example, by an English query that is not using an index) will hang until the resize is complete. However, if the file has an index by item-id, the index will be used automatically while the resize is in progress, enabling the query to complete.
• Resizing should not be initiated while a long English query is in progress, as this will cause the result of the query to be indeterminate.
• Can only be executed once per file per session of the database daemon.

Comments

Automatic file sizing is the recommended way of sizing files.

RESIZE-FILE is not logged.