Block non-compliant SQL code before it goes into production

Quality Assurance for Db2

Efficient development requires the ability to identify performance issues and ensure long-term maintainability from the design stage. The later in the development process that defects are found, the more difficult they are to fix. The sophistication of the Db2 environment may cause bad SQL to be written. Even if the Result Set is correct, it may be very inefficient or contain ”time bombs”, which results in future failures or major performance problems.

Defining standards and guidelines for developing Db2 applications is essential, but without Quality Assurance methods and procedures, the defined standards cannot be effectively enforced. In a production environment, where many thousands of SQL statements are executed, an automated Quality Assurance workflow is the only way of ensuring compliance with standards.

 

 

Getting started now

Contact us if you want to learn more about our partners

DB/IQ QA ensures quality, maintainability and performance for all Db2® for z/OS® applications

Features extract

  • More than 350 quality rules checked automatically
  • Issues alerts when SQL statements violate critical rules
  • Provides batch mode, ISPF interface and Eclipse Plugin for developers
  • Shares quality requirements and Best Practices

Benefits

  • Eradicates poor performing SQL code
  • Enforces quality rules and guidelines for Db2 applications
  • Improves maintainability of applications
  • Avoids performance problems
  • Checks 100% of the code delivered into production
  • Detects and fixes defects early, from the development phase

Mainframe Software