Quality assurance and Performance for DB2 applications

DB/IQ is a software solution designed to guarantee the level of quality and maintainability of DB2 applications before deployment in production. DB/IQ automates the quality control process according to performance, maintainability and scalability criteria. Easy to install and operate, DB/IQ offers features designed for DBA and is also integrated into development environments in order to detect performance issues and violations of Best Practices as soon as possible.

See related resources

Specify and enforce a Quality model for your applications

DB/IQ analyses and monitors the quality of any SQL statement according to DB2 best practices and custom rules and standards.

  • Defines and centralizes common requirements for quality and performance
  • More than 350 rules, delivered as standard, can be modified and enhanced according to their severity.
  • Analyses are performed on all SQL statements, regardless of origin.
  • The EXPLAIN function in DB/IQ provides developers with clear and detailed explanations of the statement execution by the DB2 Optimizer such as access paths.

  • The integration in the ISPF interface and Eclipse-based IDEs assist developers in detecting defects early and contribute to improving their skills.

Detect performance and maintainability issues

Thanks to its audit functions, DB/IQ assesses your system’s situation and detects workload issues.

  • Any SQL statements – static or dynamic – can be analyzed.
  • The simulation function makes it possible to pinpoint loading issues in DB2 applications.
  • All analysis results will be saved, making it possible to monitor the development of a given SQL statement’s or an entire DB2 application’s quality level, and this for a given period of time.

  • The automatically generated reports provide the necessary information for implementing the appropriate actions.

Optimized an Index Model

DB/IQ offers a set of features designed to reduce database operating costs as well as DBA’s workload.

  • Indexes belong to the most critical resources of a DBMS. DB/IQ provides a solution to automatically evaluate the existing model and recommend a new and optimized index model.
  • The index simulation function measures the impact of any index model modifications, while considering the execution frequencies.
  • DB/IQ sustains system integrity and helps clean obsolete items by checking the consistency between: LOADLIB, DBRM and packages.
  • Deployment is facilitated by migrating object specifications consistently and impartially. DDLs are automatically generated for all objects defined in the Catalog.