5 Database Administration Monitoring the Database
UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 249
The command, by default, sends warning messages to the error log
indicating a threshold was exceeded (the -i option must be run first). The -
e option disables 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 (~). Following are sample outputs:
(Output to error log when less than 13% available or more than 23% used
by rollback)
# dbcheck -w13,23
dbcheck Command Output
The dbcheck program returns the following values:
• 0 — Success (no limits exceeded)
• 1 — Threshold exceeded
• 2 — Processing error
• 3 — Database is not running
The dbfree
Command
The dbfree command is a shell script that lists the amount of free space in
the database by free contiguous blocks. The result will be a detailed listing of
each free memory area followed by the sum of each tablespace. The free
blocks listed are in 2048 bytes per block (ORACLE blocks). There is also a
column that lists the same information in megabytes.
