SQLQC / Efficient SQL Tuning of Large Workloads

SQLQC analyzes the current Db2 workload and offers suggestions for improvement

Increasingly complex workloads require new methods for SQL quality control and performance tuning. Numerous different SQL statements are continuously being funneled through the systems. This makes it difficult to decide which SQL statements have potential for optimization and if the use of resources is justified. SQLQC stands for SQL Quality Control and is designed to address these new challenges.

  • Analyze the behavior of SQL over time (CPU, elapsed time, IO,…)

  • Overview of all executed SQL over a given period of time

  • Recognition of SQL access path changes over several months
  • Class 3 (wait times) are monitored for each SQL

  • Cost-effective data pooling without traces