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.
We will examine each row individually:
Row 1
| Column Name | Definition |
|---|---|
| Start Date | The date of the first connection to the database or when the activate database was issued. Blank if the database is not activated. db_conn_time |
| Start Time | The time of the first connection to the database or when the activate database was issued. Blank if the database is not activated. db_conn_time |
| Status | The current status of the database. Possible values are: "Inactive", "Active", "Quiesce Pending", "Quiesced", "Rollforward", and "Unknown [x]" where x is the API constant for the db_status monitor element. "Inactive" and "Active" are shown in a regular font and all others are shown in bold. |
| Shthres | The value of the instance-wide soft limit on the total amount of memory (in units of bytes, kilobytes, megabytes, etc.) consumed by private sorts at any given time across all partitions. sheapthres * num_nodes_in_db2_instance * 4096 |
| Buffers | The pool_cur_size (in units of kilobytes, megabytes, etc.) of the buffer pool heap memory pool. |
| FCMBuf | The pool_cur_size (in units of kilobytes, megabytes, etc.) of the FCMBP heap memory pool. |
| OtherMem | The sum of the pool_cur_size (in units of kilobytes, megabytes, etc.) of all other memory pools except the buffer pool heap and FCMBP heap memory pools. |
Row 2
| Column Name | Definition |
|---|---|
| Sessions | The current number of connections. local_cons + rem_cons_in |
| ActSess | The current number of connections with executing work. local_cons_in_exec + rem_cons_in_exec |
| LockUsed | One hundred times the number of locks held per byte allocated to the lock list. 100 * locks_held / (locklist * 4096) |
| LockEscals | The number of times that locks have been escalated from several row locks to a table lock. lock_escals |
| Deadlocks | The total number of deadlocks that have occurred. |
| LogReads |
|
| LogWrites |
|
Row 3
| Column Name | Definition |
|---|---|
| L_Reads |
|
| P_Reads |
|
| HitRatio |
|
| A_Reads |
|
| Writes |
|
| A_Writes |
|
| Lock Wait | The number of agents waiting on a lock (locks_waiting). Shown in reverse text and blinking whenever it is greater than zero. |
Row 4
| Column Name | Definition |
|---|---|
| Sortheap | The total sort memory (both shared and private) measured in units of bytes, kilobytes, megabytes, etc. sort_heap_allocated + sort_shrheap_allocated |
| SortOvf |
|
| PctSortOvf |
|
| AvgPRdTime |
|
| AvgDRdTime |
|
| AvgPWrTime |
|
| AvgDWrTime |
|
The database screen is affected by typing the ‘k’ key to switch between deltas and actuals. It is also affected by the ‘G’ key switching between local and global snapshots. It is not affected by the ‘X’ key toggling extended mode on and off.
Popularity: 27% [?]
Subscribe by RSS!
Related posts:
- db2top Database Screen (Part 1) The first major screen of db2top that we will...
- db2top Feature of the Day – Gauges Before we can examine the various interactive screens of...
- db2top Feature of the Day – .db2toprc The db2top tool is very configurable. It would be inconvenient...
- db2top -k Some of the information that db2top reports are statistics measured...
- db2top Feature of the Day – Command Line Options (Summary) Now that we have reviewed each command line option individually,...
Related posts brought to you by Yet Another Related Posts Plugin.
