440101

Using DB2 for i5/OS Monitors to Analyze and Improve SQL & Query Performance

Speaker(s):
Gene Cobb IBM Corporation


Have you ever tried to solve a query or SQL performance problem with someone else's program and not known where to start? One of the tools that can help is the iSeries most overlooked performance monitors, the database performance monitors. The data collected by the integrated DB2 monitors during runtime can be used to dientify which database requests are causing the biggest performance issues.

By the end of this session, attendees will be able to:
1. Collect database performance monitor data.
2. Understand the data that's collected and how it's organized.
3. How to use the data to identify & fix performance problems.


33ML: Tuesday, 11:00-12:15 pm, B211Add To My Personal Grid Handout

One & 1/4 hrs
Course of Study: DB2 UDB for the iSeries

Handout available on web