 | - Would you like to be able to estimate the cost of queries without actually executing them?
- Can you benefit from advice and guidelines for writing more efficient SQL statments?
- Would it be useful to be able to perform "what-if" scenarios to determine performance obtained from various database designs and production volumes?
- Are you interested in optimizing the performance of your SQL statements for DB2 for z/OS Versions 9, 8, or 7?
IBM DB2 SQL Performance Analyzer provides you with an extensive analysis of SQL queries without executing them. This analysis aids you in tuning your queries to achieve maximum performance. You can also reduce the escalating costs of database queries by estimating their cost prior to execution. DB2 SQL PA provides seamless support for DB2 Versions 7, 8, and 9. Data and content are easily readable in redesigned reports. Stored procedure runs under z/OS Workload Manager and RRSAF. DB2 SQL Performance Analyzer delivers complete integration with Easy Explain in both TSO and batch, allowing you to compare the costs of old and new plans and to re-explain existing plans stored in any plan table. Programming language data sets can be scanned directly to extract SQL for study.  - Access any report for any input source (DBRM, plan, package, etc.).
- View summary reports that enable you to access a specific report directly from the summary report. Efficient navigation enables quicker access to the information you need most.
- Smooth workflow with a single point of entry into the tool.
- Access embedded SQL from source programs (PL/I, COBOL, C, Assembler).
- Drill down to view all the SQL or all the DB2 tables within the given input source (such as plans, packages, and DBRMs). This enables you to explain a single SQL query or all of the SQL for the DB2 table that is selected.
- Use the DSN8.DSN8EXP procedure to enable application programmers to see SQL performance against tables for which they do not have authority to run SQL.
- Apply maintenance faster and easier with package versioning.
- Use parameters that enable developers to use materialized query tables as access path choices.
- Call DB2 SQL PA as a stored procedure. The DB2 SQL PA Stored Procedure runs either under the z/OS Work Load Manager (WLM) or the Call Attach Facility (CAF).
- Fast, easy, and automated installation and customization.
- Offers "what-if" scenarios to help determine the performance that can be obtained using various database design alternatives and production volumes. "What-if" analysis capabilities include updating catalog statistics and creating new indexes.
- Provides user-modifiable thresholds that can set high water marks, trigger warnings and alerts, and control advisory messages.
- Offers ISPF enhancements including field level help, the use of PDS for input and output, and dynamic trace enabling for diagnostics.
- Enhances statistics migration with global wildcarding at the database, tablespace and table levels. Expands the maximum number of objects collected in a single run.
- Provides seamless support for DB2 9, DB2 Version 8, and DB2 Version 7 by automatically detecting the current DB2 version and behaving accordingly.
- Delivers performance analysis for all phases of database application design and development.
Program number: 5697-I04
Performance Management and Application Management |
IBM DB2 SQL Performance Analyzer for z/OS, V3.2 is designed to operate with the following DB2 versions: - DB2 9 (5635-DB2)
- DB2 V8 (5625-DB2)
- DB2 V7 (5675-DB2)
The following versions of the z/OS operating system are required: - z/OS V1.7 (5694-A01), or later
For more information on the system requirements, see the Program Directory on the Library page.  Get Adobe® Reader®
|
| |
|
