sizemon
Scans the whole or part of a database and reports any badly sized files.
Restrictions
You must be logged on to the host as the database owner.
If you are using Database Isolation, you must use realroot to select required instance of Reality before running sizemon.
Syntax
sizemon {options} {file {file...}}
sizemon {options} {-l} listfile
Parameters
file Specifies file to be scanned.
listfile Specifies a text file on the host containing a list of accounts and files to be scanned. See Rules for Setting Up List File.
Options
-d databaseSpecifies a database, other than the default, to be scanned. Default is specified in REALDBASE.
-a accountSpecifies logon account to be scanned. Default is specified in REALACC.
-s sizeReports any items greater than size blocks.
-o limitSets a lower limit on the average number of overflow blocks before reporting.
-c Calculates a new optimum modulo for any badly sized files.
-l Specifies a text file on the host containing a list of accounts and files to be included, or excluded, from being monitored.
-v Verbose mode.
Examples
sizemon {-d database} /SYSTEM
Scan the whole database (No inclusions or exclusions).
sizemon -a account
Scan all files in a specified account.
sizemon file1 file2
Scan specified files. Files must be specified in /account/file format.
sizemon -a account file1 file2
Scan specified files in a specified account. File names must not be in /account/file format.
sizemon -l listfile
Scan account(s) and file(s) listed in the host text file listfile. The syntax of the list file is described below.
Rules for Setting Up List File
The list file is a host text file containing a list of accounts to be included or excluded from the scan. The following rules apply:
-
If the file contains only exclusions, then all other accounts are included.
-
If there are any explicitly included accounts, all other accounts are implicitly excluded.
-
If there are any explicitly included files within an included account, then all other files in that account are implicitly excluded.
-
If there is a mixture of included and excluded files, all other files in that account are implicitly excluded.
The rules for formatting the List File are as follows:
-
Whitespace lines are ignored.
-
A line starting with a hash character (#) is ignored.
-
An account followed by a minus sign will be excluded.
-
A list of files may follow the account. If the account is excluded, the file list is ignored.
-
Each file appears on a separate line following a plus or a minus sign, indicating inclusion or exclusion, respectively.
Example List File
#Example list ACCOUNTA - # Exclude this account. ACCOUNTB # Include all of this account. ACCOUNTC # Include only the files listed. + FILEC1 + FILEC2 ACCOUNTD # Include all files in account except those - FILED1 # listed. - FILED2