Data Tables reports
The Data Tables Requests and Data Tables Storage reports are produced using a combination of the EXEC CICS INQUIRE FILE and EXEC CICS EXTRACT STATISTICS FILE commands. The statistics data is mapped by the DFHA17DS DSECT.
| Field Heading | Description |
|---|---|
| Filename | The name of the file. Source field: EXEC CICS INQUIRE FILE() |
| Successful Reads | The number of attempts to retrieve
records from the table. Source field: A17DTRDS |
| Records Not Found | The number of times API READ requests
were directed to the source data set because the record was not found
in the table. Source field: A17DTRNF |
| Adds via Read | The number of records placed in the
table by the loading process or as a result of API READ requests issued
while loading was in progress. Source field: A17DTAVR |
| Adds via API | The number of attempts to add records
to the table as a result of WRITE requests. Source field: A17DTADS |
| Adds Rejected | The number of records CICS® attempted to add to the table which were
rejected by the global user exit. Source field: A17DTARJ |
| Adds Full | The number of records CICS attempted to add to the table but was unable
to do so because the table already contained the maximum number of
records specified. Source field: A17DTATF |
| Rewrite Requests | The number of attempts to update
records in the table as a result of REWRITE requests. Source field: A17DTRWS |
| Delete Requests | The number of attempts to delete
records from the table as a result of DELETE requests. Source field: A17DTDLS |
| Read Retries | The total number of read retries,
that is the number of times reads in an AOR had to be retried because
the FOR changed the table during the read. Source field: A17DTRRS |
| Chng Resp/Lock Waits | For a CFDT that is using the locking
model, records are locked when they are read for update.
This count is the number of times it was necessary to
WAIT for an already locked record.
For a CFDT that is using the contention
model, records are not locked when they are read for update. If a
subsequent rewrite or delete request finds that the record
has already changed a CHANGED response is returned. This
count is the number of times that a CHANGED response was issued.
Source field: A17DTCON |
| Field Heading | Description |
|---|---|
| Filename | The name of the file. Source field: EXEC CICS INQUIRE FILE() |
| Type | The type of data table, coupling
facility, CICS-maintained or user-maintained. Source field: EXEC CICS INQUIRE FILE() TABLE(cvda) |
| Current Records | The current number of records in
the data table. Source field: A17DTSIZ |
| Peak Records | The peak number of records in the
data table. Source field: A17DTSHI |
| Total - Storage Allocated | The total amount of storage (kilobytes)
in allocated for the data table. Source field: A17DTALT |
| Total - Storage In-Use | The total amount of storage (kilobytes)
in use for the data table. Source field: A17DTUST |
| Entries - Storage Allocated | The total amount of storage (kilobytes)
allocated for the record entry blocks. Source field: A17DTALE |
| Entries - Storage In-Use | The total amount of storage (kilobytes)
in use for the record entry blocks. Source field: A17DTUSE |
| Index - Storage Allocated | The total amount of storage (kilobytes)
allocated for the index. Source field: A17DTALI |
| Index - Storage In-Use | The total amount of storage (kilobytes)
in use for the index. Source field: A17DTUSI |
| Data - Storage Allocated | The total amount of storage (kilobytes)
allocated for the record data. Source field: A17DTALD |
| Data - Storage In-Use | The total amount of storage (kilobytes)
in use for the record data. Source field: A17DTUSD |
| Totals | Final total of the storage allocation for each storage column, for all the Data Tables listed in the report. |