Monitoring data tables

CICS® produces statistics information to help you monitor the activity on your data tables. You can use the information contained in a CICS statistics report to evaluate the benefits of using data table services.

The information that is recorded for a data table under “Data Table Requests Information” is shown in Table 1.

Table 1. Data table statistics
Heading Description
Close Type Type of data table close (only appears in the statistics collected when a data table is closed).
Read Requests Number of attempts to read records from the data table or, in the AOR statistics, the number of read requests that had to be function shipped.
Recs ¬ in Table Number of attempts to read records from a source data set because the record was not found in the data table. (For a user-maintained data table, this happens only during loading.)
Adds from Reads Number of attempts to copy records from a source data set to the data table during loading process (including read requests from applications during loading).
Add Requests Number of attempts to write records to the data table.
Adds rejected - Exit Number of records suppressed by XDTRD and XDTAD user exits.

Adds rejected -
   Table Full

Number of records that were not included because the table was full.
Rewrite Requests Number of attempts to rewrite records in the data table.
Delete Requests Number of attempts to delete records from the data table.
Highest Table Size Peak number of records held in the data table.
Storage Alloc(K) Number of KB allocated to the data table.
The statistics for data tables are included in the FILES section of the statistics report. Four sections of FILE information are produced:
  • The “FILES - Resource Information” shows information such as the filename, source data set name, data set type (which is always K for a data table, because the source must be a VSAM KSDS) and a DT indicator that is explained below.
  • The “FILES - Requests Information” shows the statistics for accesses to the source data set. For a loaded user-maintained data table, this contains only zeros.
  • The “FILES - Data Table Requests Information” shows statistics for accesses to the data table. The meanings of the column headings are given in Table 1.
  • The “FILES - Performance Information” shows the use of VSAM strings and buffers, and is only of interest for a data table in that it relates to the source data set.

A request to a data table that is owned by another region is recorded in the statistics report for both the requesting and file-owning regions.

The DT Indicator is a single character that can have the values:
T
The statistics report contains data table information because the file has been opened as a data table.
R
The statistics report contains information for a remote file that has accessed a data table via shared data tables cross-memory services.
S
The statistics report contains data table information for the accesses made by this file to an associated data table (that has the same source data set).
X
The statistics report contains information for an alternate index file, and reports data table information for the update of the data table associated with a file in the same upgrade set.
The field is blank if data table statistics are not present for the file.
The Close Type is a single character that appears in the statistics only for the closing of a data table. The possible values indicate the type of close:
C
Close of a CICS-maintained data table.
P
Partial close of a CICS-maintained data table. There are still other files using the data table, so the data table itself has not been closed, only the file.
S
Close of the source data set for a user-maintained data table. This happens at the end of the loading of the data table.
U
Close of a user-maintained data table.

A total value for the storage allocated is not included in the TOTALS line.

Statistics utility program (DFHSTUP) tells you how to obtain a statistics report using the statistics utility program DFHSTUP.

Introduction to CICS statistics describes the data contained in a statistics report.



dfhf10r.html | Timestamp icon Last updated: Sunday, 4 June 2017