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 database Specifies a database, other than the default, to be scanned. Default is specified in REALDBASE.

-a account Specifies logon account to be scanned. Default is specified in REALACC.

-s size Reports any items greater than size blocks.

-o limit Sets 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