Contact us online or call (800) 327-9650.  
 
SQL PerformanceExpert for DB2 z/OS
Efficiently written SQL code means efficient CPU usage, improved response time, reduced I/O activity and reduced resource locking. SQL PerformanceExpert (SPX) assures best SQL performance from the beginning. It assists in writing SQL, streamlines QA and even identifies performance bottlenecks in production.
SPX 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.
SPX 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
  • Checks new/changed SQL against production data interactively
  • Identifies and eliminates unnecessary package versions
  • Simulates production-level SQL access paths
  • Compares SQL statements from different source versions for best performance
  • Offers the right interface and function for
    • developers
    • QA staff
    • production DBAs
  • Supports DSN_VIRTUAL_INDEXES, allowing you to drop or create indexes to see the affect on SQL performance
Legal
Downloads
Product Description >>
Customer Story >>
Product News
Enterprise Statistics Distribution enables quick and easy simulation of production baseline environments on multiple test and QA systems. Easy refreshes can be done in a blink of the eye. This keeps systems in-sync with your production environment and efficiently supports multiple distributions.
Contact us
Request more information >>