IAMINFO Reports for File Load and File Access


There are two basic IAMINFO reports: File Load and File Access.

File Load Reports

A sample IAMINFO report for file load is shown in Sample of an IAMINFO Report for a File Load. The file load is indicated in the IAM361 message, where it shows that the data set was opened for FILE CREATION. Unique features of the IAMINFO file load report are that the average and maximum record lengths are shown in the report. These lengths are recorded after data compression, if any. Also reported under the IAM365 message is the amount of data space used as a temporary work area for the index. If the DISK BLOCKS READ is not zero, then a temporary data set was used for the work area for the index, instead of a Data Space.

File Access Reports

A sample IAMINFO report for normal file access is shown in Sample IAMINFO Report for File Access. A file access is indicated on the IAM361 message, where it will indicate either that the file is opened for INPUT or UPDATE processing. Other differences from the file load report include statistics for IAM's Dynamic Tabling feature, and statistics for the Index Space, which is a Data Space used to hold the index for the data set.

Sample of an IAMINFO Report for a File Load

IAM400  IAMINFO DATASET STATISTICS REPORT -- VERSION 10.0.01/01 SPIN 00 -- COMPUWARE CORP   DATE-2019.260
IAM360  STEP - LOADDATA   DDNAME - VSAMCRT1    DATA SET MONITORED - IAMV.MANUFAC.DATA
IAM361  INFO REQUESTED BY PROGRAM IAMTVRLS FOR FILE CREATION OPENED-2020.023.16:28:20 CLOSED-2019.260.16:28:23
IAM369  IAM OVERRIDES - NONE
IAM362  IAM DATA CHARACTERISTICS  -
      IAM FILE FORMAT-----------=      LARGE-FRMT   -   IAM FILE STATUS-----------=          LOADED
      DATASET TYPE--------------=            KSDS   -   SHARE OPTIONS-------------=               2
      LOGICAL RECORD LENGTH-----=             325   -   CI SIZE-------------------=            4096
      KEY SIZE------------------=              43   -   KEY OFFSET----------------=               8
      AVERAGE RECORD LENGTH-----=             283   -   LARGEST RECORD PROCESSED--=             284
      BLOCKING FACTOR-----------=               4   -   BLOCK SIZE----------------=           13682
      INTEGRATED OVERFLOW (CI%)-=               5   -   DASD RESERVE (CA%)--------=               0
IAM363  IAM FILE CHARACTERISTICS  -
      FILE DEFINED DATE---------=        2019.260   -   FILE DEFINED TIME---------=        16:28:19
      FILE LOADED DATE----------=        2019.260   -   FILE LOADED TIME----------=        16:28:23
      TOTAL RECORDS-------------=         500,000   -   TOTAL RECORDS DELETED-----=               0
      TOTAL RECORDS UPDATED-----=               0   -   TOTAL RECORDS INSERTED----=               0
      TRACKS IN USE-------------=           2,784   -   VARIABLE LENGTH OVERFLOW--=             YES
      NUMBER OF EXTENTS---------=               1   -   NUMBER OF VOLUMES---------=               1
      NUMBER OF IAM DATA BLOCKS-=          11,069   -   HIGH ALLOCATED RBN--------=               0
IAM372  IAM EXTENDED AREA CHARACTERISTICS -
      EXT. OVERFLOW RECORDS-----=               0   -   EXT. OVERFLOW BLOCKS------=               0
      EXTENDED BLOCKS ALLOCATED-=               0   -   EXTENDED PE BLOCKS--------=               0
      EXTENDED BLOCKS USED------=               0   -   EXTENDED BLOCKS AVAILABLE-=               0
