Default language.

I/O summary detail archive log report by DB2 and interval (BIOSUMAR)


The following figure shows a sample of the I/O summary detail archive log report by DB2 and interval (BIOSUMAR).


Important

The report is based on Db2 performance trace IFCIDs 36-37, 40-41, and 114-116.

1

1                       BIOSUMAR: IO SUMMARY DETAIL: ARCHIVE LOG                         11/04/14 08:44:06    PAGE     1

     LOCATION: DEEF                                                                                  DATA FROM: 05/29/2013 12:21:50
    D/S GROUP:           MBR:                      I/O SUMMARY DETAILS: ARCHIVE LOG                         TO: 05/29/2013 12:21:52
    SUBSYSTEM: DEEF      VER: 10.1

      DATASET                                                 AVERAGE                                        AVERAGE
       INTERVAL                     WAIT TYPE         TOTAL   ELAPSED  OTHER WAITS                   TOTAL   ELAPSED
      ---------------------------   -------------- -------- ---------  -------------------------- -------- ---------
 +    00006295
 .     05/29 12:20  - 05/29 12:25   READ FROM DASD        0       N/P  ALLOCATE                          1 00.286361
                                    READ FROM TAPE        0       N/P  DEALLOCATE                        1 00.207676
                                    OFFLOADS              1 01.677667  OPEN                              2 00.271016
                                    OTHER                 6 00.220538  CLOSE                             2 00.143581
                                                                       HSM RECALL                        0       N/P
                                    BLOCKS/OFFLOAD  1439.00            CATALOG LOCATE                    0       N/P
                                                                       MULTI-DATASET TAPE                0       N/P
                                                                       TAPE VOL POSITIONING              0       N/P
                                                                       WTOR ISSUED                       0       N/P
                                                                       DATA SET UNAVAILABLE              0       N/P
                                                                       PHYSICAL UNIT UNAVAILABLE         0       N/P
                                                                       READER SERVICE UNAVAILABLE        0       N/P

 .    ** DATASET TOTAL **           READ FROM DASD        0       N/P  ALLOCATE                          1 00.286361
                                    READ FROM TAPE        0       N/P  DEALLOCATE                        1 00.207676
                                    OFFLOADS              1 01.677667  OPEN                              2 00.271016
                                    OTHER                 6 00.220538  CLOSE                             2 00.143581
                                                                       HSM RECALL                        0       N/P
                                    BLOCKS/OFFLOAD  1439.00            CATALOG LOCATE                    0       N/P
                                                                       MULTI-DATASET TAPE                0       N/P
                                                                       TAPE VOL POSITIONING              0       N/P
                                                                       WTOR ISSUED                       0       N/P
                                                                       DATA SET UNAVAILABLE              0       N/P
                                                                       PHYSICAL UNIT UNAVAILABLE         0       N/P
                                                                       READER SERVICE UNAVAILABLE        0       N/P

 *     ****** GRAND TOTAL *******   READ FROM DASD        0       N/P  ALLOCATE                          1 00.286361
                                    READ FROM TAPE        0       N/P  DEALLOCATE                        1 00.207676
                                    OFFLOADS              1 01.677667  OPEN                              2 00.271016
                                    OTHER                 6 00.220538  CLOSE                             2 00.143581
                                                                       HSM RECALL                        0       N/P
                                    BLOCKS/OFFLOAD  1439.00            CATALOG LOCATE                    0       N/P
                                                                       MULTI-DATASET TAPE                0       N/P
                                                                       TAPE VOL POSITIONING              0       N/P
                                                                       WTOR ISSUED                       0       N/P
                                                                       DATA SET UNAVAILABLE              0       N/P
                                                                       PHYSICAL UNIT UNAVAILABLE         0       N/P
                                                                       READER SERVICE UNAVAILABLE        0       N/P

 

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