News

Laborious assessment of z/OS Db2 compression

22 October 2018

Db2 compression is useful and can bring performance benefits :

  • Higher buffer pool hit ratios
  • Fewer I/Os
  • Fewer getpage operations

To decide to compress data, you should consider many factors : data row size, tablespace size, data patterns ...

Of course, the DSN1COMP utility is available but how much time would it require to customize it for a subset of the objects of your configuration ?

We show you here how Click4DB could quickly help you …

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

 

Pages