File Statistics Reports

File statistics reports are generated automatically by the following commands:

• FILE-SAVE (and F-S).
• ACCOUNT-SAVE.
• M-A-S (generates and prints a statistics report for each account saved).
• ACCOUNT-FILE-STATS (generates and prints a statistics report for one account).
• ALL-FILE-STATS (generates and prints a statistics report for all accounts).
• LIST-$STAT-FILE* (prints the last set of statistics generated on current port).
• LIST-FILE-STATS (prints current statistics from the STAT-FILE default data section).

Contents of the Report

File statistics reports are broken down by account. Each account begins a new page in the report. The following information is provided for each file in the account:

• Base, modulo and separation.
• Order of the file on the SAVE tape.
• Total number of items in the file.
• Size of the file in bytes.
• Maximum and minimum number of items in a group.
• Total frames used by the file.
• Breakdown of groups according to what percentage of each is full.
• Group Format Errors (GFEs).

The last line for each account lists the total number of items, bytes, frames, and GFEs.

STAT-FILE File

STAT-FILE is part of a standard database. It is located in the SYSFILES account. When any one of the Procs generating statistics is executed, a data section is created within STAT-FILE to log the file statistics generated. These data sections are named PORTn where n is the port number from which the generating command was invoked. Any existing data section with this name is cleared. Thus, data section PORT23 holds the last set of statistics generated by an appropriate command entered from port 23.

You can find out which section in STAT-FILE contains the latest set of file statistics by listing the contents of the item LAST.SAVE in the MD of the SYSFILES account. For example:

:CT /SYSFILES/ LAST.SAVE
 LAST.SAVE
001 Q
002 SYSFILES
003 STAT-FILE,PORT401
:

Group Format Errors

You can find out which files contain Group Format Errors (GFEs) by listing the appropriate STAT-FILE section using the FILES.WITH.GFES macro. Then use the LISTFILES command to display the file details.

The most likely causes of GFEs are as follows:

• Missing clean log files. These have two data sections: a default data section with Ftype  = C3, and BINARY with Ftype  = A3. This is most likely to occur if you restore a save onto a new database that has not been configured for transaction logging.
• DIR-VIEW files for which the associated host directory no longer exists. These have Ftype  = D3  and Mod Details  equal to the directory path.
• SQL-VIEW files for which the connection to the associated SQL database is not available. These have Ftype  = G3  and Mod Details  equal to the data source name and user-id.
• Special files (created with MAKE-SPECIAL) for which the associated information (host file, index, etc.) no longer exists. These have Ftype  = E3.

In all these cases, you can simply delete the file concerned. If the file has any other Ftype, contact your NEC Software Solutions representative.