DB/IQ WorkLoad Detector for Db2® Applications

Identify which SQL is responsible for heavy workloads to uncover performance issues

With the explosion of packaged solutions such as ERP systems and their many thousands of tables exploited by dynamic and costly SQL, the ability of performance specialists to effectively tune applications has become a major challenge.

woman who sorts a lot of files

DB/IQ WorkLoad Detector identifies which packages and SQL are responsible for heavy workloads. It helps DBAs and developers analyze all SQL activities to reveal the most frequently executed and most costly applications (CPU and elapsed time, SQL costs). By focusing on high-consumption SQL with significant performance impact, it helps tune the SQL, leading to a reduction in workload and improved application performance.

  • Detects top resource crunchers by analyzing entire applications and identifying heavy workload
  • Captures trace for all static and dynamic SQL, regardless of origin
  • Extra “lite” Db2 trace to locate “n” resources at various levels ranging from THREAT, PACKAGE or accumulated PACKAGE summaries down to single SQL statements.
watering can watering a plant in the shape of rising arrow



Quality Assurance for Db2 Applications