IAM365  IAM EXECUTION STATISTICS -
      TOTAL STORAGE REQUIRED----=       1,988,864   -   PRIME INDEX(COMPRESSLK)---=         388,432
      STORAGE ABOVE THE LINE----=          10,384   -   COMPRESSED DATA STRUCTURE-=             YES
      64-BIT BUFFER STORAGE (K)-=               0   -   TURBO BUFFERING-----------=              NO
      REQUESTS PROCESSED--------=         500,002   -   REQUESTS FAILED-----------=               0
      DISK BLOCKS READ----------=               0   -   DISK BLOCKS WRITTEN-------=             187
      DYNAMIC BUFFER RETRIEVALS-=               0   -   MAXIMUM BUFFERS USED------=             120
      WORK 64BIT USED(M BYTES)--=               1   -   WORK 64BIT SIZE(M BYTES)--=              64
      Z/HPF I/O REQUESTS--------=             186   -   ECKD I/O REQUESTS---------=               1
IAM366  IAM COMMAND EXECUTION SUMMARY -
      GET RANDOM----------------=               0   -   PUT UPDATE----------------=               0
      GET SEQUENTIAL------------=               0   -   PUT ADD-------------------=         500,000
      GET PREVIOUS--------------=               0   -   POINT (START BROWSE)------=               0
      GET KGE/GENERIC-----------=               0   -   POINT KGE/GENERIC---------=               0
      GET (SKIP SEQUENTIAL)-----=               0   -   ERASE---------------------=               0
      ENDREQ--------------------=               0   -   WRTBFR--------------------=               0
      IAM STATISTICS------------=               0   -   IAM FLUSH BUFFER----------=               0
      CLOSE---------------------=               1   -   OPEN----------------------=               1
      CLOSE TYPE=T--------------=               0   -   VERIFY--------------------=               0
      INVALID REQUESTS----------=               0   -   RECORD LENGTH CHANGES-----=               0
      SEQ CHAINED BLOCKS READ---=               0   -   SEQ CHAINED BLOCKS WRITTEN=          10,948

Samples of IAMINFO Report for File Access

IAM400  IAMINFO DATASET STATISTICS REPORT --  VERSION  10.0.01/00 SPIN 00  -- COMPUWARE CORP   DATE-2019.260
IAM360  STEP - IAMRLSB    DDNAME - SYS00003    DATA SET MONITORED - IAMCICSV.IAQA.RLSB.IVTK31
IAM361  INFO REQUESTED BY PROGRAM IAMBQP   FOR UPDATE PROCESSING    OPENED-2019.260.11:23:09  CLOSED-2019.260.11:29:11
IAM369  IAM OVERRIDES - BUF64=YES,MAXBUFNO=90,MINBUFNO=25
IAM362  IAM DATA CHARACTERISTICS  -
      IAM FILE FORMAT-----------=      LARGE-FRMT   -   IAM FILE STATUS-----------=          LOADED
      DATASET TYPE--------------=            KSDS   -   SHARE OPTIONS-------------=               2
      LOGICAL RECORD LENGTH-----=             200   -   CI SIZE-------------------=            4096
      KEY SIZE------------------=              41   -   KEY OFFSET----------------=               8
      BLOCKING FACTOR-----------=               4   -   BLOCK SIZE----------------=           13682
      INTEGRATED OVERFLOW (CI%)-=              16   -   DASD RESERVE (CA%)--------=               2
IAM363  IAM FILE CHARACTERISTICS  -
      FILE DEFINED DATE---------=        2019.260   -   FILE DEFINED TIME---------=        11:18:24
      FILE LOADED DATE----------=        2019.260   -   FILE LOADED TIME----------=        11:18:39
      FILE UPDATE DATE----------=        2019.260   -   FILE UPDATE TIME----------=        11:29:11
      TOTAL RECORDS-------------=       3,001,012   -   TOTAL RECORDS DELETED-----=           1,710
      TOTAL RECORDS UPDATED-----=          51,146   -   TOTAL RECORDS INSERTED----=           2,722
      TRACKS IN USE-------------=          13,419   -   VARIABLE LENGTH OVERFLOW--=             YES
      NUMBER OF EXTENTS---------=               1   -   NUMBER OF VOLUMES---------=               1
      NUMBER OF IAM DATA BLOCKS-=          53,363   -   HIGH ALLOCATED RBN--------=          54,239
