The DB2 Performance Tuning and Monitoring Clinic is a series of distinctly focused presentations and labs replete with "How to's" and "Best Practices" intended to help the attendee master the intricacies of maintaining a healthy and robust DB2 based information management system including:
- How to gather critical system resource information.
- Best Practices for Database Design.
- How to start with a strong foundation via good configurations for optimal performance.
- How to configure and use new Monitoring Table Functions and Event Monitors.
- What performance metrics to monitor and collection methods.
- What monitoring interfaces and tools are available with your DB2 installation.
- How to diagnose DB2 activities that may be causing system bottlenecks.
- How to find and identify locking issues.
- How to improve concurrency with new isolation level Currently Committed.
- How to capture and tune SQL queries.
- Best practices for performance enhancing utilities; runstats & reorg.
- How to mitigate the impact of utilities, like backup, reorg, and runstats on your database system.
At the end of the bootcamp, attendees may take the M45 IBM Information Management DB2 Technical Mastery Test at no-charge. Those who have successfully passed the M45 test are encouraged to take the 730 DB2 9 Family Fundamentals Certification Exam during the workshop at no-charge.
Prerequisite: The material is presented at a technical level assuming a working knowledge of DB2. Intermediate knowledge of DB2 and/or prior attendance of the DB2 9.7 Bootcamp is required.