 |
|
|
|
 |
DB2 SQL Tuning |
|
|
SQL PerformanceExpert®
 Well-tuned SQL statements mean efficient CPU usage, improved response time, reduced I/O activity and reduced resource locking. SQL PerformanceExpert for DB2 on z/OS analyzes SQL performance and identifies DB2 SQL tuning changes that improve application performance, pinpointing problem areas and saving time and money associated with inefficient applications.
SQL PerformanceExpert improves application performance and developer productivity with the following features:
 |
|
| • |
Uses intelligent analysis and continuous
monitoring to identify
SQL statements that can hinder application performance. |
|
|
| • |
Reduces I/O activity and resource
locking. |
|
|
| • |
Identifies and eliminates unnecessary
package versions. |
|
|
| • |
Enables fast, easy-to-use, automatic
index optimization and analysis. |
|
|
| • |
Simulates production-level SQL access
paths that are generated by the rebind process. |
|
|
| • |
Compares SQL statements from different
source versions for best performance. |
|
|
Product Benefits
|
|
| • |
Automatically analysis and SQL tuning |
|
|
| • |
Increase application performance and
stability |
|
|
| • |
Increase QA productivity and reliability
by reducing retesting needs |
|
|
| • |
Increase programmer productivity by
automating SQL analysis |
|
|
| • |
Ensure good SQL programming practices
with an expert system of over 600 rules and conditions |
|
|
| • |
Iterative method easily fits into
existing development and QA processes |
|
|
| • |
Optimize indexes for additional performance
enhancements |
|
|
| • |
Obtain informative, automated reports
on SQL and DDL analysis |
|
|
|
|
