Twitter It!
In the first post of this series on the db2top Database screen, we took a look at the gauges that make up the top part of the screen and saw the additional data about backups that becomes available when the screen widened to 141 columns or wider. In this second post, we will examine the four rows of database-level information presented below the gauges, including information on memory usage, active and idle connections, locks, logs, buffer pools, and sorts. You will also see the impact of the delta and cumulative modes on some of these data. Continue reading db2top Database Screen (Part 2)
Twitter It!
The first major screen of db2top that we will examine is the Database screen. This screen gives you the big picture view of your database. You can use this screen to see how busy your database is in terms of the number of applications connected to it and issuing work, the amounts of memory being consumed for various purposes, such as sorts or the caching of reads and writes, the efficiency of I/O, and the impacts of contention, such as high lock wait times and lock escalations.
Continue reading db2top Database Screen (Part 1)
Twitter It!
Before we can examine the various interactive screens of data that make up db2top, we need to become familiar with one of the ways these data are presented – gauges. Continue reading db2top Feature of the Day – Gauges
Twitter It!The db2top tool is very configurable. It would be inconvenient to configure it to your liking only to lose your configuration when you shut down the tool, so an option is available for saving your configuration to a file. Today we will examine this configuration file and look at what kinds of tweaks you can make, including:
Continue reading db2top Feature of the Day – .db2toprc
Twitter It!Now that we have reviewed each command line option individually, I will use today’s post to put together a set of links of everything we covered:
The next post will cover the .db2toprc file.
Twitter It!The final two command line options, -C and -f, work together. The -C option tells db2top to run in data collector mode and -f lets you tell db2top where to write or read the results of such a collection. Continue reading db2top Feature of the Day – Command Line Options (-C and -f)
Twitter It!By default, db2top shows data aggregated from all partitions. In this post, I’ll show you how to use the -P option to override this behavior so that you can look at one partition at a time. Continue reading db2top Feature of the Day – Command Line Options (-P)
Twitter It!The db2top tool supports an extended mode in which it shows different information than it shows in the default mode. Today, we will see how the -x command line option can put you into extended mode and how that affects what information db2top displays. Continue reading db2top Feature of the Day – Command Line Options (-x)
Twitter It!Some of the information that db2top reports are statistics measured from the last reset of the snapshot. There is also a “delta” mode in which these same statistics are reset every second regardless of the refresh interval. This “delta” mode is the default mode that db2top runs in. Today, we will look at how the -k option lets you override this default. Continue reading db2top Feature of the Day – Command Line Options (-k)
Twitter It!Today’s command line option is -R. In this post, we will look at how you can use the -R option to perform a reset of the snapshot when db2top is started. Continue reading db2top Feature of the Day – Command Line Options (-R)
