I/O summary detail active log report by DB2 and interval (BIOSUMLG)
1
*** GRAND TOTAL - DBD 2 2 00.003608 16142.00
1 BIOSUMLG: IO SUMMARY DETAIL: ACTIVE LOG 11/04/14 08:44:06 PAGE 1
LOCATION: DEEF DATA FROM: 05/28/2013 14:11:38
D/S GROUP: MBR: I/O SUMMARY DETAILS: ACTIVE LOG TO: 05/30/2013 11:25:20
SUBSYSTEM: DEEF VER: 10.1
I/O REQ READ REQ --WRITE REQUESTS--- ----------- OTHER WAITS ---------------
INTERVAL BEGIN - END TOTAL TOTAL TOTAL AV CONTIG ALLOCS DEALLOCS OPENS CLOSES
DATASET AVG ELAPS AVG ELAPS AVG ELAPS CI/WRITE AVG ELAPS AVG ELAPS AVG ELAPS AVG ELAPS
---------------------------- --------- --------- --------- --------- --------- --------- --------- ---------
+ 05/28 14:10 - 05/28 14:15
. ACTLG103 45 0 45 0 0 0 0
00.000941 N/P 00.000941 19.56 N/P N/P N/P N/P
. ACTLG203 45 0 45 0 0 0 0
00.001157 N/P 00.001157 19.56 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 90 0 90 0 0 0 0
00.001049 N/P 00.001049 19.56 N/P N/P N/P N/P
+ 05/29 11:55 - 05/29 12:00
. ACTLG102 6 0 6 0 0 0 0
00.000287 N/P 00.000287 1.33 N/P N/P N/P N/P
. ACTLG202 6 0 6 0 0 0 0
00.000454 N/P 00.000454 1.33 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 12 0 12 0 0 0 0
00.000371 N/P 00.000371 1.33 N/P N/P N/P N/P
+ 05/29 12:10 - 05/29 12:15
. ACTLG102 2 0 2 0 0 0 0
00.001048 N/P 00.001048 2.00 N/P N/P N/P N/P
. ACTLG202 2 0 2 0 0 0 0
00.001102 N/P 00.001102 2.00 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 4 0 4 0 0 0 0
00.001075 N/P 00.001075 2.00 N/P N/P N/P N/P
+ 05/29 12:15 - 05/29 12:20
. ACTLG102 2 0 2 0 0 0 0
00.000329 N/P 00.000329 2.00 N/P N/P N/P N/P
. ACTLG202 2 0 2 0 0 0 0
00.000500 N/P 00.000500 2.00 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 4 0 4 0 0 0 0
00.000415 N/P 00.000415 2.00 N/P N/P N/P N/P
+ 05/29 12:20 - 05/29 12:25
. ACTLG102 1082 108 974 0 0 0 0
00.000894 00.003602 00.000594 8.76 N/P N/P N/P N/P
. ACTLG103 1073 0 1073 0 0 0 0
00.000757 N/P 00.000757 4.50 N/P N/P N/P N/P
. ACTLG202 974 0 974 0 0 0 0
00.001000 N/P 00.001000 8.76 N/P N/P N/P N/P
1 BIOSUMLG: IO SUMMARY DETAIL: ACTIVE LOG 11/04/14 08:44:06 PAGE 2
LOCATION: DEEF DATA FROM: 05/28/2013 14:11:38
D/S GROUP: MBR: I/O SUMMARY DETAILS: ACTIVE LOG TO: 05/30/2013 11:25:20
SUBSYSTEM: DEEF VER: 10.1
I/O REQ READ REQ --WRITE REQUESTS--- ----------- OTHER WAITS ---------------
INTERVAL BEGIN - END TOTAL TOTAL TOTAL AV CONTIG ALLOCS DEALLOCS OPENS CLOSES
DATASET AVG ELAPS AVG ELAPS AVG ELAPS CI/WRITE AVG ELAPS AVG ELAPS AVG ELAPS AVG ELAPS
---------------------------- --------- --------- --------- --------- --------- --------- --------- ---------
. ACTLG203 1073 0 1073 0 0 0 0
00.001223 N/P 00.001223 4.50 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 4202 108 4094 0 0 0 0
00.000968 00.003602 00.000898 6.53 N/P N/P N/P N/P
+ 05/30 11:25 - 05/30 11:30
. ACTLG101 17 17 0 0 0 0 0
00.001461 00.001461 N/P N/P N/P N/P N/P N/P
. ACTLG103 14 14 0 0 0 0 0
00.001481 00.001481 N/P N/P N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 31 31 0 0 0 0 0
00.001470 00.001470 N/P N/P N/P N/P N/P N/P
.
******* GRAND TOTAL ******* 4343 139 4204 0 0 0 0
00.000971 00.003126 00.000900 6.79 N/P N/P N/P N/P
*** GRAND TOTAL - DBD 2 2 00.003608 16142.00
1 BIOSUMLG: IO SUMMARY DETAIL: ACTIVE LOG 11/04/14 08:44:06 PAGE 1
LOCATION: DEEF DATA FROM: 05/28/2013 14:11:38
D/S GROUP: MBR: I/O SUMMARY DETAILS: ACTIVE LOG TO: 05/30/2013 11:25:20
SUBSYSTEM: DEEF VER: 10.1
I/O REQ READ REQ --WRITE REQUESTS--- ----------- OTHER WAITS ---------------
INTERVAL BEGIN - END TOTAL TOTAL TOTAL AV CONTIG ALLOCS DEALLOCS OPENS CLOSES
DATASET AVG ELAPS AVG ELAPS AVG ELAPS CI/WRITE AVG ELAPS AVG ELAPS AVG ELAPS AVG ELAPS
---------------------------- --------- --------- --------- --------- --------- --------- --------- ---------
+ 05/28 14:10 - 05/28 14:15
. ACTLG103 45 0 45 0 0 0 0
00.000941 N/P 00.000941 19.56 N/P N/P N/P N/P
. ACTLG203 45 0 45 0 0 0 0
00.001157 N/P 00.001157 19.56 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 90 0 90 0 0 0 0
00.001049 N/P 00.001049 19.56 N/P N/P N/P N/P
+ 05/29 11:55 - 05/29 12:00
. ACTLG102 6 0 6 0 0 0 0
00.000287 N/P 00.000287 1.33 N/P N/P N/P N/P
. ACTLG202 6 0 6 0 0 0 0
00.000454 N/P 00.000454 1.33 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 12 0 12 0 0 0 0
00.000371 N/P 00.000371 1.33 N/P N/P N/P N/P
+ 05/29 12:10 - 05/29 12:15
. ACTLG102 2 0 2 0 0 0 0
00.001048 N/P 00.001048 2.00 N/P N/P N/P N/P
. ACTLG202 2 0 2 0 0 0 0
00.001102 N/P 00.001102 2.00 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 4 0 4 0 0 0 0
00.001075 N/P 00.001075 2.00 N/P N/P N/P N/P
+ 05/29 12:15 - 05/29 12:20
. ACTLG102 2 0 2 0 0 0 0
00.000329 N/P 00.000329 2.00 N/P N/P N/P N/P
. ACTLG202 2 0 2 0 0 0 0
00.000500 N/P 00.000500 2.00 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 4 0 4 0 0 0 0
00.000415 N/P 00.000415 2.00 N/P N/P N/P N/P
+ 05/29 12:20 - 05/29 12:25
. ACTLG102 1082 108 974 0 0 0 0
00.000894 00.003602 00.000594 8.76 N/P N/P N/P N/P
. ACTLG103 1073 0 1073 0 0 0 0
00.000757 N/P 00.000757 4.50 N/P N/P N/P N/P
. ACTLG202 974 0 974 0 0 0 0
00.001000 N/P 00.001000 8.76 N/P N/P N/P N/P
1 BIOSUMLG: IO SUMMARY DETAIL: ACTIVE LOG 11/04/14 08:44:06 PAGE 2
LOCATION: DEEF DATA FROM: 05/28/2013 14:11:38
D/S GROUP: MBR: I/O SUMMARY DETAILS: ACTIVE LOG TO: 05/30/2013 11:25:20
SUBSYSTEM: DEEF VER: 10.1
I/O REQ READ REQ --WRITE REQUESTS--- ----------- OTHER WAITS ---------------
INTERVAL BEGIN - END TOTAL TOTAL TOTAL AV CONTIG ALLOCS DEALLOCS OPENS CLOSES
DATASET AVG ELAPS AVG ELAPS AVG ELAPS CI/WRITE AVG ELAPS AVG ELAPS AVG ELAPS AVG ELAPS
---------------------------- --------- --------- --------- --------- --------- --------- --------- ---------
. ACTLG203 1073 0 1073 0 0 0 0
00.001223 N/P 00.001223 4.50 N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 4202 108 4094 0 0 0 0
00.000968 00.003602 00.000898 6.53 N/P N/P N/P N/P
+ 05/30 11:25 - 05/30 11:30
. ACTLG101 17 17 0 0 0 0 0
00.001461 00.001461 N/P N/P N/P N/P N/P N/P
. ACTLG103 14 14 0 0 0 0 0
00.001481 00.001481 N/P N/P N/P N/P N/P N/P
. *** INTERVAL TOTAL *** 31 31 0 0 0 0 0
00.001470 00.001470 N/P N/P N/P N/P N/P N/P
.
******* GRAND TOTAL ******* 4343 139 4204 0 0 0 0
00.000971 00.003126 00.000900 6.79 N/P N/P N/P N/P
Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*