Default language.

I/O summary detail BSDS report by DB2 and interval (BIOSUMBS)

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

Related topic

I-O-activity-reports


Important

The report is based on Db2 performance trace IFCIDs 34-35, 119, and 120.

1

1                       BIOSUMBS: IO SUMMARY DETAIL: BSDS                                11/04/14 08:44:06    PAGE     1

     LOCATION: DEEF                                                                                  DATA FROM: 05/28/2013 14:11:46
    D/S GROUP:           MBR:                   I/O SUMMARY DETAILS: BOOTSTRAP DATASET                      TO: 05/30/2013 11:25:20
    SUBSYSTEM: DEEF      VER: 10.1

      DATASET                                                 AVERAGE
       INTERVAL                    WAIT TYPE          TOTAL   ELAPSED
      ---------------------------  --------------  -------- ---------
 +    BSDS0001
 .     05/28 14:10  - 05/28 14:15  READ REQUESTS          1 00.000780
                                   WRITE REQUESTS         1 00.000362
                                   TOTAL WAITS            2 00.000571

 .     05/29 12:20  - 05/29 12:25  READ REQUESTS        852 00.000629
                                   WRITE REQUESTS        26 00.000435
                                   TOTAL WAITS          878 00.000624

 .     05/30 11:25  - 05/30 11:30  READ REQUESTS          4 00.000703
                                   WRITE REQUESTS         4 00.000439
                                   TOTAL WAITS            8 00.000571

 .    *** TOTAL FOR DATASET ***    READ REQUESTS        857 00.000630
                                   WRITE REQUESTS        31 00.000433
                                   TOTAL WAITS          888 00.000623

 +    BSDS0002
 .     05/28 14:10  - 05/28 14:15  READ REQUESTS          1 00.000419
                                   WRITE REQUESTS         1 00.000302
                                   TOTAL WAITS            2 00.000360

 .     05/29 12:20  - 05/29 12:25  READ REQUESTS         26 00.001340
                                   WRITE REQUESTS        26 00.000441
                                   TOTAL WAITS           52 00.000891

 .     05/30 11:25  - 05/30 11:30  READ REQUESTS          4 00.000785
                                   WRITE REQUESTS         4 00.002176
                                   TOTAL WAITS            8 00.001481

 .    *** TOTAL FOR DATASET ***    READ REQUESTS         31 00.001239
                                   WRITE REQUESTS        31 00.000660
                                   TOTAL WAITS           62 00.000950

 *     ****** GRAND TOTAL *******  READ REQUESTS        888 00.000651
                                   WRITE REQUESTS        62 00.000547
                                   TOTAL WAITS          950 00.000644

 

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