Quality and Performance of SQL Queries
InfoScope® for DB2 on z/OS
Together with InfoSimulation and InfoTrace, InfoScope is part of the INFO-OPTIMIZER line, an automated software suite ensuring the quality and performance of DB2 applications.
The Problem
- Designing and optimizing database operation is vital for a company
- Is performance always a central concern in your development efforts?
- How can you guarantee that application performance is satisfactory today and will continue to be tomorrow with a higher volume of data?
- How can you guarantee that each of your DB2 applications in production complies with your standards?
- What is the cost of running a vital application with degraded performance?
The InfoScope solution
- InfoScope automatically monitors the quality and performance of SQL queries
- InfoScope makes these checks based on your performance, maintainability, and scalability criteria
- InfoScope is used when designing and writing the programs to ensure current and future performance
- InfoScope is deployed very easily so the entire development department can filter and check for compliance with the specified standards
The advantages of InfoScope
Quality assurance for your DB2 queries
- Automatically applies and checks your quality initiative
- Guarantees application quality and performance by limiting drifts from specified standards
- Reduces CPU time by avoiding proliferation of queries from resource consumers
- Guarantees transaction response times
- Provides your developers with training on the complex mechanisms of the DB2 optimizer by supplying detailed analysis reports and recommendations for optimizing SQL queries and DB2 access paths
We are prepared to demonstrate to you the excellent return on investment you will achieve with InfoScope.
© Infotel 2011. Last update January 2, 2011
http://www.infotelcorp.com - Phone : + (1)727 343 5958