db2top Change Columns Order

What good is a tool if you can’t customize it to your liking? Fortunately, db2top is quite customizable. In today’s post, we will look at how you can customize the order in which columns are […]

Histograms

In Curt Cotner’s recent blog post, What’s new in statement-level performance metrics, he wrote about the popularity among customers of Optim Performance Manager (OPM)’s ability to create and visualize histograms of statement costs. In this […]

db2top Sort

The db2top tool is all about showing the top sessions, bufferpools, tablespaces, etc. by some criteria. It wouldn’t be very useful if it didn’t let you choose these criteria. Fortunately, db2top lets you quickly base […]

Do your uninstall scripts leave something behind?

Have you ever needed to write a pair of scripts: one to create some tables, data types, or user-defined functions and a second to uninstall the same? How do you test that the uninstall script […]