OPTION (20) Modifications to Baseline - NONE                               GRAPHIC EXAMPLE

(ZFS-00) NIGHTLY FILE STATISTICS AND RESIZING MODULE

This memorandum provides information with regard to the need to periodically resize files.

The ZFS-00 Custom Module provides a Menu-driven system for Nightly/Weekly resizing of files which have become inefficient due to growth. File statistics are generated, and reports provided, plus the capability for automatic file resizing. Capability is included to exempt specific files from automatic resizing, as well.

Many "transactional" type files, such as STOCK, WO-BOM, GJ, INV, etc. will tend to grow larger, until such time as File Purges are performed. Files such as STOCK will grow each day. Files such as INV-SUMMARY will grow, each time the user runs the DAILY ACTIVITY SUMMARY (MMI-U-01). Files such as GJ,AR will grow only when Journals are created from Invoices and Cash, usually once per month.

Even relatively "static" files (PARTS,VENDOR,CUSTOMER, COST-VERSION) tend to show a slow but steady growth. Since these files are rarely purged, the files need to be watched on a longer-term basis to see the pattern of growth. Files such as GJ,INV and STOCK should be sized, in advance, to contain the required amount of history.

Unlike many mainframe systems, UNIDATA@ files are quite tolerant of undersizing. However, system performance is degraded if file sizing is not regularly performed.