Popular Posts
For when a first initial is all you can remember
db2top: The Watch feature
For the second video in this video series, we have a demonstration of the db2top Watch feature. It demonstrates capturing a single application’s SQL, capturing complete database structures to a set of files, and capturing all the dynamic SQL in the cache: Watch “db2top: The Watch feature” directly on YouTube.
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 did its job and didn’t leave any database objects behind? Today, using a tool that comes with DB2, I’ll show [...]
db2top Watch
As we saw when we examined its background and collection modes, db2top is not just a tool for letting you observe a running system – it also lets you record activity for later analysis. Another way to record data for later is the db2top Watch feature, which lets you precisely specify which SQL statements you [...]
Categories
-
