realresize

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

Restrictions

• On UNIX the database must be a partition database (see Types of Database).
• You must be logged on to the host as the database owner.
• Only data or index sections can be resized.
• Data sections cannot be accessed sequentially while a file is being resized. Any attempt to do so (e.g. 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.
• The modulo cannot be reduced.
• If you are using Database Isolation, you must use realroot to select required instance of Reality before running realresize.

Syntax

realresize {options} file-name {modulo}

Parameters

file-name File to be resized. The account containing the file must also be specified using the -a account option, unless it is in the default account or the /account/file format is used for the file name.

modulo New modulo for resized file/index.

Options

-d database Specifies the database, other than the default, containing the file to be resized.

-a account Specifies the account, other than the default, containing the file to be resized. The default account is defined in the REALACC environment variable.

-i index Specifies the index to be resized.

-b Background mode (that is, disconnect from terminal).

-r Restart a resize which has been discontinued, for example, by a database shutting down. No modulo should be supplied.

-v Verbose mode.