IAM372  IAM EXTENDED AREA CHARACTERISTICS -
      EXT. OVERFLOW RECORDS-----=             171   -   EXT. OVERFLOW BLOCKS------=               1
      EXTENDED BLOCKS ALLOCATED-=             571   -   EXTENDED PE BLOCKS--------=               2
      EXTENDED BLOCKS USED------=               6   -   EXTENDED BLOCKS AVAILABLE-=             565
IAM365  IAM EXECUTION STATISTICS -
      TOTAL STORAGE REQUIRED----=          77,824   -   PRIME INDEX(COMPRESSLK)---=       1,893,987
      STORAGE ABOVE THE LINE----=          73,728   -   COMPRESSED DATA STRUCTURE-=             YES
      64-BIT BUFFER STORAGE (K)-=           1,024   -   TURBO BUFFERING-----------=             YES
      64-BIT INDEX STORAGE (K)--=           2,304   -   TOTAL JOB 64-BIT INDEX (K)=          13,056
      REQUESTS PROCESSED--------=         113,031   -   REQUESTS FAILED-----------=           2,722
      DISK BLOCKS READ----------=           2,177   -   DISK BLOCKS WRITTEN-------=          55,590
      DYNAMIC BUFFER RETRIEVALS-=         163,247   -   MAXIMUM BUFFERS USED------=              76
      MINIMUM BUFFERS USED------=              76   -   MAXIMUM BUFFERS AVAILABLE-=              76
      WORK 64BIT USED(M BYTES)--=               0   -   WORK 64BIT SIZE(M BYTES)--=               0
      Z/HPF I/O REQUESTS--------=          57,766   -   ECKD I/O REQUESTS---------=               1
      DYNAMIC BUFFER RETRIEVAL %=              98
IAM368  SPECIFYING A BUFNO VALUE GREATER THAN    76 MAY IMPROVE PERFORMANCE
IAM366  IAM COMMAND EXECUTION SUMMARY -
      GET RANDOM----------------=          56,569   -   PUT UPDATE----------------=          51,146
      GET SEQUENTIAL------------=             686   -   PUT ADD-------------------=           2,722
      GET PREVIOUS--------------=              50   -   POINT (START BROWSE)------=               0
      GET KGE/GENERIC-----------=               2   -   POINT KGE/GENERIC---------=              72
      GET (SKIP SEQUENTIAL)-----=               0   -   ERASE---------------------=           1,710
      ENDREQ--------------------=              72   -   WRTBFR--------------------=               0
      IAM STATISTICS------------=               0   -   IAM FLUSH BUFFER----------=               0
      CLOSE---------------------=               1   -   OPEN----------------------=               1
      CLOSE TYPE=T--------------=               0   -   VERIFY--------------------=               0
      INVALID REQUESTS----------=               0   -   RECORD LENGTH CHANGES-----=           2,991
      SEQ CHAINED BLOCKS READ---=             138   -   SEQ CHAINED BLOCKS WRITTEN=               0
1IAM400  IAMINFO DATASET STATISTICS REPORT --  VERSION 10.0.01 SPIN 01  -- COMPUWARE, A BMC COMPANY     DATE-2021.237
0IAM360  STEP - LOAD01     DDNAME - VSAMCRT1    DATA SET MONITORED - CPAMOB.IAQA.LOCAL.IVTK1
0IAM361  INFO REQUESTED BY PROGRAM IAMTVSAM FOR FILE CREATION        OPENED-2021.237.13:42:55  CLOSED-2021.237.13:42:55
0IAM369  IAM OVERRIDES - MAX64BUF=18200,MIN64BUF=12500
0IAM362  IAM DATA CHARACTERISTICS  -
0        IAM FILE FORMAT-----------=       ENCRYPTED   -   IAM FILE STATUS-----------=          LOADED
        DATASET TYPE--------------=            KSDS   -   SHARE OPTIONS-------------=               2
        LOGICAL RECORD LENGTH-----=             200   -   CI SIZE-------------------=            4096
        KEY SIZE------------------=              41   -   KEY OFFSET----------------=               8
        AVERAGE RECORD LENGTH-----=             200   -   LARGEST RECORD PROCESSED--=             200
