Top  Previous  Next


The FILE.STAT command reports details of all files in selected accounts.





FILE.STAT {DICT} {account.list | ALL} {LPTR}

FILE.STAT {{DICT} {file.list}} {LPTR}




account.listis 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.listis 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.        


DICTincludes dictionaries in the report.


LPTRdirects 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 nameThe name of the file. For a multi-file, each element is reported separately.
TypThe 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 ModThe current modulus value (number of groups).
Min ModThe minimum modulus setting of the file.
GrpThe group size in multiples of 1024 bytes.
Record CntThe 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.
PrimaryThe 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.
OverflowThe 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 SizeThe total size of the file.
AKDoes the file use alternate key indices (Y/N).
TRDoes the file have a trigger function defined (Y/N).
STIs statistics monitoring enabled on this file (Y/N).
NCDoes the file use case insensitive record ids (Y/N).
NRIs the NO.RESIZE option active for this file (Y/N).
ENDoes the file use encryption (Y/N).
RPIs replication enabled on this file (Y/N).
ECDoes this file support ECS (Y/N). Shown on ECS mode systems only.
JNIs journalling enabled on this file (Y/N).


Columns that are not applicable to directory files will be left blank for such files.



See also: