Default language.

I/O summary detail buffer pool report by DB2 and interval (BIOSUMBP)


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


Important

The report is based on Db2 performance I/O trace IFCIDs 6-10, and 107.

1                       BIOSUMBP: IO SUMMARY DETAIL: BUFFER POOL                         11/04/14 08:44:06    PAGE     1

    LOCATION: DEEF                                                                                   DATA FROM: 05/28/2013 14:03:07
   D/S GROUP:           MBR:                          I/O SUMMARY DETAILS: BUFFER POOL                      TO: 05/29/2013 12:22:23
   SUBSYSTEM: DEEF      VER: 10.1


                               /---IO REQUESTS--/ /--------------READ REQUESTS----------------/  /------------WRITE REQUESTS-------/
    INTERVAL BEGIN - END                                         ------- WITH IO -------  W/OUT
        PRIME AUTHID                      AVERAGE                  AVERAGE         PAGES     IO                CAST   AVERAGE  PAGES
           PLAN NAME              TOTAL   ELAPSED    TOTAL TYPE    ELAPSED      %  /READ      %     TOTAL TYPE  OUT   ELAPSED /WRITE
    -------------------------- -------- --------- -------- ----- --------- ------ ------ ------  -------- ----- --- --------- ------
 .  05/28 14:00  - 05/28 14:05        3 00.010170        3 SYNCH 00.010170 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB2                                              0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DEFRRS01                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:00  - 05/28 14:05        6 00.000015        0 SYNCH       N/P    N/P    N/P    N/P         0 SYNCH NO        N/P    N/P
    SYSOPR                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    BLANK                                                6 DYNPF 00.000015 100.00   0.00   0.00         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:05  - 05/28 14:10       10 00.007655       10 SYNCH 00.007655 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    CPTT00T1                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        3                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:05  - 05/28 14:10        2 00.015928        2 SYNCH 00.015928 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    CPTT00T2                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        5                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:05  - 05/28 14:10       10 00.002520       10 SYNCH 00.002520 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    CPTT00T3                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        5                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:05  - 05/28 14:10        3 00.000286        3 SYNCH 00.000286 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DEFRRS01                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        7                  ANTICIPATED PAGE FAULTS:        0

1                       BIOSUMBP: IO SUMMARY DETAIL: BUFFER POOL                         11/04/14 08:44:06    PAGE     2

    LOCATION: DEEF                                                                                   DATA FROM: 05/28/2013 14:03:07
   D/S GROUP:           MBR:                          I/O SUMMARY DETAILS: BUFFER POOL                      TO: 05/29/2013 12:22:23
   SUBSYSTEM: DEEF      VER: 10.1


                               /---IO REQUESTS--/ /--------------READ REQUESTS----------------/  /------------WRITE REQUESTS-------/
    INTERVAL BEGIN - END                                         ------- WITH IO -------  W/OUT
        PRIME AUTHID                      AVERAGE                  AVERAGE         PAGES     IO                CAST   AVERAGE  PAGES
           PLAN NAME              TOTAL   ELAPSED    TOTAL TYPE    ELAPSED      %  /READ      %     TOTAL TYPE  OUT   ELAPSED /WRITE
    -------------------------- -------- --------- -------- ----- --------- ------ ------ ------  -------- ----- --- --------- ------
 .  05/28 14:05  - 05/28 14:10      332 00.001725      332 SYNCH 00.001725 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DSNTEP2                                              0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:       22                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:05  - 05/28 14:10    16109 00.000753       22 SYNCH 00.004188 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    SYSOPR                                           16069 SEQPF 00.000749  99.99  31.43   0.00         0 ASYNC NO        N/P    N/P
    BLANK                                               15 DYNPF 00.000059 100.00   0.53   0.00         0 SYNCH YES       N/P    N/P
                                                         3 LSTPF 00.002219  66.67   1.33   0.00         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        3                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:10  - 05/28 14:15        1 00.001007        0 SYNCH       N/P    N/P    N/P    N/P         1 SYNCH NO  00.001007   1.00
    RDHJMB                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    CPTT00T3                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:10  - 05/28 14:15      646 00.001510      646 SYNCH 00.001510 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DSNTEP2                                              0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/28 14:10  - 05/28 14:15    93153 00.000543        0 SYNCH       N/P    N/P    N/P    N/P         0 SYNCH NO        N/P    N/P
    SYSOPR                                           42575 SEQPF 00.000723  71.25  22.35   0.00         4 ASYNC NO  00.001956  32.00
    BLANK                                            41583 DYNPF 00.000384 122.79   7.34   0.00         0 SYNCH YES       N/P    N/P
                                                      8991 LSTPF 00.000431 130.79   9.67   0.00         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 11:50  - 05/29 11:55       24 00.006093       24 SYNCH 00.006093 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB2                                              0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DSNESPRR                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

