Working with Performance Warehouse

This topic first describes the tasks you need to perform before you can start working with Performance Warehouse and then how to use Performance Warehouse to perform analysis tasks on DB2® performance data using processes, rules of thumb, and queries.

Performance Warehouse provides a process-oriented view of performance-analysis tasks. It allows you to automate tasks that previously required user interaction, such as loading DB2 data into the Performance Warehouse database or generating reports.

A process can consist of steps that link together these manual tasks. For example, you might want to transfer DB2 trace records on your MVS system to the Performance Warehouse database for further analysis. Your corresponding Performance Warehouse process might consist of a:
  • CONVERT step that converts a save data set to a Save-File data set.
  • LOAD STATISTICS step that loads the data set into the Performance Warehouse database.

Processes represent recurring performance-analysis tasks, they can be scheduled for automatic and repeated execution. You can trace these process executions from the workstation.

Processes produce output data that provides DB2 performance-related information. You can load this data into the Performance Warehouse database and then use rules of thumb and SQL queries to analyze it. Rules of thumb represent a category of expert rules. These rules help you identify more complex performance problems and provide you with tuning recommendations. For example, you can combine several performance counters in a value expression and relate this expression to problem and warning thresholds. You can also create, store, and run SQL queries on the Performance Warehouse database.

Sample processes, rules of thumb, and queries are provided to help you get started.