Skip to content

Daily Database Health Checks

December 31, 2012

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.




From → Uncategorized

Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: