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.
db2top Performance Report
Up to now, we have been looking mostly at db2top as a tool for observing the behavior of your system in real-time, but background mode and recording and playback has shown us that db2top can produce and examine historical data as well. The db2top tool can also be used to perform an analysis on such [...]
db2top Display Settings
When a monitoring or reporting tool reaches a certain level of sophistication, it needs to be able to report on itself as well. The db2top tool has a large number of configurable options, so it is fortunate that there is a screen that lets us see the present value of each such option. In today’s [...]
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 presented for the majority of those screens in db2top that present their information in a table.
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 the order in which the data is presented on the criteria of your choice. In today’s post, we’ll see how.
db2top Filters
On a busy system, sometimes the amount of data returned by our monitoring tools can be overwhelming. Fortunately, db2top was designed with this in mind and has a very flexible and powerful feature for extracting the information critical to your decision-making from reams of monitoring data. This feature, called regular expressions, is the subject of [...]
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 [...]
db2top Skew Screen
In a DB2 for LUW database that makes use of the data partitioning feature available in the Infosphere Warehouse product, one of the new concerns a database administrator is faced with is skew among the partitions. Adding or removing partitions from a database introduces skew and requires a redistribution to ensure data is spread evenly [...]
db2top Bottlenecks Screen (Part 1)
A database workload performs at its best when resources are made available to it in all the right proportions. Having any one resource constrained too much and everything slows down. You can have more CPU cycles available than you’ll ever need, but if your IO subsystem can’t keep up with the work, it becomes a [...]
Categories
-
