Database Activity

This panel shows activity information about spaces that have incurred Getpage or I/O activity during the current collection interval. This panel formats Getpage and I/O activity for spaces owned by a single database.


________________ ZOJO1    VTM     O2       V540.#P SE12 11/05/13 17:55:13   2 
> Help PF1      Back PF3      Up PF7      Down PF8     Sort PF10     Zoom PF11 
>                                                                              
>       OBJECT ANALYSIS:  Enter a selection letter on the top line.            
>                                                                              
> A-DATABASE ALLOCS  *-DATABASE ACTIVITY   C-THREAD ACTIVITY  D-DISPLAY OPTIONS
===============================================================================
>                             DATABASE ACTIVITY                                
 OJO1                                                                          
+ Interval Time   = 00:15:00                       Interval Elapsed = 00:12:20 
+ Total Getpage   =        6                       Total I/O        =        6 
+                                                                              
+ Database = DSNDB01                                                           
+ *                                                                            
+           % of    % of   Getp                Sync     Pre      Async    Other
+ Spacenam  Getp    I/O    per RIO    Getpage  Read     Fetch    Write    Write
+ --------  ------  ------ ---------  -------  -------  -------  -------  -----
+ DSNLLX01   66.6%   83.3%         0        4        5        0        0      0
+ SYSLGRNX   33.3%   16.6%         2        2        1        0        0      0
===============================================================================

If you move the cursor to any entry in a column and press F10, OMEGAMON® XE for Db2 PE will sort on that column.

Navigation

For additional information about

a particular space, move the cursor to the spacename line and press F11 (Zoom). For more information, see the description of panel Spacename Activity.
related thread activity, select option C-Thread Activity. For more information, see the description of panel Thread Activity by Database.
related display options, select option D-Display Options. For more information, see the description of panel Display Options For Database Allocations And Database Activity Displays.
related topics, select one of the options on the top of the panel.
other topics, use the PF keys.

Fields

Interval Time: The collection interval currently in use by the object analysis collector. At the end of this time interval, the collector resets its collection statistics.
Interval Elapsed: The elapsed time within the current collection interval. It is the period of time for which the displayed information is applicable.
Total Getpage: The total number of Getpage requests since the beginning of the collection interval.
Total I/O: The total number of I/O requests since the beginning of the collection interval.
Database: The name of the database that owns the spacenames in the display.
Spacenam: The name of a space that has incurred Getpage/IO activity.
% of Getp: The percentage of total Getpage activity that is applicable to the spacename.
% of I/O: The percentage of total I/O activity that is applicable to the spacename.
Getp per RIO: The Getpage to Read I/O ratio for the spacename. This ratio is computed by dividing Getpage by Sync Read + Pre Fetch.
Getpage: The number of Getpage requests for the spacename.
Sync Read: The number of synchronous Reads for the spacename.
Pre Fetch: The number of prefetch Read I/Os for the spacename.
Async Write: The number of asynchronous Writes for the spacename.
Other Write: The number of immediate and format Writes for the spacename.