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:

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s

%d bloggers like this: