Performance Expert Client

The Performance Expert Client (PE Client) is a Windows client that enables you to analyze and tune the performance of your Db2 subsystem and Db2 applications.

The PE Client provides information about Db2 subsystem activity, resource utilization, and processing times. It automatically informs you about problems or resource constraints such as deadlocks, timeouts, or CF structure resizing.

You can use the Classic User Interface to:

• Monitor threads, system statistics, and system parameters using a single tool that integrates performance monitoring, reporting, buffer pool analysis
• Monitor Db2 subsystems and Db2 Connect Gateways in a consistent way
• Access Performance Warehouse management and buffer pool analysis

The PE Client serves as the user interface for the Performance Warehouse and Buffer Pool Analyzer and is therefore prerequisite component for these components.

Online monitoring and reporting

The PE Client online monitor function allows you to identify bottlenecks, applications that are performing poorly, and areas for tuning improvements. You can review all of the defaults of the current activity at the system and application levels. Snapshot History, an optional subcomponent, allows you to look at historical data. This helps you compare information at various timestamps and to analyze problems that occurred in the past. In addition to these monitoring capabilities, the tool can inform you of specific Db2 situations, such as deadlocks, timeouts, lock escalations, and CF structure rebuilds. Another function called threshold exception processing checks the system or application information for threshold violations. This can help you detect increased usage or unusual usage patterns. The product then uses exits to automatically record this information even if you are not logged on to the PE Client. The exit writes the information to a system log where it can be picked up by system automation or where it can invoke a batch job that initiates further processing.

Performance Warehouse Client

The Performance Warehouse Client, a client embedded within the PE Client, allows you to manage the Performance Warehouse. You can use it to perform tasks such as defining the Extract-Transfer-Load (ETL) process for collecting and loading data or for creating reports from the collected data.

Buffer Pool Analyzer Client

Buffer Pool Analyzer Client, a client embedded within the PE Client, enables you to simulate buffer pool changes so that you can optimize buffer pool memory.