Integrated performance management in a single solution
All the components of DB2® SQL Performance Solution Pack interact with one another to provide a comprehensive performance management solution.
- Retrieve performance data across all DB2 and z/OS® components
DB2 Query Workload Tuner or DB2 Query Monitor can determine whether performance issues at the query level are related to static SQL, dynamic SQL, or stored procedures.
- Capture queries and workloads for monitoring
DB2 Performance Solution Pack can capture queries and workloads from any of the following sources:
- DB2 Query Monitor (interval data sets or offload repository)
- DB2 Query Workload Tuner (offline repository)
- Database request modules (DBRMs)
- Flat files
- DB2 packages
- Caches
- Stored procedures
- Tune SQL statements in context
- Reactive tuning
From the web-based interfaces of DB2 Query Monitor , you can perform reactive tuning that identifies problem SQL, query workloads, or runtime metrics while your applications are running. You can then start DB2 Query Workload Tuner automatically for analysis and tuning recommendations.
- Proactive tuning
DB2 Query Monitor can also be a source of query workload data for capture and proactive tuning. This workload data includes the metrics that you need to tune your SQL statements, including execution counts and the current schema.
If you prefer to work in an ISPF interface, you can isolate an inefficient SQL statement in the ISPF interface of DB2 Query Monitor and start DB2 SQL Performance Analyzer for tuning. Expert advice then recommends appropriate next steps.
- Identify poorly performing transactions
You can send the offending SQL statements to DB2 Query Workload Tuner for further analysis.
- Evaluate query performance before you go into production
Application developers can use the recommendations that are available in DB2 SQL Performance Analyzer to fine-tune SQL statements, and then use DB2 Query Monitor to validate the performance improvements after the applications are in production.