Optimizing SQL Performance

Well-tuned and high-performing SQL statements equate to efficient CPU usage and improved response times. Analyze+ provides automated and intelligent analysis and tuning of SQL statements, improving the overall performance of production applications. With Analyze+, your technical staff is empowered to work smarter-saving time, increasing productivity and maximizing the use of the shrinking batch window.

Analyze+ fully exploits V8 and V9 of DB2 for z/OS; thereby providing you new capabilities to optimize your SQL workload. Its new technology internally uses V8 features like multi-row fetch and the new Explain tables, making it a milestone in speed, functionality, and usability.

Due to the amount of SQL statements used by applications - developed in-house or purchased - there is simply not enough time to analyze them all. Therefore, it is important to find and tune only the SQL that will really lead to a reduction of the workload. Whether you are coding, handing over an application to QA, or tuning SQL already in production, Analyze+ is the SQL optimization tool for you.

Key Benefits

• Recognize quality defects in SQL programming early in development
• Hand over high performing applications to production
• Monitors production applications to identify performance problems
• Analyzes dynamic statement cache
• Automates the DBA to eliminate otherwise manual work
• Explains XML under DB2 9
• Supports DRDA connectivity
• Eliminates the need for individual user Explain tables via a global Explain table pool
• Compares access paths

Product Description   (PDF, 65.9 KB)