Open/Close Activity

This topic shows detailed information about "Statistics - Open/Close Activity".

Statistics - Open/Close Activity

The field labels shown in the following sample layout of "Statistics - Open/Close Activity" are described in the following section.

OPEN/CLOSE ACTIVITY          QUANTITY  /SECOND  /THREAD  /COMMIT
---------------------------  --------  -------  -------  -------
OPEN DATASETS - HWM             79.00      N/A      N/A      N/A
OPEN DATASETS                   64.34      N/A      N/A      N/A
DS NOT IN USE,NOT CLOSE-HWM     79.00      N/A      N/A      N/A
DS NOT IN USE,NOT CLOSED        55.43      N/A      N/A      N/A
IN USE DATA SETS                 8.91      N/A      N/A      N/A

DSETS CLOSED-THRESH.REACHED      0.00     0.00      N/C     0.00

DSETS CONVERTED R/W -> R/O       7.00     0.04      N/C     0.21

OPEN DATASETS - HWM

The maximum number of data sets concurrently open since the last time DB2 was started. This is a high-water mark (HWM).

Background and Tuning Information

Monitor this field to see whether you are reaching the maximum number of open data sets permissible.

Note:

The maximum number of open data sets is 200,000. The default is 20,000. End of change

Field Name: QTMAXDS

This is an exception field.

OPEN DATASETS

The number of data sets concurrently open (snapshot).

Field Name: QTDSOPN

DS NOT IN USE,NOT CLOSE-HWM

The maximum number of data sets on the deferred close queue. It is a high-water mark representing the maximum number of data sets that are not in use but have not been physically closed yet.

Field Name: QTMAXPB

This is an exception field.

DS NOT IN USE,NOT CLOSED

The number of data sets that are not currently used, but are not closed due to a deferred close (snapshot).

Field Name: QTSLWDD

This is an exception field.

IN USE DATA SETS

The number of data sets currently in use (snapshot).

Field Name: SDINUSEC

This is an exception field.

DSETS CLOSED-THRESH.REACHED

The number of data sets that were closed because the total number of open data sets reached the deferred close threshold value. The deferred close value is based on the value of DSMAX or the MVS DD limit (whichever is smaller).

Field Name: QTDSDRN

This is an exception field.

DSETS CONVERTED R/W -> R/O

The number of infrequently updated data sets that are converted from R/W to R/O state. An updated data set is considered infrequently updated when it has not been updated for either 5 consecutive DB2 checkpoints or 60 minutes. For tablespace data sets, the switching from R/W to R/O state means the SYSLGRNG entry is closed.

Field Name: QTPCCT

This is an exception field.

Feedback