DBIQ Reviews & Product Details

DB/IQ is a software solution designed to assess and improve the level of quality and maintainability of Db2 for z/OS applications before they get deployed in your production environment. DB/IQ automates the quality control process according to performance, maintainability, and scalability criteria. DB/IQ analyzes and performs checks on all SQL code; whether in source form, in a DBRM resulting from the Db2 pre-processor, in all Catalog-based SQL (plans, packages, views, MQTs, triggers etc.), or as dynamically executed SQL. • Check the quality of any SQL code according to organization-defined standards • More than 350 quality rules are available “out-of-the-box” and can be customized according to your requirements and SLAs • Provide developers interactive quality control and full EXPLAIN functionality for all SQL statements • Alert and possibly reject programs that violate quality rules Controls can be triggered on demand by developers, directly in their mainframe or Eclipse development environments, and automatically in batch mode during delivery procedures