Quality and Performance of SQL Queries
DB2 InfoScope® for z/OS
Together with InfoSimulation and InfoTrace, DB2 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 DB2 InfoScope solution
- DB2 InfoScope automatically monitors the quality and performance of SQL queries
- DB2 InfoScope makes these checks based on your performance, maintainability, and scalability criteria
- DB2 InfoScope is used when designing and writing the programs to ensure current and future performance
- DB2 InfoScope is deployed very easily so the entire development department can filter and check for compliance with the specified standards