Daily Database Health Checks

On a daily basis, I use a few regular checks to ensure the health of client databases as follows:

1. Top 10 SQL script

2. Review of all key database manager and database shared memory areas such as post threshold sorts, sort overflows, hash join loops, small and large overflows, package cache overflows, any type of log issues, errors in the db2diag.log, review of  table space, space limits, check of file system capacity, disk space used and a review of CPU and IO used. 

3. Properly scripted, this whole process can be done in 5 to 15 minutes.