DB/IQ
Ensure the Quality and Performance of SQL Db2 Applications
DB/IQ is a set of solutions to guarantee the quality and performance of your SQL queries, whether static or dynamic, while reducing the load on your z/OS environment.
Control, optimize, and monitor SQL performance
The DB/IQ suite includes the following modules: DB/IQ QA, QA+, PackMan, IA+, MA+, WL and the Eclipse plugin.
What DB/IQ helps you achieve
Check that SQL Db2 applications comply with quality standards, assess access path efficiency, determine the best indexing strategies, and control query execution — even dynamically.
Quality Assurance
The DB/IQ Quality Assurance solution analyses and checks the entire SQL code, whether it is in source form, DBRM resulting from the Db2 preprocessor, SQL based on the catalogue, or dynamically executed SQL.
Quality standards enforcement
Allows the quality of all SQL code to be verified according to the standards defined by the organisation.
Extensive rule library
Over 370 quality rules are available off the shelf and can be customised to your requirements and service level agreements.
Interactive analysis
Provides developers with interactive quality control and a comprehensive EXPLAIN feature for all SQL statements.
Program validation
Reports and possibly rejects programs that violate the quality rules.
The checks can be triggered on demand by developers, directly in their mainframe or Eclipse development environments, and automatically in batch mode during delivery procedures.
Optimisation of dynamic SQL queries
The DB/IQ QA+ solution analyses dynamic SQL queries in depth by evaluating their cost, joins, sorts, access paths, execution time, CPU usage and number of GETPAGEs.
It identifies the most resource-intensive queries in order to diagnose performance problems and monitors the SQL activity of critical applications in real time.
By measuring the evolution of query quality over a given period, it makes it possible to anticipate the impact of Db2 updates on execution paths. Thanks to an automatic comparison of performance between different versions of a query, DB/IQ QA+ guarantees continuous optimisation and increased application stability.
Learn more →
Additional DB/IQ modules
Complementary solutions covering package management, workload simulation, index optimization, and integrated Eclipse-based SQL quality control.
Application Package Management
DB/IQ PM simplifies static package management by identifying and deleting unused packages, then reorganising the Db2 catalogue for leaner and more efficient application management.
Learn more →Advanced data volume simulation
DB/IQ WorkLoad Detector anticipates application behaviour by simulating data volumes through RUNSTATS manipulation and helps reproduce production conditions in qualification and development environments.
Request demo →Advanced Index Optimisation
DB/IQ Index Administrator analyses SQL activity in depth to assess the relevance of existing indexes, recommend new key columns, and evaluate the impact of indexing choices on application performance.
Our solution in action →Eclipse plug-in for SQL development
DB/IQ QA-E is an Eclipse plug-in compatible with RDz® that provides interactive quality control, EXPLAIN functionality, and real-time access path analysis directly inside the IDE.
Request demo →Why organizations choose DB/IQ
DB/IQ helps teams secure SQL quality, anticipate performance risks, automate controls, and support developers and DBAs throughout the application lifecycle.