Documentation Comments
Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.
RealityV15.1Online Documentation (MoTW) Revision 7
AFS-EXPAND command (m605006+afsexpand.htm)
Expands an AFS file; that is, a data section or index that is configured for automatic file sizing.
AFS-EXPAND file-specifier {index-name} {( [ B | percentage ]}
file-specifier Specifies the required data section or the data section containing the required index.
See General Conventions for the full syntax of file-specifier.
index-nameOptional. The name of the required index.
BRun as a background process (recommended for expanding large files and indexes). A background AFS-EXPAND continues when the user logs off.
percentageThe percentage by which to expand the file or index. The default, if omitted, is to complete the current expansion - for example, if the data section or index currently has a modulo of 7 and a size of 11 groups, it will be expanded to 14 groups and the modulo will be doubled to 14.
Can only be run by the database owner.
When the number of groups in a file increases to twice its current modulo, the modulo is doubled.
You can stop AFS-EXPAND
at any time provided the BREAK key has not been disabled. Press the BREAK key and then
enter
END to exit the DataBasic debugger. Note that if you want
to restart the expansion process, you will need to use
the ISTAT command to find out how much
of the expansion has completed.
The default data section of the AFS file MYAFSFILE has a current modulo of 126 and has expanded to 182 groups. This is then expanded by 50% as follows:
AFS-EXPAND MYAFSFILE (50
On completion, the file will have 273 groups and the modulo will have been doubled to 252.
If the file is then expanded without specifying a percentage, the number of groups will be increased to 504 and the modulo will be doubled (also to 504).