In the previous post on the Sessions screen, we looked at the gauges and table columns that make up the default screen. In today’s post, we will examine all the extra information that becomes available on larger screens.
Such additional large-screen information includes several aggregates. You can use these aggregates to look across all sessions and answer many kinds of questions:
- How many sessions are local? How many are remote? How many of each are active versus idle?
- How much dynamic SQL is being submitted? How much static SQL?
- How active are the buffer pools across all sessions?
- How many reads and writes are not using a bufferpool?
- Is my sort heap high watermark exceeding my sort heap threshold?
- Is my sort heap so small that it is hurting my sorts and my hash joins?
- How many utilities are active at this time?
- How much inter-node traffic is there on my Data Partitioning Feature (DPF)-enabled system?
- Many more…
Continue reading db2top Sessions Screen (Part 2)
Popularity: 100% [?]
Today we will take our first detailed look at the Sessions screen. The sessions screen lets you view applications connected to the database and see what they’re doing and how many resources they are consuming.
Continue reading db2top Sessions Screen (Part 1)
Popularity: unranked [?]
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)
Popularity: 45% [?]
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)
Popularity: 18% [?]
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
Popularity: 20% [?]
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
Popularity: 29% [?]
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.
Popularity: 36% [?]
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)
Popularity: 18% [?]
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)
Popularity: 11% [?]
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)
Popularity: 15% [?]
