For when a first initial is all you can remember
Tweet Today’s video is a comparison between the output of the db2mtrk command and the db2top Memory screen. It covers current allocations, high watermarks, and maximum allocations for the instance, database, and application groups of memory pools as well as the repeat mode of db2mtrk. Watch “db2top: Memory screen and db2mtrk” directly on YouTube.
Tweet Today’s video is a demonstration of buffer pool hit ratio in the Bufferpools screen of db2top. To produce a hit ratio of 100%, we query a single row repeatedly to perform logical reads with no corresponding physical reads. To reduce the hit ratio, we query more data than can fit in the buffer pool, [...]
Tweet Today’s video is a demonstration of the regular expressions (regex) feature of db2top. In the video, I apply regular expressions to the Dynamic SQL screen to filter what SQL statements are shown. I demonstrate setting and clearing a regex, simple regular expressions, and POSIX extended regular expression metacharacters: Watch “db2top: Regular expressions” directly on [...]
Tweet Today’s video is a demonstration of the Locks screen of db2top. In the video, I create a lock chain and launch db2top to examine the Application Status, Object Name, Locked By and Lock Count columns for three applications involved in the chain. I then use the Lock Chain screen to visualize the chain: Watch [...]
Tweet 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.
Tweet Over the next few db2top-related blog posts, I am planning to post some videos that demonstrate some of the features I wrote about in earlier posts. First up is the Change Columns Order screen and a video to demonstrate how to change the column order and keep it changed for the next time you [...]
Tweet 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 [...]
Tweet 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 [...]
Tweet The db2top tool, on each of its various screens, presents a subset of the full capabilities of the DB2 snapshot monitor. In this post, we’ll see how you can use the native snapshot feature to gain access to the full snapshot.
Tweet 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.