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.
The database screen differs from the majority of screens in db2top in that it only ever has one object to show – the database itself. It takes advantage of this by showing every column at once and not requiring you to scroll to see more. The top half of the screen consists of a set of four gauges when the screen is between 80 and 140 columns wide:
| Gauge Name | Gauge Type | Definition |
|---|---|---|
| MaxActSess | Normal | The current number of connections with executing work in proportion to the highest number of connections simultaneously executing work.
(local_cons_in_exec + rem_cons_in_exec) / coord_agents_top | SortMemory | Normal | The total sort memory (both shared and private) in proportion to the sort memory threshold configured for the database manager.
(sort_heap_allocated + sort_shrheap_allocated) / sheapthres |
| LogUsed | Normal | The proportion of total log space that is consumed by uncommitted transactions.
total_log_used / (total_log_available + total_log_used) |
| FCM BufLow | Normal | (buff_free - buff_free_bottom) / buff_free_bottom |
A fifth gauge, AssAgents, is added between MaxActSess and SortMemory when the screen is wider than 140 columns:
| Gauge Name | Gauge Type | Definition |
|---|---|---|
| AssAgents | Normal | The proportion of registered database agents that are not idle. 1 - (idle_agents / agents_registered) |
Section of db2top database screen showing five gauges
The second change that happens when the screen width is 141 columns or wider is that, if you have taken a backup of the database, you will see three rows of backup information to the right of the gauges, as shown below:
db2top Database screen at 141 columns wide
The three new rows are as follows:
- Last backup date
- Last backup time
- Log retain
The bottom half of the screen consists of four rows of seven columns each. Each column has a title with a corresponding value beneath it. In the next post, we will examine each of the four rows of data.
Popularity: 20% [?]
Subscribe by RSS!
Related posts:
- db2top Feature of the Day – Gauges Before we can examine the various interactive screens of...
- db2top -x The db2top tool supports an extended mode in which it...
- db2top -C and db2top -f The final two command line options, -C and -f, work...
- db2top -R Today’s command line option is -R. In this post, we...
- db2top -b The -b option allows you to run db2top in “background...
Related posts brought to you by Yet Another Related Posts Plugin.
