|
The FILE.STAT command reports details of all files in selected accounts.
Format
FILE.STAT {DICT} {account.list | ALL} {LPTR}
FILE.STAT {{DICT} {file.list}} {LPTR}
where
| account.list | is a list of the names of the accounts to be reported. The ALL keyword may be used to process all accounts. If neither ALL nor a list of accounts is given, a report is produced for the current account. |
| file.list | is a list of files to be reported. If no file list is given and the default select list is active, this list is used to provide a list of files to be processed. |
| DICT | includes dictionaries in the report. |
| LPTR | directs the report to the default printer (print unit 0) instead of the screen. |
The FILE.STAT command can be used to report a summary of the files present in one of more accounts. The report that it produces requires a minimum output width of 132 characters.
The mode of operation is determined by the first name in the command line. If this is an account name, the command reports files in one or more accounts, otherwise the command reports details of one or more files in the current account.
The columns of the report are:
| File name | The name of the file. For a multi-file, each element is reported separately. |
| Typ | The file type. This may be DYN for a dynamic hashed file, DIR for a directory file, VFS for a virtual file or COL for a data collection file. |
| Cur Mod | The current modulus value (number of groups). |
| Min Mod | The minimum modulus setting of the file. |
| Grp | The group size in multiples of 1024 bytes. |
| Record Cnt | The count of records in the file. For a hashed file, this is an approximate count but should be close to the correct value. For a directory file, the FILE.STAT command counts the records. |
| Primary | The size in bytes of the primary subfile of a dynamic hashed file, including any space allocated to groups that have been discarded as a result of a merge. |
| Overflow | The size in bytes of the overflow subfile of a dynamic hashed file, including any space allocated to overflow blocks that have been discarded and are available for reallocation. |
| Total Size | The total size of the file. |
| AK | Does the file use alternate key indices (Y/N). |
| TR | Does the file have a trigger function defined (Y/N). |
| ST | Is statistics monitoring enabled on this file (Y/N). |
| NC | Does the file use case insensitive record ids (Y/N). |
| NR | Is the NO.RESIZE option active for this file (Y/N). |
| EN | Does the file use encryption (Y/N). |
| RP | Is replication enabled on this file (Y/N). |
| EC | Does this file support ECS (Y/N). Shown on ECS mode systems only. |
| JN | Is journalling enabled on this file (Y/N). |
Columns that are not applicable to directory files will be left blank for such files.
See also:
ANALYSE.FILE
|