developerWorks: The DB2 UDB DBA Checklist

"While databases are becoming more and more self-aware and self-healing, they still require some monitoring to keep them running as efficiently as possible. Just like your car, a database requires some checks to keep it running optimally. This document is broken down into checks or tasks that should be run at different intervals.

"The first set of checks or tasks should be run every day to make sure there are no current or imminent problems. The second set should be run weekly to check for issues or problems that may have occurred during the week or are likely to occur in the coming week. The final set of checks or tasks need not be run every day or week, but should be run monthly to keep the system running without problems, and to prevent further issues in the event that a problem does occur..."

Complete Story

Related Stories:

• developerWorks: Modeling a Database with Rational XDE Developer for Java(Apr 22, 2004)
• developerWorks: Leveraging Your Oracle 9i Skills to Learn DB2 UDB for Linux, UNIX and Windows V8(Jan 14, 2004)
• developerWorks: Embedding a Relational Database Server into Eclipse, Part 2(Dec 17, 2003)
• developerWorks: Embedding a Relational Database Server into Eclipse(Oct 06, 2003)