SQL statements generation : keep it easy !

15 June 2018

Who never faced the challenge to generate SQL statements and/or commands dynamically based on some conditions ? GRANT, REVOKE, SELECT, REBIND, ALTER ...

Skilled in DB2TEP and REXX and JCL ? Otherwise, it could rapidly become a headache ...

Our Click4DB concept integrates this naturally : collect data based on any conditions, generate queries and/or commands with the results. Any output from the server can be manipulated and serves as input to a next action.

Let's compare the required tasks between a "classic DB2TEP/REXX/JCL" approach and Click4DB ...

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 ...