OPTIMUM-MODULO
Calculates the optimum modulo at a specified frame size for one or more files and sets the resizing parameters for those files.
Syntax
OPTIMUM-MODULO statFileSection {account {fileNamePrefix}} {(frameSize {options}}
OPTIMUM-MODULO {account {fileNamePrefix}} (L{frameSize} {options}
OPTIMUM-MODULO {account {fileNamePrefix}} (C
Syntax Elements
statFileSectionThe name of a section in the file STAT-FILE that provides the file statistics on which the calculations will be based. If specifying this parameter, do not include the L option.
account Optional. The name of an account to process. If omitted, the entire database is processed.
fileNamePrefix Optional. The first few characters of the required file names. All files in the specified account that have names beginning with these characters will be processed.
L Use the STAT-FILE section from the last save (/SYSFILES LAST.SAVE). Use this option instead of specifying statFileSection.
frameSize The required frame size - must be one of 1, 2, 4 or 8. If omitted, defaults to the current frame size.
C Clear the resizing parameters for the specified files.
Options
P Send the output to the current default printer.
T Test mode - report the modulo changes that would be made, but do not set the resizing parameters. This can be useful when examining a STAT-FILE generated on another database.
EexpansionCoefficient
Set the expansion coefficient (percent); default, 25.
Note that you cannot omit frameSize when using this option. expansionCoefficient must be the second numeric parameter following the open parenthesis.
Restrictions
Only available in the SYSMAN account. SYS2 privileges required.
Comments
-
The new modulo is calculated using the following formula:
(inGroupSize / frameSize) * (1 + expansionCoefficient / 100)
where inGroupSize is from the relevant field in the STAT-FILE section.
-
File dictionaries and default data sections are listed separately. For example:
/MYACCOUNT/MYFILE 1 7
/MYACCOUNT/MYFILE,MYFILE 11 29-
The first line shows that the dictionary of MYFILE is badly sized; its modulo is currently 1 and it should be 7.
-
The second line shows that the default data section of MYFILE is badly sized; its modulo is currently 11 and it should be 29.
Only badly sized dictionaries and data sections are included in the list.
-
-
Unless the T option is specified, OPTIMUM-MODULO sets the resizing parameters for the specified files to the calculated values, so that you can reconfigure your database as follows:
-
Save the database using the FILE-SAVE command.
-
If changing the the frame size, rebuild the database by using mkdbase with the -r and -F options. The -F option allows you to specify the new frame size.
-
If you want the restored files to be automatically sized, ensure that the AutoFileSize database configuration parameter is set to 1. Alternatively, run the AFS-SET command.
-
Restore the saved data with ACCOUNT-RESTORE.
-
-
When processing a large number of files with OPTIMUM-MODULO, using the P option to send the output to a printer instead of to the screen will increase performance.
Example
Display the best modulo for each file with a name beginning with 'FUNCT' in account TRAVCO:
:OPTIMUM-MODULO DMGSF TRAVCO FUNCT (T Select STAT-FILE,DMGSF WITH *A1 = "TRAVCO*FUNCT]" 24 Items selected. /TRAVCO/FUNCT.B/HOUSE,FUNCT.B/HOUSE 1 3 /TRAVCO/FUNCT.AJ,FUNCT.AJ 1 3 /TRAVCO/FUNCT.CURSOR,FUNCT.CURSOR 1 3 /TRAVCO/FUNCT.HHH,FUNCT.HHH 1 3 /TRAVCO/FUNCT.BNBB,FUNCT.BNBB 1 3 /TRAVCO/FUNCT.CJ1,FUNCT.CJ1 1 3 /TRAVCO/FUNCT.,FUNCT. 1 3 /TRAVCO/FUNCT.RETAIL,FUNCT.RETAIL 1 3 /TRAVCO/FUNCT.CHAN,FUNCT.CHAN 1 3 /TRAVCO/FUNCT.GALILEO,FUNCT.GALILEO 1 3
The output indicates that each of these files currently has a modulo of 1, but should have a modulo of 3.