These sample extracts from the file statistics for a hypothetical
configuration are used to discuss how to interpret the information
about data tables which is provided by the CICS statistics.
Figure 1, Figure 2, and Figure 3 show extracts from the file statistics for a hypothetical configuration similar to that discussed in Using statistics to select data tables, following conversion of the files into data tables. Figure 1. CICFOR requested file statistics
Requested Statistics Report Collection Date-Time 12/25/99-23:55:41 Last Reset 21:00:00 Applid CICFOR Jobname SDTGSTF1
_________________________________________________________________________________________________________________________________
FILES - Resource Information
____________________________
File Data Set Name Data Set RLS DT Time Time Remote Remote Lsrpool
Name Base Data Set Name (If Applicable) Type File Indicator Opened Closed Name Sysid ID
____________________________________________________________________________________________________________________________
APPLE CIC01.CICOWN.APPLES K NO T 22:12:04 OPEN 1
BANANA CIC01.CICOWN.BANANAS K NO T 22:53:56 OPEN 1
ORANGE CIC01.CICOWN.CITRUS K NO T 20:51:25 OPEN 2
PLUM CIC01.CICOWN.PLUMS K NO T 21:30:10 OPEN 4
POTATO CIC01.CICOWN.POTATOES K NO T 20:30:10 OPEN 8
VICTORIA CIC01.CICOWN.PLUMS K NO S 21:56:23 OPEN 4
____________________________________________________________________________________________________________________________
Requested Statistics Report Collection Date-Time 12/25/99-23:55:41 Last Reset 21:00:00 Applid CICFOR Jobname SDTGSTF1
_________________________________________________________________________________________________________________________________
FILES - Requests Information
____________________________
File Get Get Upd Browse Update Add Delete Brws Upd VSAM EXCP Requests RLS req
Name Requests Requests Requests Requests Requests Requests Requests Data Index Timeouts
____________________________________________________________________________________________________
APPLE 1 495 760001 495 12 0 0 14560 1321 0
BANANA 0 1803 48603 1803 951 0 0 8212 481 0
ORANGE 1087 102677 104 107897 4709 1880 0 25180 1947 0
PLUM 0 10 2001 0 20 10 0 580 3 0
POTATO 0 0 24173 0 0 0 0 4513 2 0
VICTORIA 0 3 0 0 5 3 0 5 1 0
____________________________________________________________________________________________________
*TOTALS* 1088 104988 834882 110195 5697 1893
Requested Statistics Report Collection Date-Time 12/25/99-23:55:41 Last Reset 21:00:00 Applid CICFOR Jobname SDTGSTF1
_________________________________________________________________________________________________________________________________
FILES - Data Table Requests Information
_______________________________________
File Close Read Recs ¬ Adds from Add Adds rejected Adds rejected Rewrite Delete Highest Storage
Name Type Requests in Table Reads Requests - Exit - Table Full Requests Requests Table Size Alloc(K)
___________________________________________________________________________________________________________________________
APPLE 1105241 1 760000 12 0 0 495 0 760012 95104
BANANA 652195 0 48602 951 2 0 1803 0 49551 11200
ORANGE 1473 1191 0 4709 0 0 107897 1880 604167 266658
PLUM 227 1 2000 20 0 0 0 10 2025 256
POTATO 9670 24173 24165 0 0 24165 0 0 1000 1760
VICTORIA 3063 1 0 5 0 0 0 3 2025 256
___________________________________________________________________________________________________________________________
*TOTALS* 1771869 25367 834767 5697 2 24165 110195 1893 760012
Figure 2. CICAOR1 requested file statistics
Requested Statistics Report Collection Date-Time 12/25/99-23:56:58 Last Reset 21:00:00 Applid CICAOR1 Jobname SDTGSTA1
_________________________________________________________________________________________________________________________________
FILES - Resource Information
____________________________
File Data Set Name Data Set RLS DT Time Time Remote Remote Lsrpool
Name Base Data Set Name (If Applicable) Type File Indicator Opened Closed Name Sysid ID
____________________________________________________________________________________________________________________________
APPLE REMOTE NO R CLOSED CLOSED APPLE CIF1 N
BANANA REMOTE NO R CLOSED CLOSED BANANA CIF1 N
ORANGE REMOTE NO R CLOSED CLOSED ORANGE CIF1 N
POTATO REMOTE NO R CLOSED CLOSED POTATO CIF1 N
ZUCCHINI REMOTE NO R CLOSED CLOSED COURGETT CIA2 N
____________________________________________________________________________________________________________________
Requested Statistics Report Collection Date-Time 12/25/99-23:56:58 Last Reset 21:00:00 Applid CICAOR1 Jobname SDTGSTA1
_________________________________________________________________________________________________________________________________
FILES - Requests Information
____________________________
File Get Get Upd Browse Update Add Delete Brws Upd VSAM EXCP Requests RLS req
Name Requests Requests Requests Requests Requests Requests Requests Data Index Timeouts
____________________________________________________________________________________________________
APPLE 1 520 0 520 5 0 0 0 0 0
BANANA 0 0 0 0 0 0 0 0 0 0
ORANGE 214 38735 14 37105 1311 630 0 0 0 0
POTATO 0 0 24173 0 0 0 0 0 0 0
ZUCCHINI 0 0 0 0 0 0 0 0 0 0
____________________________________________________________________________________________________
*TOTALS* 215 39255 24187 38625 1316 630 0 0
Requested Statistics Report Collection Date-Time 12/25/99-23:56:58 Last Reset 21:00:00 Applid CICAOR1 Jobname SDTGSTA1
_________________________________________________________________________________________________________________________________
FILES - Data Table Requests Information
_______________________________________
File Close Read Recs ¬ Adds from Add Adds rejected Adds rejected Rewrite Delete Highest Storage
Name Type Requests in Table Reads Requests - Exit - Table Full Requests Requests Table Size Alloc(K)
___________________________________________________________________________________________________________________________
APPLE 1304214 0 0 0 0 0 0 0 0
BANANA 441349 0 0 0 0 0 0 0 0
ORANGE 63384 228 0 0 0 0 0 0 0
POTATO 4835 24173 0 0 0 0 0 0 0
ZUCCHINI 97867 0 0 0 0 0 0 0 0
___________________________________________________________________________________________________________________________
*TOTALS* 1911649 24401 0 0 0 0 0 0 0
Figure 3. CICAOR2 requested file statistics
Requested Statistics Report Collection Date-Time 12/25/99-23:59:59 Last Reset 21:00:00 Applid CICAOR2 Jobname SDTGSTA2
_________________________________________________________________________________________________________________________________
FILES - Resource Information
____________________________
File Data Set Name Data Set RLS DT Time Time Remote Remote Lsrpool
Name Base Data Set Name (If Applicable) Type File Indicator Opened Closed Name Sysid ID
____________________________________________________________________________________________________________________________
COURGETT CIC02.CICOWN.COURGETT K NO T 22:35:02 OPEN 1
LEMON REMOTE NO R CLOSED CLOSED ORANGE CIF1 N
____________________________________________________________________________________________________________________
Requested Statistics Report Collection Date-Time 12/25/99-23:59:59 Last Reset 21:00:00 Applid CICAOR2 Jobname SDTGSTA2
_________________________________________________________________________________________________________________________________
FILES - Requests Information
____________________________
File Get Get Upd Browse Update Add Delete Brws Upd VSAM EXCP Requests RLS req
Name Requests Requests Requests Requests Requests Requests Requests Data Index Timeouts
____________________________________________________________________________________________________
COURGETT 0 0 0 0 0 0 0 0 0 0
LEMON 946 63942 299 70792 3398 1250 0 0 0 0
____________________________________________________________________________________________________
*TOTALS* 946 63942 299 70792 3398 1250 0 0
Requested Statistics Report Collection Date-Time 12/25/99-23:59:59 Last Reset 21:00:00 Applid CICAOR2 Jobname SDTGSTA2
_________________________________________________________________________________________________________________________________
FILES - Data Table Requests Information
_______________________________________
File Close Read Recs ¬ Adds from Add Adds rejected Adds rejected Rewrite Delete Highest Storage
Name Type Requests in Table Reads Requests - Exit - Table Full Requests Requests Table Size Alloc(K)
___________________________________________________________________________________________________________________________
COURGETT 27656 0 0 386590 0 0 27656 0 101232 16160
LEMON 3240872 1245 0 0 0 0 0 0 0
___________________________________________________________________________________________________________________________
*TOTALS* 3268528 1245 0 386590 0 0 27656 0 101232
The main changes that are seen in the statistics when a file is
redefined as a data table are:
Values appear in the owning region showing the activity of loading
the data table.
Except during loading, the counts of Get Requests and Browse
Requests in the “FILES - Requests Information” statistics
for the owning region are much reduced (often to zero), because such
requests can now be satisfied from the data table using cross memory
services, so they appear in only the requesting regions.
After the initial load, data table statistics for update requests
appear in both the owning and requesting regions showing the use of
the data table.
The Recs ¬ in Table figure indicates the degree
to which benefit from shared data tables support has been prevented.
In an AOR it shows how many retrieval requests have had to be function
shipped. In an FOR it shows how many records have had to be fetched
from the source data set.
You should use the statistics to get an overall feel for the behavior
of your data tables, rather than attempt to explain the individual
values.