Figure 119 shows the format of the Data Tables Requests Report. This report is produced using a combination of the EXEC CICS® INQUIRE FILE and EXEC CICS COLLECT STATISTICS FILE commands. The statistics data is mapped by the DFHA17DS DSECT. The field headings and contents are described in Table 243.
Applid IYK2Z1V3 Sysid CJB3 Jobname CI07CJB3 Date 12/17/2004 Time 08:44:37 CICS 6.4.0 PAGE 74
Data Tables - Requests
______________________
Successful Records Adds via Adds via Adds Adds Rewrite Delete Read Chng Resp/
Filename Reads Not Found Read API Rejected Full Requests Requests Retries Lock Waits
__________________________________________________________________________________________________________________________________
BRQFILE 0 0 0 0 0 0 0 0 0 0
F140BASE 0 0 0 0 0 0 0 0 0 0
F150BASE 0 0 0 0 0 0 0 0 0 0
F170BASE 0 0 0 0 0 0 0 0 0 0
F270BASE 0 0 0 0 0 0 0 0 0 0
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 |
Figure 120 shows the format of the Data Tables Storage Report. This report is produced using a combination of the EXEC CICS INQUIRE FILE and EXEC CICS COLLECT STATISTICS FILE commands. The statistics data is mapped by the DFHA17DS DSECT. The field headings and contents are described in Table 244.
Applid IYK2Z1V3 Sysid CJB3 Jobname CI07CJB3 Date 12/17/2004 Time 08:44:37 CICS 6.4.0 PAGE 75
Data Tables - Storage
<------- Total ------> <------ Entries -----> <------- Index ------> <---- --- Data ------->
Current Peak Storage Storage Storage Storage Storage Storage Storage Storage
Filename Type Records Records Allocated In-Use Allocated In-Use Allocated In-Use Allocated In-Use
________________________________________________________________________________________________________________________________
BRQFILE USER 0 0 0 0 0 0 0 0 0 0
F140BASE CICS 1 1 192 3 32 1 32 1 128 1
F150BASE USER 1 1 192 3 32 1 32 1 128 1
F170BASE USER 1 1 192 3 32 1 32 1 128 1
F270BASE CF 0 0 0 0 0 0 0 0 0 0
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 |