A Summary of Commands dbcheck
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 403
The third usage actually checks database space against a user set “water
marks.” Three different things are checked:
• Free space
• Extents against the user set threshold n (15% default)
• Rollback segment(s) growth against the user set threshold m (20%
default)
When executed, the dbcheck command generates the appropriate warnings
(shown under “Diagnostics” below) if the database falls below n percent free
or if the rollback segment grows to be more than m percent of the total
database size.
The dbcheck command, by default, sends warning messages to the
logger/alerter indicating a threshold has been exceeded (the -i option must
be run first). The -e option disables the entries from going into the log file. The
-s option prints the warning messages to standard output. The -m user option
allows for the messages to be mailed to user. Multiple users can be sent the
mail by separating the user names with a tilde (~). Below are sample outputs.
(Output to error log when less than 13% available space/extents or more than
23% used by rollback)
