A Summary of Commands

dbcheck

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 -ioption must be run first). The -eoption disables the entries from going into the log file. The -soption prints the warning messages to standard output. The -muser 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)

UCS 1000 R4.2 Administration 585-313-507

Issue 3 April 2000 403