Articles & Content


Where my request spending time? --- First taste DB2 9.7 Time Spent metrics (C04)

Topic: DB2 for LUW

Subtopic: 2010

DATE: 2010-5-11 (04:15 PM - 05:15 PM)
SPEAKERS: Pak Kwan (Fifth Third Bank)

Where is my database request spending time? It was a very difficult question for the pre db2 9.7. DBA does not have very good tools or methods to answer these questions. Thanks for new and improved DB2 9.7 monitoring features. Now, DB2 provides wait time monitor elements measure the time spend waiting for a particular entity or resource. In this presentation, Audiences will have first taste how sweet wait time monitor elements would be. Presenter will show audiences examples how to identify the performance bottlenecks.

EXP. LEVEL: Intermediate


Introduction a new database performance model: wait time analysis

Traditional Ratio based Analysis Vs Wait time analysis Audience can tell the different between these two methods. Pros and Cons

Overview Db2 9.7 Wait time Monitor Elements Audiences identify eight categories of wait time monitor elements.

Audiences can identify the IO is the bottleneck based on IO wait time data Audiences can identify the lock waiting is the bottleneck based on locking wait time data Demo is included.

Audiences are motivated to use wait time analysis as part of database performance and tuning technique as tool set.

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.