This command prompts you for a script and initiates your choice.
The scripts guide you through the design and optimization of a
data file to ensure that complex operations are completed in a
logical fashion. If a script is aborted, script operations and
calculations are discarded, except for clearing the previous
definition. All scripts assume that the files you are desiging
reside on a Files-11 disk.
ADD_KEY
Modeling and addition of a new index's parameters. See
documentation under the "INDEXED" script for more information
about the design modes used in this script.
DELETE_KEY
Removal of the highest index's parameters.
INDEXED
The Edit/FDL utility asks several questions and then enters a
graphical design mode that allows modeling of the file indexes.
Two such modes are available: Line_plot and Surface_plot modes.
These refer to the type of graph on which the Edit/FDL utility
will display its calculated design choices. The basic goal of
these plots is to allow you to choose the best trade-off between
index bucket size versus index depth. While many of the other
file parameters have a significant effect on file performance,
these two are the most important.
o Line_plot - This design mode uses a graph that responds to
adjustments in the file design parameters. The current values
of the parameters are shown at the bottom of the screen and
you set them to new values to see their effect on the depth of
the index.
o Surface_plot - This design mode will graph a surface that
indicates index depth versus bucket size versus one other
parameter, which is swept through a range of values. The
choice of the 'other parameter' which is swept through a range
is: Load Fill Percent, Key Length, Record Size, Initial Load
Record Count, and Additional Record Count.
To aid in selecting an optimal bucket size for a particular
value of 'other parameter', a Recommended Range is delimited
on the surface plot. Bucket size values within this range
should provide a reasonably good trade-off between a flatter
index (less I/O) and larger buckets (more RMS processing).
Depending on your terminal's capabilities, the Recommended
Range is delimited either with "/"s on either side or by
the lightest or green shading. The left-most edge of the
Recommended Range will produce the flattest file for a given
bucket size, but if you're not very sure of the real-life
accuracy of all the answers given about the application
environment, it is better to be more conservative and choose a
value somewhere closer to the middle of the Recommended Range.
The default answer to the bucket size question is equivalent
to the left-most edge of the Recommended Range.
OPTIMIZE
This script is basically a Redesign of a particular index, with
the additional feature of using actual file structure data. The
ANALYZE/RMS_FILE utility can gather the required statistics
with the DCL ANALYZE/RMS/FDL command (which produces an FDL
file containing Analysis_of_area and Analysis_of_key Primary
sections).
The /ANALYSIS=file-spec qualifier of the DCL EDIT/FDL command is
used to input that information into the Edit/FDL utility.
RELATIVE
Selection of parameters for a Relative file
SEQUENTIAL
Selection of parameters for a Sequential file
TOUCHUP
This script allows the modification of one index's parameters at
a time. Only those FDL attributes pertaining to the chosen index
are changed. See documentation under the "INDEXED" script for
more information about the design modes used in this script.
Format
INVOKE
Additional Information:
explode
extract