1                       BIOSUMBP: IO SUMMARY DETAIL: BUFFER POOL                         11/04/14 08:44:06    PAGE     3

    LOCATION: DEEF                                                                                   DATA FROM: 05/28/2013 14:03:07
   D/S GROUP:           MBR:                          I/O SUMMARY DETAILS: BUFFER POOL                      TO: 05/29/2013 12:22:23
   SUBSYSTEM: DEEF      VER: 10.1


                               /---IO REQUESTS--/ /--------------READ REQUESTS----------------/  /------------WRITE REQUESTS-------/
    INTERVAL BEGIN - END                                         ------- WITH IO -------  W/OUT
        PRIME AUTHID                      AVERAGE                  AVERAGE         PAGES     IO                CAST   AVERAGE  PAGES
           PLAN NAME              TOTAL   ELAPSED    TOTAL TYPE    ELAPSED      %  /READ      %     TOTAL TYPE  OUT   ELAPSED /WRITE
    -------------------------- -------- --------- -------- ----- --------- ------ ------ ------  -------- ----- --- --------- ------
 .  05/29 11:50  - 05/29 11:55       22 00.004243        0 SYNCH       N/P    N/P    N/P    N/P         0 SYNCH NO        N/P    N/P
    SYSOPR                                               0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    BLANK                                                6 DYNPF 00.003982 100.00  16.00   0.00         0 SYNCH YES       N/P    N/P
                                                        16 LSTPF 00.004341 100.00  26.06   0.00         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 11:55  - 05/29 12:00       80 00.001996       80 SYNCH 00.001996 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB2                                              0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DSNESPRR                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 11:55  - 05/29 12:00     1317 00.001156        5 SYNCH 00.009781 120.00   2.40   0.00         0 SYNCH NO        N/P    N/P
    SYSOPR                                            1305 SEQPF 00.001120 100.00  31.56   0.00         2 ASYNC NO  00.002903   9.50
    BLANK                                                5 DYNPF 00.001403  80.00   3.20   0.00         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 12:10  - 05/29 12:15       20 00.000556       20 SYNCH 00.000556 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB2                                              0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DSNESPRR                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 12:10  - 05/29 12:15     1327 00.000846        6 SYNCH 00.003963 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    SYSOPR                                            1320 SEQPF 00.000832 100.00  31.56   0.00         0 ASYNC NO        N/P    N/P
    BLANK                                                1 DYNPF 00.001128 100.00   8.00   0.00         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 12:15  - 05/29 12:20       48 00.002865       48 SYNCH 00.002865 100.00   1.00   0.00         0 SYNCH NO        N/P    N/P
    RDHJMB2                                              0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DSNESPRR                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

1                       BIOSUMBP: IO SUMMARY DETAIL: BUFFER POOL                         11/04/14 08:44:06    PAGE     4

    LOCATION: DEEF                                                                                   DATA FROM: 05/28/2013 14:03:07
   D/S GROUP:           MBR:                          I/O SUMMARY DETAILS: BUFFER POOL                      TO: 05/29/2013 12:22:23
   SUBSYSTEM: DEEF      VER: 10.1


                               /---IO REQUESTS--/ /--------------READ REQUESTS----------------/  /------------WRITE REQUESTS-------/
    INTERVAL BEGIN - END                                         ------- WITH IO -------  W/OUT
        PRIME AUTHID                      AVERAGE                  AVERAGE         PAGES     IO                CAST   AVERAGE  PAGES
           PLAN NAME              TOTAL   ELAPSED    TOTAL TYPE    ELAPSED      %  /READ      %     TOTAL TYPE  OUT   ELAPSED /WRITE
    -------------------------- -------- --------- -------- ----- --------- ------ ------ ------  -------- ----- --- --------- ------
 .  05/29 12:15  - 05/29 12:20     1431 00.001091        0 SYNCH       N/P    N/P    N/P    N/P         0 SYNCH NO        N/P    N/P
    SYSOPR                                            1428 SEQPF 00.001093 100.00  30.46   0.00         0 ASYNC NO        N/P    N/P
    BLANK                                                3 DYNPF 00.000249 100.00   3.67   0.00         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 12:20  - 05/29 12:25    55040 00.000538    54990 SYNCH 00.000538 100.00   1.00   0.00        50 SYNCH NO  00.000460   1.00
    RDHJMB2                                              0 SEQPF       N/P    N/P    N/P    N/P         0 ASYNC NO        N/P    N/P
    DSNESPRR                                             0 DYNPF       N/P    N/P    N/P    N/P         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  05/29 12:20  - 05/29 12:25     8905 00.001342       18 SYNCH 00.002507 116.67   4.78   0.00         1 SYNCH NO  00.001315   1.00
    SYSOPR                                            3113 SEQPF 00.001337  99.94  31.95   0.00      5770 ASYNC NO  00.001341  27.28
    BLANK                                                3 DYNPF 00.000199  66.67   2.33   0.00         0 SYNCH YES       N/P    N/P
                                                         0 LSTPF       N/P    N/P    N/P    N/P         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:        0                  ANTICIPATED PAGE FAULTS:        0

 .  ****** GRAND TOTALS ******   178489 00.000621    56219 SYNCH 00.000569 100.00   1.00   0.00        52 SYNCH NO  00.000487   1.00
                                                     65810 SEQPF 00.000776  81.39  25.57   0.00      5776 ASYNC NO  00.001342  27.28
                                                     41622 DYNPF 00.000384 122.77   7.33   0.00         0 SYNCH YES       N/P    N/P
                                                      9010 LSTPF 00.000439 130.71   9.70   0.00         0 ASYNC YES       N/P    N/P

                                                          PAGESET OPENS:       45                  ANTICIPATED PAGE FAULTS:        0

 

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