DB2 Top 10 SQL by Number of Executions

How to obtain the top 10 SQL sorted by number of executions on your database?

Tuning DB2: Snapshots

To tuning a database is useful to create snapshots that capture information from different structures/components of the instance. In this post we show how they can be used to perform an analysis of tuning. First of all, the monitor switches must be on to collect data from the different structures.

Cache Hit Ratio DB2

The cache hit ratio is one of the indicators used for tuning tasks. It Measures the percentage of hits in memory, specifically in the bufferpools (each of them).

Avg Disk Access read/write in DB2

Through DB2 we can get the average time in ms disk access is having DB2. These times are crucial for the detection of a IO problem with DB2 instance.