HP R4.2 dbfree, dbcheck, Monitoring the Database, 5 Database Administration

5 Database Administration Monitoring the Database

The dbfree Command

The command, by default, sends warning messages to the error log indicating a threshold was exceeded (the -ioption must be run first). Thee option disables 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 (~). 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 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.

UCS 1000 R4.2 Administration 585-313-507 Issue 3 April 2000 249