Data Tables Reports

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.

Figure 119. The Data Tables Requests Report
  
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
 
 
Table 243. Fields in the Data Tables Requests Report
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.

Figure 120. The Data Tables Storage Report

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
 
Table 244. Fields in the Data Tables Storage Report
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

Related reference
Back to full list of DFH0STAT reports
The DFH0STAT reports
Interpreting these statistics
Interpreting file statistics
Full listing and DFHSTUP reports for these statistics
File control statistics
[[ Contents Previous Page | Next Page Index ]]