SQL Quality Assurance

SQL Quality Assurance

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.