Dynamic Statement Cache optimization with Click4DB

31 januari 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 juli 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 ...

Click4DB : how to validate and challenge you recovery strategy with only 3 clicks ?

09 februari 2017
Most of the sites are taking backups on a predefined frequency (daily , weekly, … ) to insure that all their data can be restored in case of problem.  Object’s life cycle is less often taken into account, while this could have a big impact to guaranty the SLA.  
Click4DB can instantly gives you a more detailed view on your backup process ...