SQL Quality Assurance


SQL Quality Assurance

If you develop DB2 applications you know that performance and quality must be built in your SQL from the start of the application cycle. The cost of SQL performance and quality issues may run into hundreds of thousands of dollars or more if allowed to make their way into your production systems undetected.

CDB Software, Inc. has partnered with Insoft Software GmbH to give you the tools you need to manage the performance and quality of your DB2 SQL throughout the application development cycle.

DB/IQ QA - Quality Assurance

analyzes, explains 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.

DB/IQ QA+ - Quality Assurance Plus

monitors, explains and alerts upon all dynamic SQL executed in your z/OS DB2 systems; whether local, remote or as a connected client, for example Java.

DB/IQ IA+ Index Administrator

one of the most important factors in DB2 application performance is the index design. Poor index usage can ruin the application's performance. Deciding which columns need indexing, and the order of concatenated keys is a difficult task for the DBA - solve many of these problems with IA.

DB/IQ WL+ WorkLoad Detector

an "add on" to the DB/IQ QA product, helps DBAs and developers analyze complete applications and reduce their workload. This form of application tuning enhances the QA base product by processing captured trace data.

DB/IQ PM - PackMan

solves the problems of LOADLIB / DBRM and DB2 Package Management and ensures System Integrity. Accomplished by checking the consistency of executable load modules and / or DBRMs and bound packages within the DB2 Catalog.

DB/IQ MA – Migration Aid

An "add on" to the DB/IQ QA product, provides fast and easy solutions to assist application development and database administration. The utilities help you utilize resources more economically and benefit your organization


  • PRESS
  • BECOMING A PARTNER
  • SUCCESS STORIES
  • UNIQUE TECHNOLOGIES
  • WHY CDB?
  • VALUE-BASED PRICING

CDB Software:The Industry's Leading Authority on z/Series DB2 Data Management

CDB Software is a leading authority on z/Series DB2 environments and how they can be optimized to meet the changing demands of business. From the critical every-day processes of database performance and protection to the implementation of new requirements for security and compliance, CDB Software is the visionary leader for enterprise DB2 environments that want both flexibility and control.

For more information or to schedule a briefing with a CDB expert, contact CDB Press and Analyst Relations .

Press Releases      |      White Papers &Articles     |     Press Contacts     |     About CDB

Insoft Software

Solutions Quality Assurance ••• Datasheet Quality Assurance Plus ••• Datasheet Index Administrator ••• Datasheet WorkLoad Detector ••• Datasheet PackMan ••• Datasheet Migration Aid ••• Datasheet