DB/IQ
Ensure the Quality and Performance of SQL Db2 Applications
DB/IQ is a set of solutions ensuring the quality and performance of your SQL queries, whether static or dynamic, while reducing the load on your z/OS environment. Integrated into DevOps workflows, it helps teams detect and prevent SQL issues early in development.
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.
DB/IQ QA — Quality Assurance
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.
Allows the quality of all SQL code to be verified according to the standards defined by the organisation.
Over 370 quality rules available off the shelf, customisable to your requirements and service level agreements.
Provides developers with interactive quality control and a comprehensive EXPLAIN feature for all SQL statements.
Reports and possibly rejects programs that violate the quality rules.
DB/IQ QA+ — Optimisation of dynamic SQL queries
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 help stabilize the consumption of dynamic queries and keep their execution within acceptable performance thresholds — preventing unexpected resource spikes in production.
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 moreAdditional DB/IQ modules
Complementary solutions covering package management, workload simulation, index optimization, integrated IDE tooling, and open integration via REST API.
Application Package Management
DB/IQ PM simplifies package management by identifying and deleting unused packages, then reorganising the Db2 catalogue for more efficient application management.
Learn moreAdvanced workload analysis
DB/IQ WL helps DBAs analyze, diagnose, and resolve performance issues that arise during program execution. By providing detailed workload insights and execution-level visibility, it makes it easier to identify the root causes of slowdowns and take corrective actions to improve overall application performance.
Request demoAdvanced Index Optimisation
IA+ performs in-depth SQL activity analysis to identify underused indexes, detect duplicate indexes, and assess the relevance of existing ones. Based on the insights collected, it can also recommend new indexes and key columns, while evaluating the impact of indexing decisions on application performance.
Our solution in actionEclipse 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 within the IDE. It helps developers identify performance issues early and optimize SQL from the development phase onward, reducing rework and improving application performance before deployment.
Request demoVS Code extension for SQL quality
The DB/IQ extension for Visual Studio Code brings SQL quality control directly into the modern developer's IDE. It provides real-time linting against your organization's rule set and inline EXPLAIN results without leaving the editor.
Request demoOpen integration via REST API
The DB/IQ REST API enables seamless integration of SQL quality controls into any CI/CD pipeline, custom toolchain, or third-party platform. Teams can programmatically trigger quality checks, retrieve rule violations, and access EXPLAIN results making DB/IQ a native part of automated delivery workflows.
Request demoWhy 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.
Ready to secure the quality of your Db2 SQL applications?
Join the teams relying on DB/IQ to prevent issues, optimize performance, and enforce standards.
Request a demo