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)
