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.
