Chat now with support
Chat with Support

Spotlight on DB2 6.9.3 - Release Notes

Client Application Analysis drilldown I/O Activity tab

The I/O Activity tab on the Client Application Analysis drilldown provides a summary of I/O activity generated by the selected application. The graphs show rates for the following:

  • Reads and writes that use the buffer pool

  • Direct reads and writes, which do not go through the buffer pool, but access the database directly

The bottom of the tab lists average I/O times (in milliseconds) for both buffered and direct reads and writes. The average times are shown in milliseconds.

Graphs

The graphs on the I/O Activity tab keep track of the rates for I/O generated by the application over consecutive monitoring intervals.

Data Read Rate

Index Read Rate

Index and Data Write Rates

Direct Read and Write Rates

Troubleshooting high I/O activity on the database

On the Databases drilldown, you might notice consistently high rates for the following activities on specific databases:

  • Physical read rates (compared to logical read rates)

  • Synchronous read or write rates

  • Direct I/O rates for a database

These high rates might be indications of performance degradation since the activities involve disk I/O and slow-downs in query processing. Use the graphs on this I/O Activity tab to identify the applications that are contributing to these rates.

 

Related topics

 

Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating