DB2 Performance expert simplifies performance management and tuning (2)

Brief introduction

Do you need to analyze some of the key factors that enable you to control and tune DB2 and DB2 applications? Do you want to diagnose performance and availability issues ahead of time? Or have you encountered a problem using the DB2 server, but you cannot use the current snapshot to determine the cause of the problem, so you want to use historical monitoring data? IBM DB2 Performance Expert is a tool that can help you accomplish these tasks.

Working with scenes

The following scenarios demonstrate how to analyze and resolve performance issues and troubleshoot with the help of DB2 performance Expert V2.1:

Determining whether an index can improve performance

Re-review sorting performance

Examine the need to refactor a table

Ensure that there are enough DB2 agents to handle the workload

Resolving lock conflict issues

Frequently check the database using the SQL statements provided in the cache package

Analysis Buffer Pool

Monitor the health status of the system

Determine if an index is required

DB2 PE Step

Select Application Summary in the System Overview panel.

Figure 1. System Overview