Files: Resource statistics - data table requests information

If the file is a data table, further fields are present in the statistics record.

The presence of these additional fields is indicated by the value “R”, or “S”, or “T”, or “L”, or “K”, or “X” in the field A17DT. Their names and meanings are as follows:

Table 1. Files: Resource statistics - data table requests information
DFHSTUP name	Field name	Description
File Name	A17FNAM	The name you specified in the DEFINE FILE command of resource definition online. Reset characteristic: not reset
Close type	A17DTTYP	This 1 byte field is set to: “C” when a CICS® maintained table is closed “P” when a file which has been accessing a CICS-maintained table is closed but the table remains open because there are other files still open which are using the table “S” when the source data set for a user-maintained table is being closed “U” when a user maintained table is closed “L” when a locking model coupling facility data table is closed “K” when a contention model coupling facility data table is closed. Reset characteristic: not reset
Read requests	A17DTRDS	The number of attempts to retrieve records from the table. Reset characteristic: reset to zero
Recs¬[not] in table	A17DTRNF	The number of reads where the record was not found in the data table, so CICS retrieved the record from the source file. Reset characteristic: reset to zero
Adds from reads	A17DTAVR	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. Reset characteristic: reset to zero
Add requests	A17DTADS	The number of attempts to add records to the table as a result of WRITE requests. Reset characteristic: reset to zero
Adds rejected – exit	A17DTARJ	The number of records CICS attempted to add to the table which were rejected by the global user exit. Reset characteristic: reset to zero
Adds rejected – table full	A17DTATF	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. Reset characteristic: reset to zero
Rewrite requests	A17DTRWS	The number of attempts to update records in the table as a result of REWRITE requests. Reset characteristic: reset to zero
Delete requests	A17DTDLS	The number of attempts to delete records from the table as a result of DELETE requests. Reset characteristic: reset to zero
Highest table size	A17DTSHI	The peak number of records present in the table. Reset characteristic: reset at close
Storage alloc(K)	A17DTALT	The total amount of storage allocated to the data table. The DFHSTUP report expresses the storage in KB. DFHSTUP does not total the storage allocated for all data tables because multiple files can share the same data table. Reset characteristic: not reset
Chng Resp/Lock Waits	A17DTCON	For a CFDT that is using the locking model, records are locked down 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. Reset characteristic: reset to zero
NOT IN THE DFHSTUP REPORT	A17DTLDS	The number of times that a LOADING response was issued. When a CFDT is in the process of being loaded, and requests issued for records beyond the range of those already loaded get a LOADING response. Reset characteristic. reset to zero
Note: The request information statistics output for a data table represents the activity of the source data set, and the data table request information represents the activity of the data table. Thus, for a CICS-maintained table, you would expect to find similar counts in both sections of the statistics output for requests which modify the table, because both the source data set and the table must be updated. For a user-maintained table, updating activity is not shown in the data table resource information.

When using the shared data tables feature the statistics records contain the additional information as follows:

Table 2. Files: shared data table statistics
DFHSTUP name	Field name	Description
NOT IN THE DFHSTUP REPORT	A17DTSIZ	The current number of records in the data table. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTUST	The total amount of storage (KB) in use for the data table. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTALE	The total amount of storage (KB) allocated for the record entry blocks. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTUSE	The total amount of storage (KB) in use for the record entry blocks. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTALI	The total amount of storage (KB) allocated for the index. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTUSI	The total amount of storage (KB) in use for the index. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTALD	The total amount of storage (KB) allocated for the record data. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTUSD	The total amount of storage (KB) in use for the record data. Reset characteristic: not reset
NOT IN THE DFHSTUP REPORT	A17DTRRS	The total number of read retries, that is the number of times reads in an AOR must be retried because the FOR changed the table during the read. A17DTRRS is not a count of accesses which failed because a file owning region (FOR) was updating the specific record that the AOR wanted to read. In such cases, the request is function shipped and is counted in the source reads. Reset characteristic: not reset
Not in DFHSTUP report	A17_FILE_DEFINE_SOURCE	The name of the CSD group that contains to this resource. Reset characteristic: not reset
Not in DFHSTUP report	A17_FILE_CHANGE_TIME	The time stamp (STCK) in local time of CSD record change. Reset characteristic: not reset
Not in DFHSTUP report	A17_FILE_CHANGE_USERID	The user ID that ran the change agent. Reset characteristic: not reset
Not in DFHSTUP report	A17_FILE_CHANGE_AGENT	The agent that made the last change. Reset characteristic: not reset
Not in DFHSTUP report	A17_FILE_INSTALL_AGENT	The agent that installed the resource. Reset characteristic: not reset
Not in DFHSTUP report	A17_FILE_INSTALL_TIME	The time stamp (STCK) in local time when the resource was installed. Reset characteristic: not reset
Not in DFHSTUP report	A17_FILE_INSTALL_USERID	The user ID that installed the resource. Reset characteristic: not reset
Note: Data table fields are present in the statistics records but contain zeros if shared data tables are not installed or the resource is not a data table.