0        BLOCKING FACTOR-----------=               4   -   BLOCK SIZE----------------=           20480
        INTEGRATED OVERFLOW (CI%)-=               8   -   DASD RESERVE (CA%)--------=               4
0IAM363  IAM FILE CHARACTERISTICS  -
        FILE DEFINED DATE---------=        2021.237   -   FILE DEFINED TIME---------=        13:42:55
        FILE LOADED DATE----------=        2021.237   -   FILE LOADED TIME----------=        13:42:55
        FILE LOADED DATE----------=        2021.237   -   FILE LOADED TIME----------=        13:42:55
        TOTAL RECORDS-------------=          11,000   -   TOTAL RECORDS DELETED-----=               0
        TOTAL RECORDS UPDATED-----=               0   -   TOTAL RECORDS INSERTED----=               0
        TRACKS IN USE-------------=              60   -   VARIABLE LENGTH OVERFLOW--=             YES
        NUMBER OF EXTENTS---------=               1   -   NUMBER OF VOLUMES---------=               1
        NUMBER OF IAM DATA BLOCKS-=             122   -   HIGH ALLOCATED RBN--------=               0
0IAM372  IAM EXTENDED AREA CHARACTERISTICS -
0        EXT. OVERFLOW RECORDS-----=               0   -   EXT. OVERFLOW BLOCKS------=               0
        EXTENDED BLOCKS ALLOCATED-=               0   -   EXTENDED PE BLOCKS--------=               0
        EXTENDED BLOCKS USED------=               0   -   EXTENDED BLOCKS AVAILABLE-=               0
0IAM365  IAM EXECUTION STATISTICS -
0        TOTAL STORAGE REQUIRED----=       1,841,264   -   PRIME INDEX---------------=           4,920
        STORAGE ABOVE THE LINE----=          10,240   -   COMPRESSED DATA STRUCTURE-=             YES
        64-BIT BUFFER STORAGE (K)-=               0   -   ENCRYPT BUFFER STORAGE ---=               0
        REQUESTS PROCESSED--------=          11,002   -   REQUESTS FAILED-----------=               0
        DISK BLOCKS READ----------=               0   -   DISK BLOCKS WRITTEN-------=               6
        DYNAMIC BUFFER RETRIEVALS-=               0   -   MAXIMUM BUFFERS USED------=              74
        MINIMUM 64-BIT BUFFERS----=          12,500   -   MAXIMUM 64-BIT BUFFERS----=          18,200
        WORK 64BIT USED(M BYTES)--=               1   -   WORK 64BIT SIZE(M BYTES)--=              64
0IAM366  IAM COMMAND EXECUTION SUMMARY -
        GET RANDOM----------------=               0   -   PUT UPDATE----------------=               0
        GET SEQUENTIAL------------=               0   -   PUT ADD-------------------=          11,000
        GET PREVIOUS--------------=               0   -   POINT (START BROWSE)------=               0
        GET KGE/GENERIC-----------=               0   -   POINT KGE/GENERIC---------=               0
        GET (SKIP SEQUENTIAL)-----=               0   -   ERASE---------------------=               0
        ENDREQ--------------------=               0   -   WRTBFR--------------------=               0
        IAM STATISTICS------------=               0   -   IAM FLUSH BUFFER----------=               0
        CLOSE---------------------=               1   -   OPEN----------------------=               1
        CLOSE TYPE=T--------------=               0   -   VERIFY--------------------=               0
        INVALID REQUESTS----------=               0   -   RECORD LENGTH CHANGES-----=               0
        SEQ CHAINED BLOCKS READ---=               0   -   SEQ CHAINED BLOCKS WRITTEN=             149


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*