db2top Dynamic SQL Screen

The first time I used db2top’s Dynamic SQL screen, I tried the ‘X’ key to switch to extended mode and had no idea what I had just done. Everything was reordered, hash values seemed to […]

db2top Tables Screen (Part 2)

In the first post about the Tables screen, we examined the data that is available on small screens between 80 and 140 columns wide. In today’s post, you will learn about the gauge and aggregates […]

db2top Tables Screen (Part 1)

Have you ever wanted to see a (near) real-time view of how much data is being read from or written to your tables? How about your temporary tables? The db2top Tables screen does all of […]

db2top Bufferpools Screen (Part 2)

In the first post on db2top’s Bufferpools screen, we saw aggregates across all of the buffer pools in the database. In this second part, you will see what db2top reports for individual buffer pools. For […]