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.
| 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 - |
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 “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.
- 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.
- 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.