Open/Close Statistics Detail

This panel provides detailed information about open and close data set activity occurring within the DB2 subsystem during a selected report interval.


________________ ZHOPD    VTM     O2       V540.#P SE12 11/06/13 11:59:56   2 
>       Help PF1      Back PF3      Up PF7      Down PF8                       
>                                                                              
>                   Enter a selection letter on the top line.                  
>                                                                              
> A-SUBSYSTEM SUPPORT      B-BIND              C-BUFFER POOL    D-GROUP BP     
> E-DISTRIBUTED DATABASE   F-EDM POOL          G-LOG MANAGER    *-OPEN/CLOSE   
> I-SQL/RID/PARALLEL/PROC  J-LOCK/CLAIM/DRAIN  K-GLOBAL LOCK    L-DB2 COMMANDS 
> M-THREAD HISTORY                                                             
===============================================================================
>                          OPEN/CLOSE STATISTICS DETAIL                        
 HOPD                                                                          
+ Collection Interval:   1 min                           Start:  11/06 11:47   
+ Report Interval:       1 min   Combine Level:  NONE      End:  11/06 11:48   
+                                                                              
+ Current Number Open Datasets                 =      246                      
+ High Water Mark Open Datasets                =      248                      
+ High Water Mark Not-in-use Datasets          =      242                      
+ Current Number Not-in-use Datasets           =       95                      
+                                                                              
+                                           INTERVAL  /MINUTE  /THREAD  /COMMIT
+                                           QUANTITY  (    1)  (    2)  (    7)
+                                           --------  -------  -------  -------
+ Not-in-use Datasets Requested                  746   746.00   373.00   106.57
+ Not-in-use Datasets Closed                       0      .00      .00      .00
+ Datasets Converted to Read-Only                  0      .00      .00      .00
===============================================================================

Navigation

For additional information about

related topics, select one of the options at the top of the panel.
other topics, use the PF keys.

Fields

Collection Interval

The time interval specified for the collection of near-term history data. This unit of time was specified when the Near-Term History Data Collector was started.

Start

The start time of the interval currently displayed.

Report Interval

This field determines the report interval. It is set on the Near-Term History Report Option panel.

Combine Level

This field reflects the selected combine level. If Combine Level is NONE, the report interval is the same as the collection interval. Possible values:

HOURLY: Data will be reported in hourly intervals.
NONE: Data will be reported in the time unit specified by the collection interval.

End

The end time of the interval currently displayed.

Current Number Open Datasets

A snapshot value of the current number of open database data sets.

High-water Mark Open Datasets

The maximum number of data sets open at any one time since Db2 was started.

High-water Mark Not-in-use Datasets

The maximum number of pagesets that are not in use but are not physically closed.

Current Number Not-in-use Datasets

The current number of open pagesets that are not in use but are not physically closed.

For each of the following fields, the following statistics are provided:

INTERVAL QUANTITY: The amount of activities that occur during the interval.
/MINUTE: Rate per minute. The number under /MINUTE (in parentheses) is the number of minutes in the interval.
/THREAD: Rate per thread. The number under /THREAD (in parentheses) is the number of Create Threads during the interval.
/COMMIT: Rate per Commit. The number under /COMMIT (in parentheses) is the number of Commit requests (including abort requests) during the interval.

Not-in-use Datasets Requested: Number of requests to open a data set that was on the Deferred Close queue. When this occurs, a physical data set Open is not necessary.
Not-in-use Datasets Closed: Number of not-in-use data sets that were closed because the total number of open data sets reached the Deferred Close threshold. The Deferred Close threshold is based on the smaller of the values of DSMAX or the MVS DD limit.
Datasets Converted to Read-Only: Number of infrequently updated data sets converted from a Read-Write to a Read-Only state (pseudo-close). The SYSLGRNG entry is closed at this time.