1 INVOKE 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 2 Example Main Editor Function (Keyword)[Help] : INVOKE Script Title Selection Add_key modeling and addition of a new index's parameters Delete_key removal of the highest index's parameters Indexed modeling of parameters for an entire Indexed file Optimize tuning of all indices' parameters using file statistics Relative selection of parameters for a Relative file Sequential selection of parameters for a Sequential file Touchup remodeling of parameters for a particular index Editing Script Title (Keyword)[-] : This command allows you to select which script you want to help you design your FDL file. After you enter the INVOKE command, the Edit/FDL utility prompts you with another menu displaying the possible script choices.