IAMSMFVS EXCP Reports
After the summary report appear the EXCP reports. These reports are organized by access method, and contain the data sets with the most EXCPs. The maximum number of data sets in each access method report is based on the MAXREPORTS keyword of the REPORT command, which defaults to 100. The different access method reports are quite similar, so samples of VSAM and IAM EXCP Reports will be shown, followed by descriptions of the various fields contained in the report.
VSAM EXCP Report
Sample VSAM EXCP Report
%CLUSTER TOTAL SPLITS ALLOC
DATA SET NAME EXCPS EXCPS RECORDS READS INSERTS UPDATES DELETES CI CA TRKS
---- --- ---- ----- ----- ------- ----- ------- ------- ------- -- -- ----
IAMV.BNC750V.CLUSTER 100 16481568
IAMV.BNC750V.DATA 78 12789824 2000000 214400000 497504 3200000 497504 14016 3184 20040
IAMV.BNC750V.INDEX 22 3691744 2816 0 0 86296 0 3184 24 135
IAMV.BNC1KV.CLUSTER 100 16429455
IAMV.BNC1KV.DATA 79 13032467 2000000 187600000 435316 2800000 435316 11240 3605 30060
IAMV.BNC1KV.INDEX 21 3396988 3621 0 0 85008 0 3605 42 135
IAMV.BNC500V.CLUSTER 100 12599784
IAMV.BNC500V.DATA 73 9237824 2000000 214400000 497504 3200000 497504 46424 2080 25050
IAMV.BNC500V.INDEX 27 3361960 1813 0 0 50664 0 2080 24 135
IAMV.BNC250V.CLUSTER 100 10238592
IAMV.BNC250V.DATA 70 7187432 2000000 214400000 497504 3200000 497504 33104 976 12525
IAMV.BNC250V.INDEX 30 3051160 877 0 0 35096 0 976 16 135
IAM EXCP Report
Sample IAM EXCP Report
USE TOTAL OVERFLOW USED
DATA SET NAME COUNT EXCPS RECORDS READS INSERTS UPDATES DELETES RECS % TRKS
---- --- ---- ----- ----- ------- ----- ------- ------- ------- ----- --- ------
IAMV.BNC1KI.CLUSTER 343 4070498 2000000 236087152 652974 2100000 652974 20051 46 41438
IAMV.BNC750I.CLUSTER 391 2922216 2000000 260104976 715162 2300000 715162 15808 35 31009
IAMV.BNC500I.CLUSTER 374 1659165 2000000 248796064 684068 2200000 684068 14828 33 20664
IAMV.BNC250I.CLUSTER 360 777792 2000000 261813888 746256 2400000 746256 15055 34 10335
IAMV.BNC125I.CLUSTER 315 359822 2000000 229087152 652974 2100000 652974 13032 28 5218
IAMV.TEST.CLUSTER 31 214495 332000 1366072 520000 90398 120000 16412 30 5469
IAMV.LRG922.CLUSTER 8 1132 200000 1000005 0 0 0 0 100 1857
IAMV.TESTO.CLUSTER 3 971 306980 0 0 0 0 0 100 4899
IAMV.LRG923.CLUSTER 4 627 200000 400002 0 0 0 0 100 1857
IAMV.JFM600.CLUSTER 6 136 25000 100004 0 0 0 0 100 313
IAMV.JFM600.NEW.CLUSTER 5 15 25000 5 0 0 0 0 100 313
EXCP Report Field Descriptions
A description of the fields appearing on the EXCP reports is provided below. Note that some fields represent an accumulated value, whereas other fields indicate a maximum value. For IAM, maximum values for overflow are replaced with the most recent values if the keyword CURRENT is specified on the REPORT command.
Field Name | Description |
|---|---|
Data Set Name | Specifies the name of the data set. For cataloged VSAM data sets, this will have the cluster name on the first line, followed by the component names on subsequent lines, which are indented. |
% Cluster EXCPs | Indicates the percentage of the total EXCPs of each of the components of the VSAM cluster. For the cluster itself this value will be 100. Due to rounding, the total of the components may not add up to 100. (This is in the VSAM EXCP report only.) |
Use Count | Indicates the number of SMF records processed for this data set. This will usually be the number of times the data set was closed during the time interval of the report. (This column is only in the IAM EXCP report.) |
Total EXCPS | The accumulated total EXCP counts from all of the SMF records processed for this data set. For cataloged VSAM clusters, this number will be the total for all of the components, with the component value given on the subsequent lines. |
Records | Contains the maximum number of records that were in the file. |
Reads | Accumulated total from all of the SMF records found for the specified data set, of the records read. |
Inserts | Accumulated total number of records inserted. This value does NOT include the count of records from an initial file load. Also, for VSAM clusters, does not include records added to the end of the file. |
Updates | Accumulated total number of records updated. |
Deletes | Accumulated total number of records deleted. |
Splits - CI | For VSAM components, the accumulated total number of CI splits that occurred. |
Splits - CA | For VSAM components, the accumulated total number of CA splits that occurred. |
Alloc Tracks | For VSAM components, the maximum number of tracks allocated to the component. |
Overflow Recs | For IAM data sets, this indicates the maximum number of records in overflow, unless the keyword CURRENT was specified on the REPORT command. In that case, it will contain the value from the most recent SMF record for the data set. |
Overflow % | For IAM data sets, indicates the maximum percentage, or most recent value if CURRENT was specified, of the overflow area that was used. If a file has no overflow area, then this number will be 100 even though there are no records in the overflow area. For Enhanced format files that are defined with an Overflow override value, the percentage is based on that number. For Enhanced format files without an Overflow override, value is based on assumption using a total value for overflow from overflow blocks currently used plus all of the unused extended blocks. For Compatible format files, this percentage is based on the established size of the Independent Overflow Area. |
Used Tracks | For IAM data sets, indicates the maximum amount of DASD space used for this file. |