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 itelligent 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
  • Identifies and eliminates unnecessary package versions
  • Simulates production-level SQL access paths as if they were generated by the rebind process
  • Compares SQL statements from different source versions for best performance
  • Offers the right interface and function for
    • Developers
    • QA staff
    • production DBAs
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 >>