Dynamic Statement Cache optimization with Click4DB

31 January 2018

Optimizing the Dynamic statement cache is like other DBMS management tasks : it is not complicated but it requires a series of steps that are time consuming :

  1. Show cache usage repartition by application
  2. Show cache usage repartition by programs
  3. For each candidate program :
    • Analyze the DSC to avoid statement with LIKE
    • Analyze the DSC to avoid statement using INDEX ON EXPRESSION
  4. Show a repartition that simulates the usage after implementation
  5. Show the CPU impact of the CONCENTRATE option on a specific program

​See how Click4DB automates this process ...


DB2 Virtual Indexes - How Click4DB can automate the process ?

19 July 2017

Performance problems often lead to the need of new indexes.

Virtual index is a nice way to “give a new index a try” before you create it.  But depending on the candidate columns, it would be a huge work to create and find the best index among all potential candidates (a 5 columns INDEX can lead to 325 fields combinations)

See how Click4DB assist you to reduce this kind of task to one click ...