SoftBase Systems, Inc.

CODE DB2 SQL FASTER & BETTER

Home > SoftBase SQL Coding Solution Overview

BUSINESS CHALLENGES:

DB2 Application Developers are faced with an increasingly daunting task to code complex SQL statements that perform well and properly access business data.

DB2 Data Administrators (DBAs) just cannot be everywhere to offer suggestions and advice on how to properly code these tough SQL statements. Also, DBAs often find it difficult to explain to Application Developers which of the wide variety of DB2 Optimizer Access Paths will best access their data.

DB/IQ-QA: EXPERT SQL ADVICE FOR DB2 DEVELOPERS

DB/IQ-QA dramatically reduces SQL coding times for DB2 Application Development Teams. By providing SQL automated coding assistance to Application Developers as they actually construct and enhance SQL statements, DB/IQ-QA enables IT staffs to deliver the highest quality and best performing DB2 production applications possible.

DB/IQ-QA's Expert Knowledgebase contains nearly 200 rules on how to properly code DB2 for z/OS SQL statements. DB2 DBAs can then customize this knowledgebase by:

Activating or deactivating desired DB/IQ-QA Expert SQL Rules
Assigning appropriate thresholds and severity codes to each rule
Altering verbage presented to Application Developers when problems are found in SQL statements
Adding their own rules for specific SQL problem areas in the shop

By deploying the DB/IQ-QA Expert SQL Rules, combined with your own DB2 DBAs' expertise, this unique solution will allow you to "clone" your best DB2 DBAs to be available to every single Application Developer when they need help the most!

Also, DB/IQ-QA can be added to your application versioning or change control processes to actually prevent bad SQL statements from every being moved into production again.

Finally, DB/IQ-QA is extremely valuable in identifying SQL problems in your existing DB2 production applications that require Application Developer and/or DBA attention..

Product Fact Sheet

Product Slide Show

Live Web Demo