The HADR Calculator is one of three HADR tools provided by IBM on developerWorks. For more details on the other(s), see:
HADR Tools: the HADR Simulator
For the full technical specifications and details on using the HADR tools, see:
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki/DB2HADR/
What are the HADR Tools?
IBM provides three major HADR tools on a devloperWorks wiki site.
The HADR Simulator is used to look both at disk speed and network details around HADR. It can be used in several different ways, including helping you to troubleshoot the way HADR does name resolution.
The DB2 Log Scanner is used to look at log files and report details about your DB2 Workload. The output is a bit cryptic, and this tool is best used in conjunction with the HADR Calculator. This does require real log files from a real workload, so if you’re setting up a new system, you will need to have actual work on the system before you can use it. Also, IBM will not provide the tool they use internally to uncompress automatically compressed log files, so if you want to use it, you’ll have to turn automatic log compression off. I tried to get the tool, they would not give it to me.
The HADR Calculator takes input from the DB2 Log Scanner, and values that you can compute using the HADR Simulator, and tells you which HADR SYNCMODEs make the most sense for you.
These three tools do NOT require that you have DB2 on a server to run – they are fully standalone. There are versions of the first two for each operating system. The third requires that you have perl, but can be run anywhere, including on a laptop or personal computer. This allows you flexibility in considering details of a network or server you are thinking of using before actually using it. And allows you to analyze log files without adding workload to a server.
Using the HADR Calculator
The HADR Calculator requires you to pull four values from the HADR Simulator output and to give it the filename from the db2logscan output.
Getting the Disk Numbers
It’s actually easiest to run the HADR simulator separately to get the disk values using two separate commands:
$ ./simhadr_linux -write test.out -flushSize 1
+ simhadr -write test.out -flushSize 1
Measured sleep overhead: 0.003843 second, using spin time 0.004611 second.
Simulation run time = 4 seconds
use file system cache = false
write behind caching = false
Writing to file test.out
Press Ctrl-C to stop.
Total 136 writes in 4.022017 seconds, 0.029574 sec/write, 1 pages/write
Total 0.557056 MBytes written in 4.022017 seconds. 0.138502 MBytes/sec
Distribution of write time (unit is microsecond):
Total 136 numbers, Sum 4022017, Min 16092, Max 60107, Avg 29573
From 8192 to 16383 1 numbers
From 16384 to 32767 130 numbers
From 32768 to 65535 5 numbers
AND
$ ./simhadr_linux -write test.out -flushSize 1000
+ simhadr -write test.out -flushSize 1000
Measured sleep overhead: 0.003925 second, using spin time 0.004710 second.
Simulation run time = 4 seconds
use file system cache = false
write behind caching = false
Writing to file test.out
Press Ctrl-C to stop.
Total 46 writes in 4.034771 seconds, 0.087712 sec/write, 1000 pages/write
Total 188.416000 MBytes written in 4.034771 seconds. 46.698065 MBytes/sec
Distribution of write time (unit is microsecond):
Total 46 numbers, Sum 4034771, Min 72366, Max 148424, Avg 87712
From 65536 to 131071 45 numbers
From 131072 to 262143 1 numbers
Now this will actually generate a file on disk, so make sure you have some space where you’re running this, and also delete test.out when done. The numbers to pull out are highlighted above.
Getting the Network Numbers
The network round trip time actually comes from a simple ping:
$ ping server2
PING server2 (000.000.000.000) 56(84) bytes of data.
64 bytes from server2 (000.000.000.000): icmp_seq=1 ttl=64 time=0.124 ms
64 bytes from server2 (000.000.000.000): icmp_seq=2 ttl=64 time=0.152 ms
64 bytes from server2 (000.000.000.000): icmp_seq=3 ttl=64 time=0.083 ms
64 bytes from server2 (000.000.000.000): icmp_seq=4 ttl=64 time=0.076 ms
--- ssadwdevdata ping statistics ---
4 packets transmitted, 4 received, 0% packet loss, time 3001ms
rtt min/avg/max/mdev = 0.076/0.108/0.152/0.033 ms
Note that this value is in ms, and we need it in seconds, so multiply this value by 0.001 to get the value you need to give the HADR calculator.
The final network number needed comes from the HADR Simulator. See my blog entry on the HADR Simulator to see how to run it and the full output. The piece of output we’re looking for is:
Total 18163171328 bytes sent in 60.000131 seconds. 302.718861 MBytes/sec
Executing the HADR Calculator
With all the input pieces gathered, we can run the HADR calculator. The general form of syntax is:
./hadrCalculator.pl –disk <MB/sec> <overhead secs per write> -network <MB/sec> <round trip secs> db2logscan filename
Using the details from the examples in this post, the command would be:
$ ./hadrCalculator.pl -disk 46.698065 0.029574 -network 302.718861 0.000108 db2logscan.bcudb.out hadrCalculator.pl: Network speed 302.718861 MB/s, 0.000108 second round trip time hadrCalculator.pl: Disk speed 46.698065 MB/s, 0.029574 second overhead per write This machine is small endian. Environment variable TZ is not set. Timezone is PST/PDT, 8.0 hours west of GMT, has_daylight_rule=1 Current local time is 2014-12-07 17:45:34 Reading file list from "logfiles.list" File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000000.LOG" 2014-12-07 02:09:58 0.074 MB/s, 61 sec, 1.7 pg/f, 0.092564 sec/f, 163.8 pg/tr, 8.714286 sec/tr, 20.333333 sec/cmt, nOpenTrans 3.7 actual 0.074 MB/s@ 1 pg/f 0.092564 s/f SYNC 0.111 MB/s@ 1 pg/f 0.059562 s/f, min 0.111 MB/s@ 1 pg/f 0.059562 s/f, max 14.053 MB/s@ 606 pg/f 0.168469 s/f NEARSYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 29.493 MB/s@ 606 pg/f 0.080270 s/f ASYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 29.493 MB/s@ 606 pg/f 0.080270 s/f 2014-12-07 02:11:35 0.005 MB/s, 97 sec, 1.5 pg/f, 1.227848 sec/f, 57.5 pg/tr, 21.000000 sec/tr, 48.500000 sec/cmt, nOpenTrans 5.5 actual 0.005 MB/s@ 1 pg/f 1.227848 s/f SYNC 0.098 MB/s@ 1 pg/f 0.059526 s/f, min 0.098 MB/s@ 1 pg/f 0.059526 s/f, max 10.627 MB/s@ 316 pg/f 0.116245 s/f NEARSYNC 0.197 MB/s@ 1 pg/f 0.029699 s/f, min 0.197 MB/s@ 1 pg/f 0.029699 s/f, max 22.049 MB/s@ 316 pg/f 0.056028 s/f ASYNC 0.197 MB/s@ 1 pg/f 0.029699 s/f, min 0.197 MB/s@ 1 pg/f 0.029699 s/f, max 22.049 MB/s@ 316 pg/f 0.056028 s/f 2014-12-07 02:13:15 0.006 MB/s, 100 sec, 1.5 pg/f, 0.990099 sec/f, 150.1 pg/tr, 155.000000 sec/tr, 100.000000 sec/cmt, nOpenTrans 5.5 actual 0.006 MB/s@ 1 pg/f 0.990099 s/f SYNC 0.098 MB/s@ 1 pg/f 0.059526 s/f, min 0.098 MB/s@ 1 pg/f 0.059526 s/f, max 15.502 MB/s@ 825 pg/f 0.208022 s/f NEARSYNC 0.197 MB/s@ 1 pg/f 0.029699 s/f, min 0.197 MB/s@ 1 pg/f 0.029699 s/f, max 32.696 MB/s@ 825 pg/f 0.098630 s/f ASYNC 0.197 MB/s@ 1 pg/f 0.029699 s/f, min 0.197 MB/s@ 1 pg/f 0.029699 s/f, max 32.696 MB/s@ 825 pg/f 0.098630 s/f 2014-12-07 02:16:17 0.000 MB/s, 182 sec, 3.0 pg/f, 182.000000 sec/f, 1.3 pg/tr, 2.000000 sec/tr, 182.000000 sec/cmt, nOpenTrans 5.5 actual 0.000 MB/s@ 3 pg/f 182.000000 s/f SYNC 0.196 MB/s@ 3 pg/f 0.059797 s/f, min 0.196 MB/s@ 3 pg/f 0.059797 s/f, max 0.461 MB/s@ 7 pg/f 0.060544 s/f NEARSYNC 0.393 MB/s@ 3 pg/f 0.029825 s/f, min 0.393 MB/s@ 3 pg/f 0.029825 s/f, max 0.926 MB/s@ 7 pg/f 0.030172 s/f ASYNC 0.393 MB/s@ 3 pg/f 0.029825 s/f, min 0.393 MB/s@ 3 pg/f 0.029825 s/f, max 0.926 MB/s@ 7 pg/f 0.030172 s/f 2014-12-07 02:24:06 0.023 MB/s, 469 sec, 2.3 pg/f, 0.391486 sec/f, 542.7 pg/tr, 82.800000 sec/tr, 93.800000 sec/cmt, nOpenTrans 7.2 actual 0.023 MB/s@ 2 pg/f 0.391486 s/f SYNC 0.151 MB/s@ 2 pg/f 0.059670 s/f, min 0.151 MB/s@ 2 pg/f 0.059670 s/f, max 19.994 MB/s@ 3907 pg/f 0.763385 s/f NEARSYNC 0.302 MB/s@ 2 pg/f 0.029766 s/f, min 0.302 MB/s@ 2 pg/f 0.029766 s/f, max 42.823 MB/s@ 3907 pg/f 0.356428 s/f ASYNC 0.302 MB/s@ 2 pg/f 0.029766 s/f, min 0.302 MB/s@ 2 pg/f 0.029766 s/f, max 42.823 MB/s@ 3907 pg/f 0.356428 s/f 2014-12-07 02:25:25 0.000 MB/s, 79 sec, 2.0 pg/f, 79.000000 sec/f, 1.3 pg/tr, 7.000000 sec/tr, 79.000000 sec/cmt, nOpenTrans 9.5 actual 0.000 MB/s@ 2 pg/f 79.000000 s/f SYNC 0.131 MB/s@ 2 pg/f 0.059616 s/f, min 0.131 MB/s@ 2 pg/f 0.059616 s/f, max 0.785 MB/s@ 12 pg/f 0.061481 s/f NEARSYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 1.576 MB/s@ 12 pg/f 0.030607 s/f ASYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 1.576 MB/s@ 12 pg/f 0.030607 s/f 2014-12-07 02:27:39 0.033 MB/s, 134 sec, 1.7 pg/f, 0.200000 sec/f, 1113.6 pg/tr, 206.000000 sec/tr, 134.000000 sec/cmt, nOpenTrans 9.5 actual 0.033 MB/s@ 1 pg/f 0.200000 s/f SYNC 0.111 MB/s@ 1 pg/f 0.059562 s/f, min 0.111 MB/s@ 1 pg/f 0.059562 s/f, max 21.024 MB/s@ 10579 pg/f 1.965649 s/f NEARSYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 45.188 MB/s@ 10579 pg/f 0.914514 s/f ASYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 45.188 MB/s@ 10579 pg/f 0.914514 s/f 2014-12-07 02:29:45 0.000 MB/s, 126 sec, 3.0 pg/f, 126.000000 sec/f, 1.3 pg/tr, 3.000000 sec/tr, 126.000000 sec/cmt, nOpenTrans 9.5 actual 0.000 MB/s@ 3 pg/f 126.000000 s/f SYNC 0.196 MB/s@ 3 pg/f 0.059797 s/f, min 0.196 MB/s@ 3 pg/f 0.059797 s/f, max 0.785 MB/s@ 12 pg/f 0.061481 s/f NEARSYNC 0.393 MB/s@ 3 pg/f 0.029825 s/f, min 0.393 MB/s@ 3 pg/f 0.029825 s/f, max 1.576 MB/s@ 12 pg/f 0.030607 s/f ASYNC 0.393 MB/s@ 3 pg/f 0.029825 s/f, min 0.393 MB/s@ 3 pg/f 0.029825 s/f, max 1.576 MB/s@ 12 pg/f 0.030607 s/f 2014-12-07 02:31:10 0.003 MB/s, 85 sec, 1.7 pg/f, 1.976744 sec/f, 73.1 pg/tr, 208.000000 sec/tr, 85.000000 sec/cmt, nOpenTrans 9.5 actual 0.003 MB/s@ 1 pg/f 1.976744 s/f SYNC 0.111 MB/s@ 1 pg/f 0.059562 s/f, min 0.111 MB/s@ 1 pg/f 0.059562 s/f, max 14.711 MB/s@ 694 pg/f 0.184397 s/f NEARSYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 30.944 MB/s@ 694 pg/f 0.087664 s/f ASYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 30.944 MB/s@ 694 pg/f 0.087664 s/f 2014-12-07 02:32:54 0.001 MB/s, 104 sec, 1.3 pg/f, 5.777778 sec/f, 3.9 pg/tr, 4.166667 sec/tr, 17.333333 sec/cmt, nOpenTrans 11.0 actual 0.001 MB/s@ 1 pg/f 5.777778 s/f SYNC 0.085 MB/s@ 1 pg/f 0.059490 s/f, min 0.085 MB/s@ 1 pg/f 0.059490 s/f, max 2.502 MB/s@ 42 pg/f 0.066987 s/f NEARSYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 5.053 MB/s@ 42 pg/f 0.033163 s/f ASYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 5.053 MB/s@ 42 pg/f 0.033163 s/f 2014-12-07 02:35:38 0.001 MB/s, 164 sec, 1.4 pg/f, 4.555556 sec/f, 6.3 pg/tr, 5.000000 sec/tr, 20.500000 sec/cmt, nOpenTrans 15.8 actual 0.001 MB/s@ 1 pg/f 4.555556 s/f SYNC 0.092 MB/s@ 1 pg/f 0.059508 s/f, min 0.092 MB/s@ 1 pg/f 0.059508 s/f, max 5.037 MB/s@ 99 pg/f 0.077193 s/f NEARSYNC 0.184 MB/s@ 1 pg/f 0.029691 s/f, min 0.184 MB/s@ 1 pg/f 0.029691 s/f, max 10.259 MB/s@ 99 pg/f 0.037900 s/f ASYNC 0.184 MB/s@ 1 pg/f 0.029691 s/f, min 0.184 MB/s@ 1 pg/f 0.029691 s/f, max 10.259 MB/s@ 99 pg/f 0.037900 s/f 2014-12-07 02:36:40 0.002 MB/s, 62 sec, 1.5 pg/f, 3.647059 sec/f, 6.2 pg/tr, 7.250000 sec/tr, 15.500000 sec/cmt, nOpenTrans 20.7 actual 0.002 MB/s@ 1 pg/f 3.647059 s/f SYNC 0.098 MB/s@ 1 pg/f 0.059526 s/f, min 0.098 MB/s@ 1 pg/f 0.059526 s/f, max 6.085 MB/s@ 128 pg/f 0.082383 s/f NEARSYNC 0.197 MB/s@ 1 pg/f 0.029699 s/f, min 0.197 MB/s@ 1 pg/f 0.029699 s/f, max 12.437 MB/s@ 128 pg/f 0.040310 s/f ASYNC 0.197 MB/s@ 1 pg/f 0.029699 s/f, min 0.197 MB/s@ 1 pg/f 0.029699 s/f, max 12.437 MB/s@ 128 pg/f 0.040310 s/f 2014-12-07 02:39:25 0.004 MB/s, 165 sec, 2.0 pg/f, 2.037037 sec/f, 13.4 pg/tr, 3.750000 sec/tr, 13.750000 sec/cmt, nOpenTrans 24.4 actual 0.004 MB/s@ 2 pg/f 2.037037 s/f SYNC 0.131 MB/s@ 2 pg/f 0.059616 s/f, min 0.131 MB/s@ 2 pg/f 0.059616 s/f, max 10.808 MB/s@ 326 pg/f 0.118175 s/f NEARSYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 22.437 MB/s@ 326 pg/f 0.056924 s/f ASYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 22.437 MB/s@ 326 pg/f 0.056924 s/f 2014-12-07 02:40:40 0.001 MB/s, 75 sec, 1.6 pg/f, 5.357143 sec/f, 3.8 pg/tr, 2.166667 sec/tr, 12.500000 sec/cmt, nOpenTrans 31.0 actual 0.001 MB/s@ 1 pg/f 5.357143 s/f SYNC 0.105 MB/s@ 1 pg/f 0.059544 s/f, min 0.105 MB/s@ 1 pg/f 0.059544 s/f, max 5.717 MB/s@ 117 pg/f 0.080484 s/f NEARSYNC 0.210 MB/s@ 1 pg/f 0.029708 s/f, min 0.210 MB/s@ 1 pg/f 0.029708 s/f, max 11.671 MB/s@ 117 pg/f 0.039428 s/f ASYNC 0.210 MB/s@ 1 pg/f 0.029708 s/f, min 0.210 MB/s@ 1 pg/f 0.029708 s/f, max 11.671 MB/s@ 117 pg/f 0.039428 s/f 2014-12-07 02:43:11 0.001 MB/s, 151 sec, 1.7 pg/f, 11.615385 sec/f, 2.2 pg/tr, 2.900000 sec/tr, 15.100000 sec/cmt, nOpenTrans 36.9 actual 0.001 MB/s@ 1 pg/f 11.615385 s/f SYNC 0.111 MB/s@ 1 pg/f 0.059562 s/f, min 0.111 MB/s@ 1 pg/f 0.059562 s/f, max 4.292 MB/s@ 81 pg/f 0.073885 s/f NEARSYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 8.720 MB/s@ 81 pg/f 0.036365 s/f ASYNC 0.223 MB/s@ 1 pg/f 0.029716 s/f, min 0.223 MB/s@ 1 pg/f 0.029716 s/f, max 8.720 MB/s@ 81 pg/f 0.036365 s/f 2014-12-07 02:44:14 0.072 MB/s, 63 sec, 5.5 pg/f, 0.295775 sec/f, 128.3 pg/tr, 5.777778 sec/tr, 7.000000 sec/cmt, nOpenTrans 41.5 actual 0.072 MB/s@ 5 pg/f 0.295775 s/f SYNC 0.357 MB/s@ 5 pg/f 0.060247 s/f, min 0.357 MB/s@ 5 pg/f 0.060247 s/f, max 20.416 MB/s@ 5324 pg/f 1.018733 s/f NEARSYNC 0.715 MB/s@ 5 pg/f 0.030034 s/f, min 0.715 MB/s@ 5 pg/f 0.030034 s/f, max 43.790 MB/s@ 5324 pg/f 0.474959 s/f ASYNC 0.715 MB/s@ 5 pg/f 0.030034 s/f, min 0.715 MB/s@ 5 pg/f 0.030034 s/f, max 43.790 MB/s@ 5324 pg/f 0.474959 s/f 2014-12-07 02:45:21 0.001 MB/s, 67 sec, 1.2 pg/f, 4.187500 sec/f, 3.4 pg/tr, 8.333333 sec/tr, 11.166667 sec/cmt, nOpenTrans 42.2 actual 0.001 MB/s@ 1 pg/f 4.187500 s/f SYNC 0.079 MB/s@ 1 pg/f 0.059472 s/f, min 0.079 MB/s@ 1 pg/f 0.059472 s/f, max 6.585 MB/s@ 143 pg/f 0.085111 s/f NEARSYNC 0.158 MB/s@ 1 pg/f 0.029674 s/f, min 0.158 MB/s@ 1 pg/f 0.029674 s/f, max 13.481 MB/s@ 143 pg/f 0.041576 s/f ASYNC 0.158 MB/s@ 1 pg/f 0.029674 s/f, min 0.158 MB/s@ 1 pg/f 0.029674 s/f, max 13.481 MB/s@ 143 pg/f 0.041576 s/f 2014-12-07 02:46:24 0.002 MB/s, 63 sec, 1.4 pg/f, 3.315789 sec/f, 5.4 pg/tr, 12.600000 sec/tr, 12.600000 sec/cmt, nOpenTrans 43.4 actual 0.002 MB/s@ 1 pg/f 3.315789 s/f SYNC 0.092 MB/s@ 1 pg/f 0.059508 s/f, min 0.092 MB/s@ 1 pg/f 0.059508 s/f, max 9.020 MB/s@ 234 pg/f 0.101488 s/f NEARSYNC 0.184 MB/s@ 1 pg/f 0.029691 s/f, min 0.184 MB/s@ 1 pg/f 0.029691 s/f, max 18.615 MB/s@ 234 pg/f 0.049178 s/f ASYNC 0.184 MB/s@ 1 pg/f 0.029691 s/f, min 0.184 MB/s@ 1 pg/f 0.029691 s/f, max 18.615 MB/s@ 234 pg/f 0.049178 s/f 2014-12-07 02:47:31 0.002 MB/s, 67 sec, 1.2 pg/f, 3.190476 sec/f, 3.5 pg/tr, 9.571429 sec/tr, 9.571429 sec/cmt, nOpenTrans 43.5 actual 0.002 MB/s@ 1 pg/f 3.190476 s/f SYNC 0.079 MB/s@ 1 pg/f 0.059472 s/f, min 0.079 MB/s@ 1 pg/f 0.059472 s/f, max 6.860 MB/s@ 152 pg/f 0.086692 s/f NEARSYNC 0.158 MB/s@ 1 pg/f 0.029674 s/f, min 0.158 MB/s@ 1 pg/f 0.029674 s/f, max 14.057 MB/s@ 152 pg/f 0.042310 s/f ASYNC 0.158 MB/s@ 1 pg/f 0.029674 s/f, min 0.158 MB/s@ 1 pg/f 0.029674 s/f, max 14.057 MB/s@ 152 pg/f 0.042310 s/f 2014-12-07 02:48:41 0.005 MB/s, 70 sec, 2.3 pg/f, 1.707317 sec/f, 7.8 pg/tr, 5.833333 sec/tr, 5.833333 sec/cmt, nOpenTrans 43.5 actual 0.005 MB/s@ 2 pg/f 1.707317 s/f SYNC 0.151 MB/s@ 2 pg/f 0.059670 s/f, min 0.151 MB/s@ 2 pg/f 0.059670 s/f, max 11.008 MB/s@ 339 pg/f 0.120399 s/f NEARSYNC 0.302 MB/s@ 2 pg/f 0.029766 s/f, min 0.302 MB/s@ 2 pg/f 0.029766 s/f, max 22.869 MB/s@ 339 pg/f 0.057956 s/f ASYNC 0.302 MB/s@ 2 pg/f 0.029766 s/f, min 0.302 MB/s@ 2 pg/f 0.029766 s/f, max 22.869 MB/s@ 339 pg/f 0.057956 s/f 2014-12-07 02:49:42 0.001 MB/s, 61 sec, 1.1 pg/f, 7.625000 sec/f, 2.2 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 7.625000 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 4.878 MB/s@ 95 pg/f 0.076462 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 9.930 MB/s@ 95 pg/f 0.037561 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 9.930 MB/s@ 95 pg/f 0.037561 s/f 2014-12-07 02:50:46 0.001 MB/s, 64 sec, 1.2 pg/f, 5.333333 sec/f, 2.5 pg/tr, 12.800000 sec/tr, 12.800000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 5.333333 s/f SYNC 0.079 MB/s@ 1 pg/f 0.059472 s/f, min 0.079 MB/s@ 1 pg/f 0.059472 s/f, max 5.387 MB/s@ 108 pg/f 0.078853 s/f NEARSYNC 0.158 MB/s@ 1 pg/f 0.029674 s/f, min 0.158 MB/s@ 1 pg/f 0.029674 s/f, max 10.985 MB/s@ 108 pg/f 0.038671 s/f ASYNC 0.158 MB/s@ 1 pg/f 0.029674 s/f, min 0.158 MB/s@ 1 pg/f 0.029674 s/f, max 10.985 MB/s@ 108 pg/f 0.038671 s/f 2014-12-07 02:51:47 0.001 MB/s, 61 sec, 1.1 pg/f, 7.625000 sec/f, 2.0 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 7.625000 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 4.527 MB/s@ 86 pg/f 0.074898 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 9.205 MB/s@ 86 pg/f 0.036835 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 9.205 MB/s@ 86 pg/f 0.036835 s/f 2014-12-07 02:52:52 0.001 MB/s, 65 sec, 1.1 pg/f, 7.222222 sec/f, 1.8 pg/tr, 13.000000 sec/tr, 13.000000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 7.222222 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 4.169 MB/s@ 78 pg/f 0.073366 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.467 MB/s@ 78 pg/f 0.036124 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.467 MB/s@ 78 pg/f 0.036124 s/f 2014-12-07 02:53:53 0.001 MB/s, 61 sec, 1.1 pg/f, 7.625000 sec/f, 2.0 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 7.625000 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 4.527 MB/s@ 86 pg/f 0.074898 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 9.205 MB/s@ 86 pg/f 0.036835 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 9.205 MB/s@ 86 pg/f 0.036835 s/f 2014-12-07 02:54:57 0.001 MB/s, 64 sec, 1.1 pg/f, 7.111111 sec/f, 1.8 pg/tr, 12.800000 sec/tr, 12.800000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 7.111111 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 4.169 MB/s@ 78 pg/f 0.073366 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.467 MB/s@ 78 pg/f 0.036124 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.467 MB/s@ 78 pg/f 0.036124 s/f 2014-12-07 02:55:58 0.001 MB/s, 61 sec, 1.3 pg/f, 8.714286 sec/f, 2.0 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 8.714286 s/f SYNC 0.085 MB/s@ 1 pg/f 0.059490 s/f, min 0.085 MB/s@ 1 pg/f 0.059490 s/f, max 4.527 MB/s@ 86 pg/f 0.074898 s/f NEARSYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 9.205 MB/s@ 86 pg/f 0.036835 s/f ASYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 9.205 MB/s@ 86 pg/f 0.036835 s/f 2014-12-07 02:56:58 0.001 MB/s, 60 sec, 1.1 pg/f, 4.000000 sec/f, 1.7 pg/tr, 6.666667 sec/tr, 6.666667 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 4.000000 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 3.980 MB/s@ 73 pg/f 0.072582 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.078 MB/s@ 73 pg/f 0.035760 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.078 MB/s@ 73 pg/f 0.035760 s/f 2014-12-07 02:58:01 0.001 MB/s, 63 sec, 1.1 pg/f, 3.315789 sec/f, 1.8 pg/tr, 5.250000 sec/tr, 5.250000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 3.315789 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 4.169 MB/s@ 78 pg/f 0.073366 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.467 MB/s@ 78 pg/f 0.036124 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 8.467 MB/s@ 78 pg/f 0.036124 s/f 2014-12-07 03:39:16 0.000 MB/s, 2475 sec, 2.0 pg/f, 2475.000000 sec/f, 0.8 pg/tr, 3.666667 sec/tr, 825.000000 sec/cmt, nOpenTrans 44.2 actual 0.000 MB/s@ 2 pg/f 2475.000000 s/f SYNC 0.131 MB/s@ 2 pg/f 0.059616 s/f, min 0.131 MB/s@ 2 pg/f 0.059616 s/f, max 2.105 MB/s@ 35 pg/f 0.065628 s/f NEARSYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 4.246 MB/s@ 35 pg/f 0.032532 s/f ASYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 4.246 MB/s@ 35 pg/f 0.032532 s/f 2014-12-07 03:55:10 0.016 MB/s, 954 sec, 1.4 pg/f, 0.339502 sec/f, 1973.7 pg/tr, 477.000000 sec/tr, 477.000000 sec/cmt, nOpenTrans 45.3 actual 0.016 MB/s@ 1 pg/f 0.339502 s/f SYNC 0.092 MB/s@ 1 pg/f 0.059508 s/f, min 0.092 MB/s@ 1 pg/f 0.059508 s/f, max 21.598 MB/s@ 89408 pg/f 16.170870 s/f NEARSYNC 0.184 MB/s@ 1 pg/f 0.029691 s/f, min 0.184 MB/s@ 1 pg/f 0.029691 s/f, max 46.514 MB/s@ 89408 pg/f 7.508522 s/f ASYNC 0.184 MB/s@ 1 pg/f 0.029691 s/f, min 0.184 MB/s@ 1 pg/f 0.029691 s/f, max 46.514 MB/s@ 89408 pg/f 7.508522 s/f 2014-12-07 04:21:16 0.000 MB/s, 1566 sec, 2.0 pg/f, 1566.000000 sec/f, 0.0 pg/tr, 0.000000 sec/tr, 156.600000 sec/cmt, nOpenTrans 50.4 actual 0.000 MB/s@ 2 pg/f 1566.000000 s/f SYNC 0.131 MB/s@ 2 pg/f 0.059616 s/f, min 0.131 MB/s@ 2 pg/f 0.059616 s/f, max 0.131 MB/s@ 2 pg/f 0.059616 s/f NEARSYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 0.263 MB/s@ 2 pg/f 0.029741 s/f ASYNC 0.263 MB/s@ 2 pg/f 0.029741 s/f, min 0.263 MB/s@ 2 pg/f 0.029741 s/f, max 0.263 MB/s@ 2 pg/f 0.029741 s/f 2014-12-07 04:22:17 0.172 MB/s, 61 sec, 3.2 pg/f, 0.072792 sec/f, 668.7 pg/tr, 14.750000 sec/tr, 15.250000 sec/cmt, nOpenTrans 55.9 actual 0.172 MB/s@ 3 pg/f 0.072792 s/f SYNC 0.209 MB/s@ 3 pg/f 0.059833 s/f, min 0.209 MB/s@ 3 pg/f 0.059833 s/f, max 21.488 MB/s@ 37380 pg/f 6.795268 s/f NEARSYNC 0.419 MB/s@ 3 pg/f 0.029842 s/f, min 0.419 MB/s@ 3 pg/f 0.029842 s/f, max 46.261 MB/s@ 37380 pg/f 3.156404 s/f ASYNC 0.419 MB/s@ 3 pg/f 0.029842 s/f, min 0.419 MB/s@ 3 pg/f 0.029842 s/f, max 46.261 MB/s@ 37380 pg/f 3.156404 s/f 2014-12-07 04:28:35 0.000 MB/s, 378 sec, 3.7 pg/f, 63.000000 sec/f, 1.4 pg/tr, 0.062500 sec/tr, 23.625000 sec/cmt, nOpenTrans 62.1 actual 0.000 MB/s@ 3 pg/f 63.000000 s/f SYNC 0.241 MB/s@ 3 pg/f 0.059923 s/f, min 0.241 MB/s@ 3 pg/f 0.059923 s/f, max 4.533 MB/s@ 86 pg/f 0.074923 s/f NEARSYNC 0.484 MB/s@ 3 pg/f 0.029884 s/f, min 0.484 MB/s@ 3 pg/f 0.029884 s/f, max 9.217 MB/s@ 86 pg/f 0.036846 s/f ASYNC 0.484 MB/s@ 3 pg/f 0.029884 s/f, min 0.484 MB/s@ 3 pg/f 0.029884 s/f, max 9.217 MB/s@ 86 pg/f 0.036846 s/f 2014-12-07 04:30:49 0.002 MB/s, 134 sec, 1.3 pg/f, 2.851064 sec/f, 7.9 pg/tr, 4.625000 sec/tr, 16.750000 sec/cmt, nOpenTrans 72.0 actual 0.002 MB/s@ 1 pg/f 2.851064 s/f SYNC 0.085 MB/s@ 1 pg/f 0.059490 s/f, min 0.085 MB/s@ 1 pg/f 0.059490 s/f, max 13.736 MB/s@ 568 pg/f 0.161755 s/f NEARSYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 28.798 MB/s@ 568 pg/f 0.077154 s/f ASYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 28.798 MB/s@ 568 pg/f 0.077154 s/f 2014-12-07 04:32:04 0.094 MB/s, 75 sec, 2.3 pg/f, 0.095299 sec/f, 255.9 pg/tr, 8.000000 sec/tr, 10.714286 sec/cmt, nOpenTrans 76.1 actual 0.094 MB/s@ 2 pg/f 0.095299 s/f SYNC 0.151 MB/s@ 2 pg/f 0.059670 s/f, min 0.151 MB/s@ 2 pg/f 0.059670 s/f, max 21.317 MB/s@ 19473 pg/f 3.568509 s/f NEARSYNC 0.302 MB/s@ 2 pg/f 0.029766 s/f, min 0.302 MB/s@ 2 pg/f 0.029766 s/f, max 45.865 MB/s@ 19473 pg/f 1.658555 s/f ASYNC 0.302 MB/s@ 2 pg/f 0.029766 s/f, min 0.302 MB/s@ 2 pg/f 0.029766 s/f, max 45.865 MB/s@ 19473 pg/f 1.658555 s/f 2014-12-07 04:33:59 0.055 MB/s, 115 sec, 2.8 pg/f, 0.200348 sec/f, 108.0 pg/tr, 3.200000 sec/tr, 7.666667 sec/cmt, nOpenTrans 83.0 actual 0.055 MB/s@ 2 pg/f 0.200348 s/f SYNC 0.183 MB/s@ 2 pg/f 0.059761 s/f, min 0.183 MB/s@ 2 pg/f 0.059761 s/f, max 20.910 MB/s@ 8964 pg/f 1.674587 s/f NEARSYNC 0.367 MB/s@ 2 pg/f 0.029808 s/f, min 0.367 MB/s@ 2 pg/f 0.029808 s/f, max 44.926 MB/s@ 8964 pg/f 0.779404 s/f ASYNC 0.367 MB/s@ 2 pg/f 0.029808 s/f, min 0.367 MB/s@ 2 pg/f 0.029808 s/f, max 44.926 MB/s@ 8964 pg/f 0.779404 s/f 2014-12-07 04:34:59 0.004 MB/s, 60 sec, 1.3 pg/f, 1.395349 sec/f, 2.6 pg/tr, 0.714286 sec/tr, 2.857143 sec/cmt, nOpenTrans 96.0 actual 0.004 MB/s@ 1 pg/f 1.395349 s/f SYNC 0.085 MB/s@ 1 pg/f 0.059490 s/f, min 0.085 MB/s@ 1 pg/f 0.059490 s/f, max 9.354 MB/s@ 249 pg/f 0.104234 s/f NEARSYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 19.325 MB/s@ 249 pg/f 0.050453 s/f ASYNC 0.171 MB/s@ 1 pg/f 0.029683 s/f, min 0.171 MB/s@ 1 pg/f 0.029683 s/f, max 19.325 MB/s@ 249 pg/f 0.050453 s/f 2014-12-07 04:35:59 0.022 MB/s, 60 sec, 2.1 pg/f, 0.384615 sec/f, 8.1 pg/tr, 0.707317 sec/tr, 1.463415 sec/cmt, nOpenTrans 114.0 actual 0.022 MB/s@ 2 pg/f 0.384615 s/f SYNC 0.138 MB/s@ 2 pg/f 0.059634 s/f, min 0.138 MB/s@ 2 pg/f 0.059634 s/f, max 15.985 MB/s@ 923 pg/f 0.225655 s/f NEARSYNC 0.276 MB/s@ 2 pg/f 0.029750 s/f, min 0.276 MB/s@ 2 pg/f 0.029750 s/f, max 33.769 MB/s@ 923 pg/f 0.106816 s/f ASYNC 0.276 MB/s@ 2 pg/f 0.029750 s/f, min 0.276 MB/s@ 2 pg/f 0.029750 s/f, max 33.769 MB/s@ 923 pg/f 0.106816 s/f 2014-12-07 04:48:34 0.001 MB/s, 755 sec, 1.1 pg/f, 7.550000 sec/f, 1.4 pg/tr, 9.271605 sec/tr, 9.320988 sec/cmt, nOpenTrans 120.6 actual 0.001 MB/s@ 1 pg/f 7.550000 s/f SYNC 0.072 MB/s@ 1 pg/f 0.059454 s/f, min 0.072 MB/s@ 1 pg/f 0.059454 s/f, max 7.354 MB/s@ 168 pg/f 0.089681 s/f NEARSYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 15.093 MB/s@ 168 pg/f 0.043697 s/f ASYNC 0.145 MB/s@ 1 pg/f 0.029666 s/f, min 0.145 MB/s@ 1 pg/f 0.029666 s/f, max 15.093 MB/s@ 168 pg/f 0.043697 s/f 2014-12-07 04:49:36 0.000 MB/s, 62 sec, 1.0 pg/f, 62.000000 sec/f, 0.0 pg/tr, 2.480000 sec/tr, 2.480000 sec/cmt, nOpenTrans 121.5 actual 0.000 MB/s@ 1 pg/f 62.000000 s/f SYNC 0.066 MB/s@ 1 pg/f 0.059436 s/f, min 0.066 MB/s@ 1 pg/f 0.059436 s/f, max 0.066 MB/s@ 1 pg/f 0.059436 s/f NEARSYNC 0.132 MB/s@ 1 pg/f 0.029658 s/f, min 0.132 MB/s@ 1 pg/f 0.029658 s/f, max 0.132 MB/s@ 1 pg/f 0.029658 s/f ASYNC 0.132 MB/s@ 1 pg/f 0.029658 s/f, min 0.132 MB/s@ 1 pg/f 0.029658 s/f, max 0.132 MB/s@ 1 pg/f 0.029658 s/f 2014-12-07 04:50:41 0.000 MB/s, 65 sec, 1.0 pg/f, 32.500000 sec/f, 0.0 pg/tr, 1.225806 sec/tr, 2.096774 sec/cmt, nOpenTrans 121.5 actual 0.000 MB/s@ 1 pg/f 32.500000 s/f SYNC 0.066 MB/s@ 1 pg/f 0.059436 s/f, min 0.066 MB/s@ 1 pg/f 0.059436 s/f, max 0.066 MB/s@ 1 pg/f 0.059436 s/f NEARSYNC 0.132 MB/s@ 1 pg/f 0.029658 s/f, min 0.132 MB/s@ 1 pg/f 0.029658 s/f, max 0.132 MB/s@ 1 pg/f 0.029658 s/f ASYNC 0.132 MB/s@ 1 pg/f 0.029658 s/f, min 0.132 MB/s@ 1 pg/f 0.029658 s/f, max 0.132 MB/s@ 1 pg/f 0.029658 s/f 2014-12-07 05:34:32 0.000 MB/s, 2631 sec, 1.0 pg/f, 2631.000000 sec/f, 1.3 pg/tr, 2631.000000 sec/tr, 2631.000000 sec/cmt, nOpenTrans 121.5 actual 0.000 MB/s@ 1 pg/f 2631.000000 s/f SYNC 0.066 MB/s@ 1 pg/f 0.059436 s/f, min 0.066 MB/s@ 1 pg/f 0.059436 s/f, max 7.034 MB/s@ 157 pg/f 0.087719 s/f NEARSYNC 0.132 MB/s@ 1 pg/f 0.029658 s/f, min 0.132 MB/s@ 1 pg/f 0.029658 s/f, max 14.420 MB/s@ 157 pg/f 0.042786 s/f ASYNC 0.132 MB/s@ 1 pg/f 0.029658 s/f, min 0.132 MB/s@ 1 pg/f 0.029658 s/f, max 14.420 MB/s@ 157 pg/f 0.042786 s/f 2014-12-07 08:03:58 0.000 MB/s, 8966 sec, 2.4 pg/f, 144.612903 sec/f, 37.6 pg/tr, 2.750000 sec/tr, 2241.500000 sec/cmt, nOpenTrans 122.1 actual 0.000 MB/s@ 2 pg/f 144.612903 s/f SYNC 0.157 MB/s@ 2 pg/f 0.059688 s/f, min 0.157 MB/s@ 2 pg/f 0.059688 s/f, max 20.228 MB/s@ 4590 pg/f 0.886556 s/f NEARSYNC 0.315 MB/s@ 2 pg/f 0.029775 s/f, min 0.315 MB/s@ 2 pg/f 0.029775 s/f, max 43.359 MB/s@ 4590 pg/f 0.413604 s/f ASYNC 0.315 MB/s@ 2 pg/f 0.029775 s/f, min 0.315 MB/s@ 2 pg/f 0.029775 s/f, max 43.359 MB/s@ 4590 pg/f 0.413604 s/f 2014-12-07 08:22:14 0.000 MB/s, 1096 sec, 13.0 pg/f, 1096.000000 sec/f, 13.1 pg/tr, 1096.000000 sec/tr, 1096.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 13 pg/f 1096.000000 s/f SYNC 0.824 MB/s@ 13 pg/f 0.061599 s/f, min 0.824 MB/s@ 13 pg/f 0.061599 s/f, max 18.015 MB/s@ 1617 pg/f 0.350796 s/f NEARSYNC 1.656 MB/s@ 13 pg/f 0.030661 s/f, min 1.656 MB/s@ 13 pg/f 0.030661 s/f, max 38.323 MB/s@ 1617 pg/f 0.164906 s/f ASYNC 1.656 MB/s@ 13 pg/f 0.030661 s/f, min 1.656 MB/s@ 13 pg/f 0.030661 s/f, max 38.323 MB/s@ 1617 pg/f 0.164906 s/f 2014-12-07 11:22:14 0.000 MB/s, 10800 sec, 5.8 pg/f, 1800.000000 sec/f, 8.8 pg/tr, 2700.000000 sec/tr, 2700.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 5 pg/f 1800.000000 s/f SYNC 0.376 MB/s@ 5 pg/f 0.060301 s/f, min 0.376 MB/s@ 5 pg/f 0.060301 s/f, max 16.642 MB/s@ 1086 pg/f 0.255100 s/f NEARSYNC 0.754 MB/s@ 5 pg/f 0.030059 s/f, min 0.754 MB/s@ 5 pg/f 0.030059 s/f, max 35.236 MB/s@ 1086 pg/f 0.120484 s/f ASYNC 0.754 MB/s@ 5 pg/f 0.030059 s/f, min 0.754 MB/s@ 5 pg/f 0.030059 s/f, max 35.236 MB/s@ 1086 pg/f 0.120484 s/f 2014-12-07 14:22:14 0.000 MB/s, 10800 sec, 9.0 pg/f, 2700.000000 sec/f, 8.8 pg/tr, 2700.000000 sec/tr, 2700.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 9 pg/f 2700.000000 s/f SYNC 0.577 MB/s@ 9 pg/f 0.060878 s/f, min 0.577 MB/s@ 9 pg/f 0.060878 s/f, max 16.642 MB/s@ 1086 pg/f 0.255100 s/f NEARSYNC 1.159 MB/s@ 9 pg/f 0.030327 s/f, min 1.159 MB/s@ 9 pg/f 0.030327 s/f, max 35.236 MB/s@ 1086 pg/f 0.120484 s/f ASYNC 1.159 MB/s@ 9 pg/f 0.030327 s/f, min 1.159 MB/s@ 9 pg/f 0.030327 s/f, max 35.236 MB/s@ 1086 pg/f 0.120484 s/f 2014-12-07 17:22:14 0.000 MB/s, 10800 sec, 5.8 pg/f, 1800.000000 sec/f, 8.8 pg/tr, 2700.000000 sec/tr, 2700.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 5 pg/f 1800.000000 s/f SYNC 0.376 MB/s@ 5 pg/f 0.060301 s/f, min 0.376 MB/s@ 5 pg/f 0.060301 s/f, max 16.642 MB/s@ 1086 pg/f 0.255100 s/f NEARSYNC 0.754 MB/s@ 5 pg/f 0.030059 s/f, min 0.754 MB/s@ 5 pg/f 0.030059 s/f, max 35.236 MB/s@ 1086 pg/f 0.120484 s/f ASYNC 0.754 MB/s@ 5 pg/f 0.030059 s/f, min 0.754 MB/s@ 5 pg/f 0.030059 s/f, max 35.236 MB/s@ 1086 pg/f 0.120484 s/f Page 18038 and 18039 are ping/pong pages (indicating end of file). Ping pageLso=1285818112367 byteCount=2404, Pong pageLso=1285818112531 byteCount=2568 File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000001.LOG" Page 1 is an old page. pageLso 1281654788091 not in expected range of 1285849083904 and 1285849092096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000002.LOG" Page 1 is an old page. pageLso 1281759645691 not in expected range of 1285953941504 and 1285953949696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000003.LOG" Page 1 is an old page. pageLso 1281864503291 not in expected range of 1286058799104 and 1286058807296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000004.LOG" Page 1 is an old page. pageLso 1281969360891 not in expected range of 1286163656704 and 1286163664896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000005.LOG" Page 1 is an old page. pageLso 1282074218491 not in expected range of 1286268514304 and 1286268522496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000006.LOG" Page 1 is an old page. pageLso 1282179076091 not in expected range of 1286373371904 and 1286373380096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000007.LOG" Page 1 is an old page. pageLso 1282283933691 not in expected range of 1286478229504 and 1286478237696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000008.LOG" Page 1 is an old page. pageLso 1282388791291 not in expected range of 1286583087104 and 1286583095296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000009.LOG" Page 1 is an old page. pageLso 1282493648891 not in expected range of 1286687944704 and 1286687952896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000010.LOG" Page 1 is an old page. pageLso 1282598506491 not in expected range of 1286792802304 and 1286792810496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000011.LOG" Page 1 is an old page. pageLso 1282703364091 not in expected range of 1286897659904 and 1286897668096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000012.LOG" Page 1 is an old page. pageLso 1282808221691 not in expected range of 1287002517504 and 1287002525696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000013.LOG" Page 1 is an old page. pageLso 1282913079291 not in expected range of 1287107375104 and 1287107383296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000014.LOG" Page 1 is an old page. pageLso 1283017936891 not in expected range of 1287212232704 and 1287212240896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000015.LOG" Page 1 is an old page. pageLso 1283122794491 not in expected range of 1287317090304 and 1287317098496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000016.LOG" Page 1 is an old page. pageLso 1283227652091 not in expected range of 1287421947904 and 1287421956096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000017.LOG" Page 1 is an old page. pageLso 1283332509691 not in expected range of 1287526805504 and 1287526813696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000018.LOG" Page 1 is an old page. pageLso 1283437367291 not in expected range of 1287631663104 and 1287631671296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000019.LOG" Page 1 is an old page. pageLso 1283542224891 not in expected range of 1287736520704 and 1287736528896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000020.LOG" Page 1 is an old page. pageLso 1283647082491 not in expected range of 1287841378304 and 1287841386496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000021.LOG" Page 1 is an old page. pageLso 1283751940091 not in expected range of 1287946235904 and 1287946244096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000022.LOG" Page 1 is an old page. pageLso 1283856797691 not in expected range of 1288051093504 and 1288051101696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000023.LOG" Page 1 is an old page. pageLso 1283961655291 not in expected range of 1288155951104 and 1288155959296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000024.LOG" Page 1 is an old page. pageLso 1284066512891 not in expected range of 1288260808704 and 1288260816896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000025.LOG" Page 1 is an old page. pageLso 1284171370491 not in expected range of 1288365666304 and 1288365674496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000026.LOG" Page 1 is an old page. pageLso 1284276228091 not in expected range of 1288470523904 and 1288470532096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000027.LOG" Page 1 is an old page. pageLso 1284381085691 not in expected range of 1288575381504 and 1288575389696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000028.LOG" Page 1 is an old page. pageLso 1284485943291 not in expected range of 1288680239104 and 1288680247296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000029.LOG" Page 1 is an old page. pageLso 1284590800891 not in expected range of 1288785096704 and 1288785104896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000030.LOG" Page 1 is an old page. pageLso 1284695658491 not in expected range of 1288889954304 and 1288889962496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000031.LOG" Page 1 is an old page. pageLso 1284800516091 not in expected range of 1288994811904 and 1288994820096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000032.LOG" Page 1 is an old page. pageLso 1284905373691 not in expected range of 1289099669504 and 1289099677696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000033.LOG" Page 1 is an old page. pageLso 1285010231291 not in expected range of 1289204527104 and 1289204535296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000034.LOG" Page 1 is an old page. pageLso 1285115088891 not in expected range of 1289309384704 and 1289309392896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000035.LOG" Page 1 is an old page. pageLso 1285219946491 not in expected range of 1289414242304 and 1289414250496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000036.LOG" Page 1 is an old page. pageLso 1285324804091 not in expected range of 1289519099904 and 1289519108096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000037.LOG" Page 1 is an old page. pageLso 1285429661691 not in expected range of 1289623957504 and 1289623965696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000038.LOG" Page 1 is an old page. pageLso 1285534519291 not in expected range of 1289728815104 and 1289728823296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000039.LOG" Page 1 is an old page. pageLso 1285639376891 not in expected range of 1289833672704 and 1289833680896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000040.LOG" Page 1 is an old page. pageLso 1275992477691 not in expected range of 1289938530304 and 1289938538496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000041.LOG" Page 1 is an old page. pageLso 1276097335291 not in expected range of 1290043387904 and 1290043396096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000042.LOG" Page 1 is an old page. pageLso 1276202192891 not in expected range of 1290148245504 and 1290148253696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000043.LOG" Page 1 is an old page. pageLso 1276307050491 not in expected range of 1290253103104 and 1290253111296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000044.LOG" Page 1 is an old page. pageLso 1276411908091 not in expected range of 1290357960704 and 1290357968896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000045.LOG" Page 1 is an old page. pageLso 1276516765691 not in expected range of 1290462818304 and 1290462826496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000046.LOG" Page 1 is an old page. pageLso 1276621623291 not in expected range of 1290567675904 and 1290567684096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000047.LOG" Page 1 is an old page. pageLso 1276726480891 not in expected range of 1290672533504 and 1290672541696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000048.LOG" Page 1 is an old page. pageLso 1276831338491 not in expected range of 1290777391104 and 1290777399296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000049.LOG" Page 1 is an old page. pageLso 1276936196091 not in expected range of 1290882248704 and 1290882256896. Treating as end of file. 2014-12-07 17:22:15 0.090 MB/s, 1 sec, 3.8 pg/f, 0.166667 sec/f, 7.3 pg/tr, 0.333333 sec/tr, 0.333333 sec/cmt, nOpenTrans 123.4 actual 0.090 MB/s@ 3 pg/f 0.166667 s/f SYNC 0.248 MB/s@ 3 pg/f 0.059941 s/f, min 0.248 MB/s@ 3 pg/f 0.059941 s/f, max 15.880 MB/s@ 900 pg/f 0.221586 s/f NEARSYNC 0.497 MB/s@ 3 pg/f 0.029892 s/f, min 0.497 MB/s@ 3 pg/f 0.029892 s/f, max 33.536 MB/s@ 900 pg/f 0.104927 s/f ASYNC 0.497 MB/s@ 3 pg/f 0.029892 s/f, min 0.497 MB/s@ 3 pg/f 0.029892 s/f, max 33.536 MB/s@ 900 pg/f 0.104927 s/f transTable: nOpenTran=123 openTranSize=7176 nBuckets=1024 nAdds=569 nCollisions=34 collisionRate=5% Distribution of log write rate (unit is MB/s): Total 49 numbers, Sum 0.675, Min 0.000, Max 0.171, Avg 0.014 Average rate 0.014 MB/s REMOTE CATCHUP 2.022 MB/s@ 16 pg/f 0.030912 s/f Zero 24 numbers 48% From 0.001 to 0.001 9 numbers 18% From 0.002 to 0.003 3 numbers 6% From 0.004 to 0.007 3 numbers 6% From 0.016 to 0.031 3 numbers 6% From 0.032 to 0.063 2 numbers 4% From 0.064 to 0.127 4 numbers 8% From 0.128 to 0.255 1 numbers 2% Distribution of flush size (unit is page): Total 8790 numbers, Sum 18039, Min 1, Max 48, Avg 2.1 From 1 to 1 5967 numbers 67% From 2 to 3 2160 numbers 24% From 4 to 7 234 numbers 2% From 8 to 15 366 numbers 4% From 16 to 31 37 numbers 0% From 32 to 63 26 numbers 0% Distribution of flush duration (unit is second): Total 8790 numbers, Sum 54798, Min 0, Max 10800, Avg 6.234130 Zero 8513 numbers 96% From 1 to 1 113 numbers 1% From 2 to 3 14 numbers 0% From 4 to 7 27 numbers 0% From 8 to 15 79 numbers 0% From 16 to 31 10 numbers 0% From 32 to 63 10 numbers 0% From 64 to 127 9 numbers 0% From 128 to 255 4 numbers 0% From 256 to 511 1 numbers 0% From 512 to 1023 2 numbers 0% From 1024 to 2047 2 numbers 0% From 2048 to 4095 2 numbers 0% From 8192 to 16383 4 numbers 0% Distribution of record size (unit is byte): Total 1594876 numbers, Sum 73593528, Min 20, Max 81480, Avg 46 From 16 to 31 402646 numbers 25% From 32 to 63 1152299 numbers 72% From 64 to 127 20767 numbers 1% From 128 to 255 16369 numbers 1% From 256 to 511 1043 numbers 0% From 512 to 1023 136 numbers 0% From 1024 to 2047 441 numbers 0% From 2048 to 4095 764 numbers 0% From 4096 to 8191 376 numbers 0% From 8192 to 16383 34 numbers 0% From 65536 to 131071 1 numbers 0% Distribution of transaction size (unit is byte): Total 446 numbers, Sum 73586352, Min 51, Max 16163192, Avg 164992 From 32 to 63 122 numbers 27% From 128 to 255 77 numbers 17% From 4096 to 8191 113 numbers 25% From 8192 to 16383 59 numbers 13% From 16384 to 32767 21 numbers 4% From 32768 to 65535 21 numbers 4% From 65536 to 131071 10 numbers 2% From 131072 to 262143 7 numbers 1% From 262144 to 524287 4 numbers 0% From 524288 to 1048575 3 numbers 0% From 1048576 to 2097151 1 numbers 0% From 2097152 to 4194303 1 numbers 0% From 4194304 to 8388607 4 numbers 0% From 8388608 to 16777215 3 numbers 0% Distribution of transaction duration (unit is second): Total 446 numbers, Sum 40341, Min 0, Max 10800, Avg 90.450673 Zero 204 numbers 45% From 1 to 1 93 numbers 20% From 2 to 3 14 numbers 3% From 4 to 7 27 numbers 6% From 8 to 15 80 numbers 17% From 16 to 31 10 numbers 2% From 32 to 63 6 numbers 1% From 64 to 127 1 numbers 0% From 128 to 255 3 numbers 0% From 256 to 511 2 numbers 0% From 512 to 1023 1 numbers 0% From 1024 to 2047 1 numbers 0% From 2048 to 4095 1 numbers 0% From 8192 to 16383 3 numbers 0% Distribution of commit interval (unit is second): Total 49 numbers, Sum 16728.462360, Min 0.333333, Max 2700.000000, Avg 341.397191 From 0.262144 to 0.524287 1 numbers 2% From 1.048576 to 2.097151 2 numbers 4% From 2.097152 to 4.194303 2 numbers 4% From 4.194304 to 8.388607 5 numbers 10% From 8.388608 to 16.777215 18 numbers 36% From 16.777216 to 33.554431 4 numbers 8% From 33.554432 to 67.108863 1 numbers 2% From 67.108864 to 134.217727 6 numbers 12% From 134.217728 to 268.435455 2 numbers 4% From 268.435456 to 536.870911 1 numbers 2% From 536.870912 to 1073.741823 1 numbers 2% From 1073.741824 to 2147.483647 1 numbers 2% From 2147.483648 to 4294.967295 5 numbers 10% Distribution of number of open transactions: Total 1015 numbers, Sum 78514, Min 0, Max 124, Avg 77.4 Zero 1 numbers 0% From 1 to 1 3 numbers 0% From 2 to 3 4 numbers 0% From 4 to 7 28 numbers 2% From 8 to 15 40 numbers 3% From 16 to 31 64 numbers 6% From 32 to 63 304 numbers 29% From 64 to 127 571 numbers 56% 70.465 MB scanned in 0.482 seconds, scanning rate 146.077 MB/second SYNC Max flush size: predicted 13 pages, workload max 89408 pages NEARSYNC Max flush size: predicted 13 pages, workload max 89408 pages ASYNC Max flush size: predicted 13 pages, workload max 89408 pages
Now the output using my actual values isn’t actually all that useful because in the case of the database I’m analyzing, there would be no predicted slowdowns caused by HADR. So to show you what it looks like, here is the output if I mess with the input values some to the point it would cause problems:
$ ./hadrCalculator.pl -disk 3.6 0.003651 -network 2 0.1 db2logscan.bcudb.out hadrCalculator.pl: Network speed 2 MB/s, 0.1 second round trip time hadrCalculator.pl: Disk speed 3.6 MB/s, 0.003651 second overhead per write This machine is small endian. Environment variable TZ is not set. Timezone is PST/PDT, 8.0 hours west of GMT, has_daylight_rule=1 Current local time is 2014-12-07 17:45:34 Reading file list from "logfiles.list" File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000000.LOG" 2014-12-07 02:09:58 0.074 MB/s, 61 sec, 1.7 pg/f, 0.092564 sec/f, 163.8 pg/tr, 8.714286 sec/tr, 20.333333 sec/cmt, nOpenTrans 3.7 actual 0.074 MB/s@ 1 pg/f 0.092564 s/f SYNC ? 0.077 MB/s@ 2 pg/f 0.116745 s/f, min 0.058 MB/s@ 1 pg/f 0.114312 s/f, max 0.908 MB/s@ 606 pg/f 2.606247 s/f NEARSYNC ? 0.086 MB/s@ 2 pg/f 0.104473 s/f, min 0.064 MB/s@ 1 pg/f 0.103320 s/f, max 1.844 MB/s@ 606 pg/f 1.283711 s/f ASYNC 1.208 MB/s@ 1 pg/f 0.005496 s/f, min 1.208 MB/s@ 1 pg/f 0.005496 s/f, max 2.000 MB/s@ 606 pg/f 1.183711 s/f 2014-12-07 02:11:35 0.005 MB/s, 97 sec, 1.5 pg/f, 1.227848 sec/f, 57.5 pg/tr, 21.000000 sec/tr, 48.500000 sec/cmt, nOpenTrans 5.5 actual 0.005 MB/s@ 1 pg/f 1.227848 s/f SYNC 0.052 MB/s@ 1 pg/f 0.113487 s/f, min 0.052 MB/s@ 1 pg/f 0.113487 s/f, max 0.875 MB/s@ 316 pg/f 1.411284 s/f NEARSYNC 0.057 MB/s@ 1 pg/f 0.102930 s/f, min 0.057 MB/s@ 1 pg/f 0.102930 s/f, max 1.721 MB/s@ 316 pg/f 0.717676 s/f ASYNC 1.110 MB/s@ 1 pg/f 0.005279 s/f, min 1.110 MB/s@ 1 pg/f 0.005279 s/f, max 2.000 MB/s@ 316 pg/f 0.617676 s/f 2014-12-07 02:13:15 0.006 MB/s, 100 sec, 1.5 pg/f, 0.990099 sec/f, 150.1 pg/tr, 155.000000 sec/tr, 100.000000 sec/cmt, nOpenTrans 5.5 actual 0.006 MB/s@ 1 pg/f 0.990099 s/f SYNC 0.052 MB/s@ 1 pg/f 0.113487 s/f, min 0.052 MB/s@ 1 pg/f 0.113487 s/f, max 0.918 MB/s@ 825 pg/f 3.511263 s/f NEARSYNC 0.057 MB/s@ 1 pg/f 0.102930 s/f, min 0.057 MB/s@ 1 pg/f 0.102930 s/f, max 1.883 MB/s@ 825 pg/f 1.712402 s/f ASYNC 1.110 MB/s@ 1 pg/f 0.005279 s/f, min 1.110 MB/s@ 1 pg/f 0.005279 s/f, max 2.000 MB/s@ 825 pg/f 1.612402 s/f 2014-12-07 02:16:17 0.000 MB/s, 182 sec, 3.0 pg/f, 182.000000 sec/f, 1.3 pg/tr, 2.000000 sec/tr, 182.000000 sec/cmt, nOpenTrans 5.5 actual 0.000 MB/s@ 3 pg/f 182.000000 s/f SYNC 0.098 MB/s@ 3 pg/f 0.119672 s/f, min 0.098 MB/s@ 3 pg/f 0.119672 s/f, max 0.204 MB/s@ 7 pg/f 0.136783 s/f NEARSYNC 0.111 MB/s@ 3 pg/f 0.105859 s/f, min 0.111 MB/s@ 3 pg/f 0.105859 s/f, max 0.245 MB/s@ 7 pg/f 0.113965 s/f ASYNC 1.697 MB/s@ 3 pg/f 0.006906 s/f, min 1.697 MB/s@ 3 pg/f 0.006906 s/f, max 2.000 MB/s@ 7 pg/f 0.013965 s/f 2014-12-07 02:24:06 0.023 MB/s, 469 sec, 2.3 pg/f, 0.391486 sec/f, 542.7 pg/tr, 82.800000 sec/tr, 93.800000 sec/cmt, nOpenTrans 7.2 actual 0.023 MB/s@ 2 pg/f 0.391486 s/f SYNC 0.077 MB/s@ 2 pg/f 0.116786 s/f, min 0.077 MB/s@ 2 pg/f 0.116786 s/f, max 0.941 MB/s@ 3907 pg/f 16.218708 s/f NEARSYNC 0.086 MB/s@ 2 pg/f 0.104492 s/f, min 0.086 MB/s@ 2 pg/f 0.104492 s/f, max 1.974 MB/s@ 3907 pg/f 7.731719 s/f ASYNC 1.462 MB/s@ 2 pg/f 0.006147 s/f, min 1.462 MB/s@ 2 pg/f 0.006147 s/f, max 2.000 MB/s@ 3907 pg/f 7.631719 s/f 2014-12-07 02:25:25 0.000 MB/s, 79 sec, 2.0 pg/f, 79.000000 sec/f, 1.3 pg/tr, 7.000000 sec/tr, 79.000000 sec/cmt, nOpenTrans 9.5 actual 0.000 MB/s@ 2 pg/f 79.000000 s/f SYNC 0.068 MB/s@ 2 pg/f 0.115549 s/f, min 0.068 MB/s@ 2 pg/f 0.115549 s/f, max 0.305 MB/s@ 12 pg/f 0.158224 s/f NEARSYNC 0.075 MB/s@ 2 pg/f 0.103906 s/f, min 0.075 MB/s@ 2 pg/f 0.103906 s/f, max 0.389 MB/s@ 12 pg/f 0.124121 s/f ASYNC 1.342 MB/s@ 2 pg/f 0.005821 s/f, min 1.342 MB/s@ 2 pg/f 0.005821 s/f, max 2.000 MB/s@ 12 pg/f 0.024121 s/f 2014-12-07 02:27:39 0.033 MB/s, 134 sec, 1.7 pg/f, 0.200000 sec/f, 1113.6 pg/tr, 206.000000 sec/tr, 134.000000 sec/cmt, nOpenTrans 9.5 actual 0.033 MB/s@ 1 pg/f 0.200000 s/f SYNC 0.058 MB/s@ 1 pg/f 0.114312 s/f, min 0.058 MB/s@ 1 pg/f 0.114312 s/f, max 0.945 MB/s@ 10579 pg/f 43.728135 s/f NEARSYNC 0.064 MB/s@ 1 pg/f 0.103320 s/f, min 0.064 MB/s@ 1 pg/f 0.103320 s/f, max 1.990 MB/s@ 10579 pg/f 20.762500 s/f ASYNC 1.208 MB/s@ 1 pg/f 0.005496 s/f, min 1.208 MB/s@ 1 pg/f 0.005496 s/f, max 2.000 MB/s@ 10579 pg/f 20.662500 s/f 2014-12-07 02:29:45 0.000 MB/s, 126 sec, 3.0 pg/f, 126.000000 sec/f, 1.3 pg/tr, 3.000000 sec/tr, 126.000000 sec/cmt, nOpenTrans 9.5 actual 0.000 MB/s@ 3 pg/f 126.000000 s/f SYNC 0.098 MB/s@ 3 pg/f 0.119672 s/f, min 0.098 MB/s@ 3 pg/f 0.119672 s/f, max 0.305 MB/s@ 12 pg/f 0.158224 s/f NEARSYNC 0.111 MB/s@ 3 pg/f 0.105859 s/f, min 0.111 MB/s@ 3 pg/f 0.105859 s/f, max 0.389 MB/s@ 12 pg/f 0.124121 s/f ASYNC 1.697 MB/s@ 3 pg/f 0.006906 s/f, min 1.697 MB/s@ 3 pg/f 0.006906 s/f, max 2.000 MB/s@ 12 pg/f 0.024121 s/f 2014-12-07 02:31:10 0.003 MB/s, 85 sec, 1.7 pg/f, 1.976744 sec/f, 73.1 pg/tr, 208.000000 sec/tr, 85.000000 sec/cmt, nOpenTrans 9.5 actual 0.003 MB/s@ 1 pg/f 1.976744 s/f SYNC 0.058 MB/s@ 1 pg/f 0.114312 s/f, min 0.058 MB/s@ 1 pg/f 0.114312 s/f, max 0.913 MB/s@ 694 pg/f 2.970703 s/f NEARSYNC 0.064 MB/s@ 1 pg/f 0.103320 s/f, min 0.064 MB/s@ 1 pg/f 0.103320 s/f, max 1.863 MB/s@ 694 pg/f 1.456348 s/f ASYNC 1.208 MB/s@ 1 pg/f 0.005496 s/f, min 1.208 MB/s@ 1 pg/f 0.005496 s/f, max 2.000 MB/s@ 694 pg/f 1.356348 s/f 2014-12-07 02:32:54 0.001 MB/s, 104 sec, 1.3 pg/f, 5.777778 sec/f, 3.9 pg/tr, 4.166667 sec/tr, 17.333333 sec/cmt, nOpenTrans 11.0 actual 0.001 MB/s@ 1 pg/f 5.777778 s/f SYNC 0.045 MB/s@ 1 pg/f 0.112662 s/f, min 0.045 MB/s@ 1 pg/f 0.112662 s/f, max 0.590 MB/s@ 42 pg/f 0.284190 s/f NEARSYNC 0.050 MB/s@ 1 pg/f 0.102539 s/f, min 0.050 MB/s@ 1 pg/f 0.102539 s/f, max 0.912 MB/s@ 42 pg/f 0.183789 s/f ASYNC 1.003 MB/s@ 1 pg/f 0.005062 s/f, min 1.003 MB/s@ 1 pg/f 0.005062 s/f, max 2.000 MB/s@ 42 pg/f 0.083789 s/f 2014-12-07 02:35:38 0.001 MB/s, 164 sec, 1.4 pg/f, 4.555556 sec/f, 6.3 pg/tr, 5.000000 sec/tr, 20.500000 sec/cmt, nOpenTrans 15.8 actual 0.001 MB/s@ 1 pg/f 4.555556 s/f SYNC 0.048 MB/s@ 1 pg/f 0.113075 s/f, min 0.048 MB/s@ 1 pg/f 0.113075 s/f, max 0.751 MB/s@ 99 pg/f 0.517732 s/f NEARSYNC 0.053 MB/s@ 1 pg/f 0.102734 s/f, min 0.053 MB/s@ 1 pg/f 0.102734 s/f, max 1.321 MB/s@ 99 pg/f 0.294414 s/f ASYNC 1.058 MB/s@ 1 pg/f 0.005170 s/f, min 1.058 MB/s@ 1 pg/f 0.005170 s/f, max 2.000 MB/s@ 99 pg/f 0.194414 s/f 2014-12-07 02:36:40 0.002 MB/s, 62 sec, 1.5 pg/f, 3.647059 sec/f, 6.2 pg/tr, 7.250000 sec/tr, 15.500000 sec/cmt, nOpenTrans 20.7 actual 0.002 MB/s@ 1 pg/f 3.647059 s/f SYNC 0.052 MB/s@ 1 pg/f 0.113487 s/f, min 0.052 MB/s@ 1 pg/f 0.113487 s/f, max 0.788 MB/s@ 128 pg/f 0.636482 s/f NEARSYNC 0.057 MB/s@ 1 pg/f 0.102930 s/f, min 0.057 MB/s@ 1 pg/f 0.102930 s/f, max 1.430 MB/s@ 128 pg/f 0.350664 s/f ASYNC 1.110 MB/s@ 1 pg/f 0.005279 s/f, min 1.110 MB/s@ 1 pg/f 0.005279 s/f, max 2.000 MB/s@ 128 pg/f 0.250664 s/f 2014-12-07 02:39:25 0.004 MB/s, 165 sec, 2.0 pg/f, 2.037037 sec/f, 13.4 pg/tr, 3.750000 sec/tr, 13.750000 sec/cmt, nOpenTrans 24.4 actual 0.004 MB/s@ 2 pg/f 2.037037 s/f SYNC 0.068 MB/s@ 2 pg/f 0.115549 s/f, min 0.068 MB/s@ 2 pg/f 0.115549 s/f, max 0.878 MB/s@ 326 pg/f 1.455444 s/f NEARSYNC 0.075 MB/s@ 2 pg/f 0.103906 s/f, min 0.075 MB/s@ 2 pg/f 0.103906 s/f, max 1.729 MB/s@ 326 pg/f 0.738594 s/f ASYNC 1.342 MB/s@ 2 pg/f 0.005821 s/f, min 1.342 MB/s@ 2 pg/f 0.005821 s/f, max 2.000 MB/s@ 326 pg/f 0.638594 s/f 2014-12-07 02:40:40 0.001 MB/s, 75 sec, 1.6 pg/f, 5.357143 sec/f, 3.8 pg/tr, 2.166667 sec/tr, 12.500000 sec/cmt, nOpenTrans 31.0 actual 0.001 MB/s@ 1 pg/f 5.357143 s/f SYNC 0.055 MB/s@ 1 pg/f 0.113899 s/f, min 0.055 MB/s@ 1 pg/f 0.113899 s/f, max 0.776 MB/s@ 117 pg/f 0.593022 s/f NEARSYNC 0.061 MB/s@ 1 pg/f 0.103125 s/f, min 0.061 MB/s@ 1 pg/f 0.103125 s/f, max 1.394 MB/s@ 117 pg/f 0.330078 s/f ASYNC 1.160 MB/s@ 1 pg/f 0.005387 s/f, min 1.160 MB/s@ 1 pg/f 0.005387 s/f, max 2.000 MB/s@ 117 pg/f 0.230078 s/f 2014-12-07 02:43:11 0.001 MB/s, 151 sec, 1.7 pg/f, 11.615385 sec/f, 2.2 pg/tr, 2.900000 sec/tr, 15.100000 sec/cmt, nOpenTrans 36.9 actual 0.001 MB/s@ 1 pg/f 11.615385 s/f SYNC 0.058 MB/s@ 1 pg/f 0.114312 s/f, min 0.058 MB/s@ 1 pg/f 0.114312 s/f, max 0.717 MB/s@ 81 pg/f 0.442029 s/f NEARSYNC 0.064 MB/s@ 1 pg/f 0.103320 s/f, min 0.064 MB/s@ 1 pg/f 0.103320 s/f, max 1.226 MB/s@ 81 pg/f 0.258555 s/f ASYNC 1.208 MB/s@ 1 pg/f 0.005496 s/f, min 1.208 MB/s@ 1 pg/f 0.005496 s/f, max 2.000 MB/s@ 81 pg/f 0.158555 s/f 2014-12-07 02:44:14 0.072 MB/s, 63 sec, 5.5 pg/f, 0.295775 sec/f, 128.3 pg/tr, 5.777778 sec/tr, 7.000000 sec/cmt, nOpenTrans 41.5 actual 0.072 MB/s@ 5 pg/f 0.295775 s/f SYNC 0.165 MB/s@ 5 pg/f 0.129980 s/f, min 0.165 MB/s@ 5 pg/f 0.129980 s/f, max 0.943 MB/s@ 5324 pg/f 22.061414 s/f NEARSYNC 0.194 MB/s@ 5 pg/f 0.110742 s/f, min 0.194 MB/s@ 5 pg/f 0.110742 s/f, max 1.981 MB/s@ 5324 pg/f 10.499316 s/f ASYNC 2.000 MB/s@ 5 pg/f 0.010742 s/f, min 2.000 MB/s@ 5 pg/f 0.010742 s/f, max 2.000 MB/s@ 5324 pg/f 10.399316 s/f 2014-12-07 02:45:21 0.001 MB/s, 67 sec, 1.2 pg/f, 4.187500 sec/f, 3.4 pg/tr, 8.333333 sec/tr, 11.166667 sec/cmt, nOpenTrans 42.2 actual 0.001 MB/s@ 1 pg/f 4.187500 s/f SYNC 0.042 MB/s@ 1 pg/f 0.112250 s/f, min 0.042 MB/s@ 1 pg/f 0.112250 s/f, max 0.802 MB/s@ 143 pg/f 0.698908 s/f NEARSYNC 0.046 MB/s@ 1 pg/f 0.102344 s/f, min 0.046 MB/s@ 1 pg/f 0.102344 s/f, max 1.474 MB/s@ 143 pg/f 0.380234 s/f ASYNC 0.946 MB/s@ 1 pg/f 0.004953 s/f, min 0.946 MB/s@ 1 pg/f 0.004953 s/f, max 2.000 MB/s@ 143 pg/f 0.280234 s/f 2014-12-07 02:46:24 0.002 MB/s, 63 sec, 1.4 pg/f, 3.315789 sec/f, 5.4 pg/tr, 12.600000 sec/tr, 12.600000 sec/cmt, nOpenTrans 43.4 actual 0.002 MB/s@ 1 pg/f 3.315789 s/f SYNC 0.048 MB/s@ 1 pg/f 0.113075 s/f, min 0.048 MB/s@ 1 pg/f 0.113075 s/f, max 0.853 MB/s@ 234 pg/f 1.073630 s/f NEARSYNC 0.053 MB/s@ 1 pg/f 0.102734 s/f, min 0.053 MB/s@ 1 pg/f 0.102734 s/f, max 1.641 MB/s@ 234 pg/f 0.557734 s/f ASYNC 1.058 MB/s@ 1 pg/f 0.005170 s/f, min 1.058 MB/s@ 1 pg/f 0.005170 s/f, max 2.000 MB/s@ 234 pg/f 0.457734 s/f 2014-12-07 02:47:31 0.002 MB/s, 67 sec, 1.2 pg/f, 3.190476 sec/f, 3.5 pg/tr, 9.571429 sec/tr, 9.571429 sec/cmt, nOpenTrans 43.5 actual 0.002 MB/s@ 1 pg/f 3.190476 s/f SYNC 0.042 MB/s@ 1 pg/f 0.112250 s/f, min 0.042 MB/s@ 1 pg/f 0.112250 s/f, max 0.809 MB/s@ 152 pg/f 0.735069 s/f NEARSYNC 0.046 MB/s@ 1 pg/f 0.102344 s/f, min 0.046 MB/s@ 1 pg/f 0.102344 s/f, max 1.497 MB/s@ 152 pg/f 0.397363 s/f ASYNC 0.946 MB/s@ 1 pg/f 0.004953 s/f, min 0.946 MB/s@ 1 pg/f 0.004953 s/f, max 2.000 MB/s@ 152 pg/f 0.297363 s/f 2014-12-07 02:48:41 0.005 MB/s, 70 sec, 2.3 pg/f, 1.707317 sec/f, 7.8 pg/tr, 5.833333 sec/tr, 5.833333 sec/cmt, nOpenTrans 43.5 actual 0.005 MB/s@ 2 pg/f 1.707317 s/f SYNC 0.077 MB/s@ 2 pg/f 0.116786 s/f, min 0.077 MB/s@ 2 pg/f 0.116786 s/f, max 0.880 MB/s@ 339 pg/f 1.506325 s/f NEARSYNC 0.086 MB/s@ 2 pg/f 0.104492 s/f, min 0.086 MB/s@ 2 pg/f 0.104492 s/f, max 1.738 MB/s@ 339 pg/f 0.762695 s/f ASYNC 1.462 MB/s@ 2 pg/f 0.006147 s/f, min 1.462 MB/s@ 2 pg/f 0.006147 s/f, max 2.000 MB/s@ 339 pg/f 0.662695 s/f 2014-12-07 02:49:42 0.001 MB/s, 61 sec, 1.1 pg/f, 7.625000 sec/f, 2.2 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 7.625000 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.744 MB/s@ 95 pg/f 0.500991 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.302 MB/s@ 95 pg/f 0.286484 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 95 pg/f 0.186484 s/f 2014-12-07 02:50:46 0.001 MB/s, 64 sec, 1.2 pg/f, 5.333333 sec/f, 2.5 pg/tr, 12.800000 sec/tr, 12.800000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 5.333333 s/f SYNC 0.042 MB/s@ 1 pg/f 0.112250 s/f, min 0.042 MB/s@ 1 pg/f 0.112250 s/f, max 0.764 MB/s@ 108 pg/f 0.555707 s/f NEARSYNC 0.046 MB/s@ 1 pg/f 0.102344 s/f, min 0.046 MB/s@ 1 pg/f 0.102344 s/f, max 1.360 MB/s@ 108 pg/f 0.312402 s/f ASYNC 0.946 MB/s@ 1 pg/f 0.004953 s/f, min 0.946 MB/s@ 1 pg/f 0.004953 s/f, max 2.000 MB/s@ 108 pg/f 0.212402 s/f 2014-12-07 02:51:47 0.001 MB/s, 61 sec, 1.1 pg/f, 7.625000 sec/f, 2.0 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 7.625000 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.729 MB/s@ 86 pg/f 0.465201 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.258 MB/s@ 86 pg/f 0.269531 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 86 pg/f 0.169531 s/f 2014-12-07 02:52:52 0.001 MB/s, 65 sec, 1.1 pg/f, 7.222222 sec/f, 1.8 pg/tr, 13.000000 sec/tr, 13.000000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 7.222222 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.711 MB/s@ 78 pg/f 0.430154 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.209 MB/s@ 78 pg/f 0.252930 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 78 pg/f 0.152930 s/f 2014-12-07 02:53:53 0.001 MB/s, 61 sec, 1.1 pg/f, 7.625000 sec/f, 2.0 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 7.625000 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.729 MB/s@ 86 pg/f 0.465201 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.258 MB/s@ 86 pg/f 0.269531 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 86 pg/f 0.169531 s/f 2014-12-07 02:54:57 0.001 MB/s, 64 sec, 1.1 pg/f, 7.111111 sec/f, 1.8 pg/tr, 12.800000 sec/tr, 12.800000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 7.111111 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.711 MB/s@ 78 pg/f 0.430154 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.209 MB/s@ 78 pg/f 0.252930 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 78 pg/f 0.152930 s/f 2014-12-07 02:55:58 0.001 MB/s, 61 sec, 1.3 pg/f, 8.714286 sec/f, 2.0 pg/tr, 12.200000 sec/tr, 12.200000 sec/cmt, nOpenTrans 43.4 actual 0.001 MB/s@ 1 pg/f 8.714286 s/f SYNC 0.045 MB/s@ 1 pg/f 0.112662 s/f, min 0.045 MB/s@ 1 pg/f 0.112662 s/f, max 0.729 MB/s@ 86 pg/f 0.465201 s/f NEARSYNC 0.050 MB/s@ 1 pg/f 0.102539 s/f, min 0.050 MB/s@ 1 pg/f 0.102539 s/f, max 1.258 MB/s@ 86 pg/f 0.269531 s/f ASYNC 1.003 MB/s@ 1 pg/f 0.005062 s/f, min 1.003 MB/s@ 1 pg/f 0.005062 s/f, max 2.000 MB/s@ 86 pg/f 0.169531 s/f 2014-12-07 02:56:58 0.001 MB/s, 60 sec, 1.1 pg/f, 4.000000 sec/f, 1.7 pg/tr, 6.666667 sec/tr, 6.666667 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 4.000000 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.701 MB/s@ 73 pg/f 0.412217 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.182 MB/s@ 73 pg/f 0.244434 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 73 pg/f 0.144434 s/f 2014-12-07 02:58:01 0.001 MB/s, 63 sec, 1.1 pg/f, 3.315789 sec/f, 1.8 pg/tr, 5.250000 sec/tr, 5.250000 sec/cmt, nOpenTrans 43.5 actual 0.001 MB/s@ 1 pg/f 3.315789 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.711 MB/s@ 78 pg/f 0.430154 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.209 MB/s@ 78 pg/f 0.252930 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 78 pg/f 0.152930 s/f 2014-12-07 03:39:16 0.000 MB/s, 2475 sec, 2.0 pg/f, 2475.000000 sec/f, 0.8 pg/tr, 3.666667 sec/tr, 825.000000 sec/cmt, nOpenTrans 44.2 actual 0.000 MB/s@ 2 pg/f 2475.000000 s/f SYNC 0.068 MB/s@ 2 pg/f 0.115549 s/f, min 0.068 MB/s@ 2 pg/f 0.115549 s/f, max 0.546 MB/s@ 35 pg/f 0.253101 s/f NEARSYNC 0.075 MB/s@ 2 pg/f 0.103906 s/f, min 0.075 MB/s@ 2 pg/f 0.103906 s/f, max 0.817 MB/s@ 35 pg/f 0.169063 s/f ASYNC 1.342 MB/s@ 2 pg/f 0.005821 s/f, min 1.342 MB/s@ 2 pg/f 0.005821 s/f, max 2.000 MB/s@ 35 pg/f 0.069063 s/f 2014-12-07 03:55:10 0.016 MB/s, 954 sec, 1.4 pg/f, 0.339502 sec/f, 1973.7 pg/tr, 477.000000 sec/tr, 477.000000 sec/cmt, nOpenTrans 45.3 actual 0.016 MB/s@ 1 pg/f 0.339502 s/f SYNC 0.048 MB/s@ 1 pg/f 0.113075 s/f, min 0.048 MB/s@ 1 pg/f 0.113075 s/f, max 0.947 MB/s@ 89408 pg/f 368.762595 s/f NEARSYNC 0.053 MB/s@ 1 pg/f 0.102734 s/f, min 0.053 MB/s@ 1 pg/f 0.102734 s/f, max 1.999 MB/s@ 89408 pg/f 174.726191 s/f ASYNC 1.058 MB/s@ 1 pg/f 0.005170 s/f, min 1.058 MB/s@ 1 pg/f 0.005170 s/f, max 2.000 MB/s@ 89408 pg/f 174.626191 s/f 2014-12-07 04:21:16 0.000 MB/s, 1566 sec, 2.0 pg/f, 1566.000000 sec/f, 0.0 pg/tr, 0.000000 sec/tr, 156.600000 sec/cmt, nOpenTrans 50.4 actual 0.000 MB/s@ 2 pg/f 1566.000000 s/f SYNC 0.068 MB/s@ 2 pg/f 0.115549 s/f, min 0.068 MB/s@ 2 pg/f 0.115549 s/f, max 0.068 MB/s@ 2 pg/f 0.115549 s/f NEARSYNC 0.075 MB/s@ 2 pg/f 0.103906 s/f, min 0.075 MB/s@ 2 pg/f 0.103906 s/f, max 0.075 MB/s@ 2 pg/f 0.103906 s/f ASYNC 1.342 MB/s@ 2 pg/f 0.005821 s/f, min 1.342 MB/s@ 2 pg/f 0.005821 s/f, max 1.342 MB/s@ 2 pg/f 0.005821 s/f 2014-12-07 04:22:17 0.172 MB/s, 61 sec, 3.2 pg/f, 0.072792 sec/f, 668.7 pg/tr, 14.750000 sec/tr, 15.250000 sec/cmt, nOpenTrans 55.9 actual 0.172 MB/s@ 3 pg/f 0.072792 s/f SYNC ? 0.179 MB/s@ 6 pg/f 0.132255 s/f, min 0.104 MB/s@ 3 pg/f 0.120496 s/f, max 0.947 MB/s@ 37380 pg/f 154.236267 s/f NEARSYNC ? 0.175 MB/s@ 4 pg/f 0.109592 s/f, min 0.118 MB/s@ 3 pg/f 0.106250 s/f, max 1.997 MB/s@ 37380 pg/f 73.108457 s/f ASYNC 1.755 MB/s@ 3 pg/f 0.007123 s/f, min 1.755 MB/s@ 3 pg/f 0.007123 s/f, max 2.000 MB/s@ 37380 pg/f 73.008457 s/f 2014-12-07 04:28:35 0.000 MB/s, 378 sec, 3.7 pg/f, 63.000000 sec/f, 1.4 pg/tr, 0.062500 sec/tr, 23.625000 sec/cmt, nOpenTrans 62.1 actual 0.000 MB/s@ 3 pg/f 63.000000 s/f SYNC 0.118 MB/s@ 3 pg/f 0.122558 s/f, min 0.118 MB/s@ 3 pg/f 0.122558 s/f, max 0.729 MB/s@ 86 pg/f 0.465779 s/f NEARSYNC 0.135 MB/s@ 3 pg/f 0.107227 s/f, min 0.135 MB/s@ 3 pg/f 0.107227 s/f, max 1.259 MB/s@ 86 pg/f 0.269805 s/f ASYNC 1.885 MB/s@ 3 pg/f 0.007666 s/f, min 1.885 MB/s@ 3 pg/f 0.007666 s/f, max 2.000 MB/s@ 86 pg/f 0.169805 s/f 2014-12-07 04:30:49 0.002 MB/s, 134 sec, 1.3 pg/f, 2.851064 sec/f, 7.9 pg/tr, 4.625000 sec/tr, 16.750000 sec/cmt, nOpenTrans 72.0 actual 0.002 MB/s@ 1 pg/f 2.851064 s/f SYNC 0.045 MB/s@ 1 pg/f 0.112662 s/f, min 0.045 MB/s@ 1 pg/f 0.112662 s/f, max 0.906 MB/s@ 568 pg/f 2.452615 s/f NEARSYNC 0.050 MB/s@ 1 pg/f 0.102539 s/f, min 0.050 MB/s@ 1 pg/f 0.102539 s/f, max 1.835 MB/s@ 568 pg/f 1.210938 s/f ASYNC 1.003 MB/s@ 1 pg/f 0.005062 s/f, min 1.003 MB/s@ 1 pg/f 0.005062 s/f, max 2.000 MB/s@ 568 pg/f 1.110938 s/f 2014-12-07 04:32:04 0.094 MB/s, 75 sec, 2.3 pg/f, 0.095299 sec/f, 255.9 pg/tr, 8.000000 sec/tr, 10.714286 sec/cmt, nOpenTrans 76.1 actual 0.094 MB/s@ 2 pg/f 0.095299 s/f SYNC ? 0.095 MB/s@ 2 pg/f 0.119236 s/f, min 0.077 MB/s@ 2 pg/f 0.116786 s/f, max 0.946 MB/s@ 19473 pg/f 80.403702 s/f NEARSYNC ? 0.107 MB/s@ 2 pg/f 0.105653 s/f, min 0.086 MB/s@ 2 pg/f 0.104492 s/f, max 1.995 MB/s@ 19473 pg/f 38.135137 s/f ASYNC 1.462 MB/s@ 2 pg/f 0.006147 s/f, min 1.462 MB/s@ 2 pg/f 0.006147 s/f, max 2.000 MB/s@ 19473 pg/f 38.035137 s/f 2014-12-07 04:33:59 0.055 MB/s, 115 sec, 2.8 pg/f, 0.200348 sec/f, 108.0 pg/tr, 3.200000 sec/tr, 7.666667 sec/cmt, nOpenTrans 83.0 actual 0.055 MB/s@ 2 pg/f 0.200348 s/f SYNC 0.092 MB/s@ 2 pg/f 0.118847 s/f, min 0.092 MB/s@ 2 pg/f 0.118847 s/f, max 0.945 MB/s@ 8964 pg/f 37.068239 s/f NEARSYNC 0.104 MB/s@ 2 pg/f 0.105469 s/f, min 0.104 MB/s@ 2 pg/f 0.105469 s/f, max 1.989 MB/s@ 8964 pg/f 17.607813 s/f ASYNC 1.635 MB/s@ 2 pg/f 0.006689 s/f, min 1.635 MB/s@ 2 pg/f 0.006689 s/f, max 2.000 MB/s@ 8964 pg/f 17.507812 s/f 2014-12-07 04:34:59 0.004 MB/s, 60 sec, 1.3 pg/f, 1.395349 sec/f, 2.6 pg/tr, 0.714286 sec/tr, 2.857143 sec/cmt, nOpenTrans 96.0 actual 0.004 MB/s@ 1 pg/f 1.395349 s/f SYNC 0.045 MB/s@ 1 pg/f 0.112662 s/f, min 0.045 MB/s@ 1 pg/f 0.112662 s/f, max 0.858 MB/s@ 249 pg/f 1.136469 s/f NEARSYNC 0.050 MB/s@ 1 pg/f 0.102539 s/f, min 0.050 MB/s@ 1 pg/f 0.102539 s/f, max 1.660 MB/s@ 249 pg/f 0.587500 s/f ASYNC 1.003 MB/s@ 1 pg/f 0.005062 s/f, min 1.003 MB/s@ 1 pg/f 0.005062 s/f, max 2.000 MB/s@ 249 pg/f 0.487500 s/f 2014-12-07 04:35:59 0.022 MB/s, 60 sec, 2.1 pg/f, 0.384615 sec/f, 8.1 pg/tr, 0.707317 sec/tr, 1.463415 sec/cmt, nOpenTrans 114.0 actual 0.022 MB/s@ 2 pg/f 0.384615 s/f SYNC 0.071 MB/s@ 2 pg/f 0.115961 s/f, min 0.071 MB/s@ 2 pg/f 0.115961 s/f, max 0.921 MB/s@ 923 pg/f 3.914724 s/f NEARSYNC 0.079 MB/s@ 2 pg/f 0.104102 s/f, min 0.079 MB/s@ 2 pg/f 0.104102 s/f, max 1.895 MB/s@ 923 pg/f 1.903516 s/f ASYNC 1.383 MB/s@ 2 pg/f 0.005930 s/f, min 1.383 MB/s@ 2 pg/f 0.005930 s/f, max 2.000 MB/s@ 923 pg/f 1.803516 s/f 2014-12-07 04:48:34 0.001 MB/s, 755 sec, 1.1 pg/f, 7.550000 sec/f, 1.4 pg/tr, 9.271605 sec/tr, 9.320988 sec/cmt, nOpenTrans 120.6 actual 0.001 MB/s@ 1 pg/f 7.550000 s/f SYNC 0.038 MB/s@ 1 pg/f 0.111838 s/f, min 0.038 MB/s@ 1 pg/f 0.111838 s/f, max 0.821 MB/s@ 168 pg/f 0.803474 s/f NEARSYNC 0.042 MB/s@ 1 pg/f 0.102148 s/f, min 0.042 MB/s@ 1 pg/f 0.102148 s/f, max 1.535 MB/s@ 168 pg/f 0.429766 s/f ASYNC 0.887 MB/s@ 1 pg/f 0.004845 s/f, min 0.887 MB/s@ 1 pg/f 0.004845 s/f, max 2.000 MB/s@ 168 pg/f 0.329766 s/f 2014-12-07 04:49:36 0.000 MB/s, 62 sec, 1.0 pg/f, 62.000000 sec/f, 0.0 pg/tr, 2.480000 sec/tr, 2.480000 sec/cmt, nOpenTrans 121.5 actual 0.000 MB/s@ 1 pg/f 62.000000 s/f SYNC 0.035 MB/s@ 1 pg/f 0.111425 s/f, min 0.035 MB/s@ 1 pg/f 0.111425 s/f, max 0.035 MB/s@ 1 pg/f 0.111425 s/f NEARSYNC 0.038 MB/s@ 1 pg/f 0.101953 s/f, min 0.038 MB/s@ 1 pg/f 0.101953 s/f, max 0.038 MB/s@ 1 pg/f 0.101953 s/f ASYNC 0.825 MB/s@ 1 pg/f 0.004736 s/f, min 0.825 MB/s@ 1 pg/f 0.004736 s/f, max 0.825 MB/s@ 1 pg/f 0.004736 s/f 2014-12-07 04:50:41 0.000 MB/s, 65 sec, 1.0 pg/f, 32.500000 sec/f, 0.0 pg/tr, 1.225806 sec/tr, 2.096774 sec/cmt, nOpenTrans 121.5 actual 0.000 MB/s@ 1 pg/f 32.500000 s/f SYNC 0.035 MB/s@ 1 pg/f 0.111425 s/f, min 0.035 MB/s@ 1 pg/f 0.111425 s/f, max 0.035 MB/s@ 1 pg/f 0.111425 s/f NEARSYNC 0.038 MB/s@ 1 pg/f 0.101953 s/f, min 0.038 MB/s@ 1 pg/f 0.101953 s/f, max 0.038 MB/s@ 1 pg/f 0.101953 s/f ASYNC 0.825 MB/s@ 1 pg/f 0.004736 s/f, min 0.825 MB/s@ 1 pg/f 0.004736 s/f, max 0.825 MB/s@ 1 pg/f 0.004736 s/f 2014-12-07 05:34:32 0.000 MB/s, 2631 sec, 1.0 pg/f, 2631.000000 sec/f, 1.3 pg/tr, 2631.000000 sec/tr, 2631.000000 sec/cmt, nOpenTrans 121.5 actual 0.000 MB/s@ 1 pg/f 2631.000000 s/f SYNC 0.035 MB/s@ 1 pg/f 0.111425 s/f, min 0.035 MB/s@ 1 pg/f 0.111425 s/f, max 0.813 MB/s@ 157 pg/f 0.758572 s/f NEARSYNC 0.038 MB/s@ 1 pg/f 0.101953 s/f, min 0.038 MB/s@ 1 pg/f 0.101953 s/f, max 1.510 MB/s@ 157 pg/f 0.408496 s/f ASYNC 0.825 MB/s@ 1 pg/f 0.004736 s/f, min 0.825 MB/s@ 1 pg/f 0.004736 s/f, max 2.000 MB/s@ 157 pg/f 0.308496 s/f 2014-12-07 08:03:58 0.000 MB/s, 8966 sec, 2.4 pg/f, 144.612903 sec/f, 37.6 pg/tr, 2.750000 sec/tr, 2241.500000 sec/cmt, nOpenTrans 122.1 actual 0.000 MB/s@ 2 pg/f 144.612903 s/f SYNC 0.080 MB/s@ 2 pg/f 0.117198 s/f, min 0.080 MB/s@ 2 pg/f 0.117198 s/f, max 0.942 MB/s@ 4590 pg/f 19.037042 s/f NEARSYNC 0.090 MB/s@ 2 pg/f 0.104688 s/f, min 0.090 MB/s@ 2 pg/f 0.104688 s/f, max 1.978 MB/s@ 4590 pg/f 9.066719 s/f ASYNC 1.499 MB/s@ 2 pg/f 0.006255 s/f, min 1.499 MB/s@ 2 pg/f 0.006255 s/f, max 2.000 MB/s@ 4590 pg/f 8.966719 s/f 2014-12-07 08:22:14 0.000 MB/s, 1096 sec, 13.0 pg/f, 1096.000000 sec/f, 13.1 pg/tr, 1096.000000 sec/tr, 1096.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 13 pg/f 1096.000000 s/f SYNC 0.316 MB/s@ 13 pg/f 0.160904 s/f, min 0.316 MB/s@ 13 pg/f 0.160904 s/f, max 0.932 MB/s@ 1617 pg/f 6.778124 s/f NEARSYNC 0.405 MB/s@ 13 pg/f 0.125391 s/f, min 0.405 MB/s@ 13 pg/f 0.125391 s/f, max 1.939 MB/s@ 1617 pg/f 3.259863 s/f ASYNC 2.000 MB/s@ 13 pg/f 0.025391 s/f, min 2.000 MB/s@ 13 pg/f 0.025391 s/f, max 2.000 MB/s@ 1617 pg/f 3.159863 s/f 2014-12-07 11:22:14 0.000 MB/s, 10800 sec, 5.8 pg/f, 1800.000000 sec/f, 8.8 pg/tr, 2700.000000 sec/tr, 2700.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 5 pg/f 1800.000000 s/f SYNC 0.173 MB/s@ 5 pg/f 0.131217 s/f, min 0.173 MB/s@ 5 pg/f 0.131217 s/f, max 0.925 MB/s@ 1086 pg/f 4.588465 s/f NEARSYNC 0.204 MB/s@ 5 pg/f 0.111328 s/f, min 0.204 MB/s@ 5 pg/f 0.111328 s/f, max 1.910 MB/s@ 1086 pg/f 2.222656 s/f ASYNC 2.000 MB/s@ 5 pg/f 0.011328 s/f, min 2.000 MB/s@ 5 pg/f 0.011328 s/f, max 2.000 MB/s@ 1086 pg/f 2.122656 s/f 2014-12-07 14:22:14 0.000 MB/s, 10800 sec, 9.0 pg/f, 2700.000000 sec/f, 8.8 pg/tr, 2700.000000 sec/tr, 2700.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 9 pg/f 2700.000000 s/f SYNC 0.243 MB/s@ 9 pg/f 0.144411 s/f, min 0.243 MB/s@ 9 pg/f 0.144411 s/f, max 0.925 MB/s@ 1086 pg/f 4.588465 s/f NEARSYNC 0.299 MB/s@ 9 pg/f 0.117578 s/f, min 0.299 MB/s@ 9 pg/f 0.117578 s/f, max 1.910 MB/s@ 1086 pg/f 2.222656 s/f ASYNC 2.000 MB/s@ 9 pg/f 0.017578 s/f, min 2.000 MB/s@ 9 pg/f 0.017578 s/f, max 2.000 MB/s@ 1086 pg/f 2.122656 s/f 2014-12-07 17:22:14 0.000 MB/s, 10800 sec, 5.8 pg/f, 1800.000000 sec/f, 8.8 pg/tr, 2700.000000 sec/tr, 2700.000000 sec/cmt, nOpenTrans 123.5 actual 0.000 MB/s@ 5 pg/f 1800.000000 s/f SYNC 0.173 MB/s@ 5 pg/f 0.131217 s/f, min 0.173 MB/s@ 5 pg/f 0.131217 s/f, max 0.925 MB/s@ 1086 pg/f 4.588465 s/f NEARSYNC 0.204 MB/s@ 5 pg/f 0.111328 s/f, min 0.204 MB/s@ 5 pg/f 0.111328 s/f, max 1.910 MB/s@ 1086 pg/f 2.222656 s/f ASYNC 2.000 MB/s@ 5 pg/f 0.011328 s/f, min 2.000 MB/s@ 5 pg/f 0.011328 s/f, max 2.000 MB/s@ 1086 pg/f 2.122656 s/f Page 18038 and 18039 are ping/pong pages (indicating end of file). Ping pageLso=1285818112367 byteCount=2404, Pong pageLso=1285818112531 byteCount=2568 File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000001.LOG" Page 1 is an old page. pageLso 1281654788091 not in expected range of 1285849083904 and 1285849092096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000002.LOG" Page 1 is an old page. pageLso 1281759645691 not in expected range of 1285953941504 and 1285953949696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000003.LOG" Page 1 is an old page. pageLso 1281864503291 not in expected range of 1286058799104 and 1286058807296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000004.LOG" Page 1 is an old page. pageLso 1281969360891 not in expected range of 1286163656704 and 1286163664896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000005.LOG" Page 1 is an old page. pageLso 1282074218491 not in expected range of 1286268514304 and 1286268522496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000006.LOG" Page 1 is an old page. pageLso 1282179076091 not in expected range of 1286373371904 and 1286373380096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000007.LOG" Page 1 is an old page. pageLso 1282283933691 not in expected range of 1286478229504 and 1286478237696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000008.LOG" Page 1 is an old page. pageLso 1282388791291 not in expected range of 1286583087104 and 1286583095296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000009.LOG" Page 1 is an old page. pageLso 1282493648891 not in expected range of 1286687944704 and 1286687952896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000010.LOG" Page 1 is an old page. pageLso 1282598506491 not in expected range of 1286792802304 and 1286792810496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000011.LOG" Page 1 is an old page. pageLso 1282703364091 not in expected range of 1286897659904 and 1286897668096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000012.LOG" Page 1 is an old page. pageLso 1282808221691 not in expected range of 1287002517504 and 1287002525696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000013.LOG" Page 1 is an old page. pageLso 1282913079291 not in expected range of 1287107375104 and 1287107383296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000014.LOG" Page 1 is an old page. pageLso 1283017936891 not in expected range of 1287212232704 and 1287212240896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000015.LOG" Page 1 is an old page. pageLso 1283122794491 not in expected range of 1287317090304 and 1287317098496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000016.LOG" Page 1 is an old page. pageLso 1283227652091 not in expected range of 1287421947904 and 1287421956096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000017.LOG" Page 1 is an old page. pageLso 1283332509691 not in expected range of 1287526805504 and 1287526813696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000018.LOG" Page 1 is an old page. pageLso 1283437367291 not in expected range of 1287631663104 and 1287631671296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000019.LOG" Page 1 is an old page. pageLso 1283542224891 not in expected range of 1287736520704 and 1287736528896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000020.LOG" Page 1 is an old page. pageLso 1283647082491 not in expected range of 1287841378304 and 1287841386496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000021.LOG" Page 1 is an old page. pageLso 1283751940091 not in expected range of 1287946235904 and 1287946244096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000022.LOG" Page 1 is an old page. pageLso 1283856797691 not in expected range of 1288051093504 and 1288051101696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000023.LOG" Page 1 is an old page. pageLso 1283961655291 not in expected range of 1288155951104 and 1288155959296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000024.LOG" Page 1 is an old page. pageLso 1284066512891 not in expected range of 1288260808704 and 1288260816896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000025.LOG" Page 1 is an old page. pageLso 1284171370491 not in expected range of 1288365666304 and 1288365674496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000026.LOG" Page 1 is an old page. pageLso 1284276228091 not in expected range of 1288470523904 and 1288470532096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000027.LOG" Page 1 is an old page. pageLso 1284381085691 not in expected range of 1288575381504 and 1288575389696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000028.LOG" Page 1 is an old page. pageLso 1284485943291 not in expected range of 1288680239104 and 1288680247296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000029.LOG" Page 1 is an old page. pageLso 1284590800891 not in expected range of 1288785096704 and 1288785104896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000030.LOG" Page 1 is an old page. pageLso 1284695658491 not in expected range of 1288889954304 and 1288889962496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000031.LOG" Page 1 is an old page. pageLso 1284800516091 not in expected range of 1288994811904 and 1288994820096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000032.LOG" Page 1 is an old page. pageLso 1284905373691 not in expected range of 1289099669504 and 1289099677696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000033.LOG" Page 1 is an old page. pageLso 1285010231291 not in expected range of 1289204527104 and 1289204535296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000034.LOG" Page 1 is an old page. pageLso 1285115088891 not in expected range of 1289309384704 and 1289309392896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000035.LOG" Page 1 is an old page. pageLso 1285219946491 not in expected range of 1289414242304 and 1289414250496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000036.LOG" Page 1 is an old page. pageLso 1285324804091 not in expected range of 1289519099904 and 1289519108096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000037.LOG" Page 1 is an old page. pageLso 1285429661691 not in expected range of 1289623957504 and 1289623965696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000038.LOG" Page 1 is an old page. pageLso 1285534519291 not in expected range of 1289728815104 and 1289728823296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000039.LOG" Page 1 is an old page. pageLso 1285639376891 not in expected range of 1289833672704 and 1289833680896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000040.LOG" Page 1 is an old page. pageLso 1275992477691 not in expected range of 1289938530304 and 1289938538496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000041.LOG" Page 1 is an old page. pageLso 1276097335291 not in expected range of 1290043387904 and 1290043396096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000042.LOG" Page 1 is an old page. pageLso 1276202192891 not in expected range of 1290148245504 and 1290148253696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000043.LOG" Page 1 is an old page. pageLso 1276307050491 not in expected range of 1290253103104 and 1290253111296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000044.LOG" Page 1 is an old page. pageLso 1276411908091 not in expected range of 1290357960704 and 1290357968896. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000045.LOG" Page 1 is an old page. pageLso 1276516765691 not in expected range of 1290462818304 and 1290462826496. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000046.LOG" Page 1 is an old page. pageLso 1276621623291 not in expected range of 1290567675904 and 1290567684096. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000047.LOG" Page 1 is an old page. pageLso 1276726480891 not in expected range of 1290672533504 and 1290672541696. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000048.LOG" Page 1 is an old page. pageLso 1276831338491 not in expected range of 1290777391104 and 1290777399296. Treating as end of file. File "/db2fs/db2instd/NODE0000/SQL00001/SQLOGDIR/S0000049.LOG" Page 1 is an old page. pageLso 1276936196091 not in expected range of 1290882248704 and 1290882256896. Treating as end of file. 2014-12-07 17:22:15 0.090 MB/s, 1 sec, 3.8 pg/f, 0.166667 sec/f, 7.3 pg/tr, 0.333333 sec/tr, 0.333333 sec/cmt, nOpenTrans 123.4 actual 0.090 MB/s@ 3 pg/f 0.166667 s/f SYNC 0.121 MB/s@ 3 pg/f 0.122970 s/f, min 0.121 MB/s@ 3 pg/f 0.122970 s/f, max 0.921 MB/s@ 900 pg/f 3.821621 s/f NEARSYNC 0.138 MB/s@ 3 pg/f 0.107422 s/f, min 0.138 MB/s@ 3 pg/f 0.107422 s/f, max 1.892 MB/s@ 900 pg/f 1.859414 s/f ASYNC 1.909 MB/s@ 3 pg/f 0.007774 s/f, min 1.909 MB/s@ 3 pg/f 0.007774 s/f, max 2.000 MB/s@ 900 pg/f 1.759414 s/f transTable: nOpenTran=123 openTranSize=7176 nBuckets=1024 nAdds=569 nCollisions=34 collisionRate=5% Distribution of log write rate (unit is MB/s): Total 49 numbers, Sum 0.675, Min 0.000, Max 0.171, Avg 0.014 Average rate 0.014 MB/s REMOTE CATCHUP 2.000 MB/s@ 16 pg/f 0.031250 s/f Zero 24 numbers 48% From 0.001 to 0.001 9 numbers 18% From 0.002 to 0.003 3 numbers 6% From 0.004 to 0.007 3 numbers 6% From 0.016 to 0.031 3 numbers 6% From 0.032 to 0.063 2 numbers 4% From 0.064 to 0.127 4 numbers 8% From 0.128 to 0.255 1 numbers 2% Distribution of flush size (unit is page): Total 8790 numbers, Sum 18039, Min 1, Max 48, Avg 2.1 From 1 to 1 5967 numbers 67% From 2 to 3 2160 numbers 24% From 4 to 7 234 numbers 2% From 8 to 15 366 numbers 4% From 16 to 31 37 numbers 0% From 32 to 63 26 numbers 0% Distribution of flush duration (unit is second): Total 8790 numbers, Sum 54798, Min 0, Max 10800, Avg 6.234130 Zero 8513 numbers 96% From 1 to 1 113 numbers 1% From 2 to 3 14 numbers 0% From 4 to 7 27 numbers 0% From 8 to 15 79 numbers 0% From 16 to 31 10 numbers 0% From 32 to 63 10 numbers 0% From 64 to 127 9 numbers 0% From 128 to 255 4 numbers 0% From 256 to 511 1 numbers 0% From 512 to 1023 2 numbers 0% From 1024 to 2047 2 numbers 0% From 2048 to 4095 2 numbers 0% From 8192 to 16383 4 numbers 0% Distribution of record size (unit is byte): Total 1594876 numbers, Sum 73593528, Min 20, Max 81480, Avg 46 From 16 to 31 402646 numbers 25% From 32 to 63 1152299 numbers 72% From 64 to 127 20767 numbers 1% From 128 to 255 16369 numbers 1% From 256 to 511 1043 numbers 0% From 512 to 1023 136 numbers 0% From 1024 to 2047 441 numbers 0% From 2048 to 4095 764 numbers 0% From 4096 to 8191 376 numbers 0% From 8192 to 16383 34 numbers 0% From 65536 to 131071 1 numbers 0% Distribution of transaction size (unit is byte): Total 446 numbers, Sum 73586352, Min 51, Max 16163192, Avg 164992 From 32 to 63 122 numbers 27% From 128 to 255 77 numbers 17% From 4096 to 8191 113 numbers 25% From 8192 to 16383 59 numbers 13% From 16384 to 32767 21 numbers 4% From 32768 to 65535 21 numbers 4% From 65536 to 131071 10 numbers 2% From 131072 to 262143 7 numbers 1% From 262144 to 524287 4 numbers 0% From 524288 to 1048575 3 numbers 0% From 1048576 to 2097151 1 numbers 0% From 2097152 to 4194303 1 numbers 0% From 4194304 to 8388607 4 numbers 0% From 8388608 to 16777215 3 numbers 0% Distribution of transaction duration (unit is second): Total 446 numbers, Sum 40341, Min 0, Max 10800, Avg 90.450673 Zero 204 numbers 45% From 1 to 1 93 numbers 20% From 2 to 3 14 numbers 3% From 4 to 7 27 numbers 6% From 8 to 15 80 numbers 17% From 16 to 31 10 numbers 2% From 32 to 63 6 numbers 1% From 64 to 127 1 numbers 0% From 128 to 255 3 numbers 0% From 256 to 511 2 numbers 0% From 512 to 1023 1 numbers 0% From 1024 to 2047 1 numbers 0% From 2048 to 4095 1 numbers 0% From 8192 to 16383 3 numbers 0% Distribution of commit interval (unit is second): Total 49 numbers, Sum 16728.462360, Min 0.333333, Max 2700.000000, Avg 341.397191 From 0.262144 to 0.524287 1 numbers 2% From 1.048576 to 2.097151 2 numbers 4% From 2.097152 to 4.194303 2 numbers 4% From 4.194304 to 8.388607 5 numbers 10% From 8.388608 to 16.777215 18 numbers 36% From 16.777216 to 33.554431 4 numbers 8% From 33.554432 to 67.108863 1 numbers 2% From 67.108864 to 134.217727 6 numbers 12% From 134.217728 to 268.435455 2 numbers 4% From 268.435456 to 536.870911 1 numbers 2% From 536.870912 to 1073.741823 1 numbers 2% From 1073.741824 to 2147.483647 1 numbers 2% From 2147.483648 to 4294.967295 5 numbers 10% Distribution of number of open transactions: Total 1015 numbers, Sum 78514, Min 0, Max 124, Avg 77.4 Zero 1 numbers 0% From 1 to 1 3 numbers 0% From 2 to 3 4 numbers 0% From 4 to 7 28 numbers 2% From 8 to 15 40 numbers 3% From 16 to 31 64 numbers 6% From 32 to 63 304 numbers 29% From 64 to 127 571 numbers 56% 70.465 MB scanned in 0.482 seconds, scanning rate 146.077 MB/second SYNC Max flush size: predicted 13 pages, workload max 89408 pages NEARSYNC Max flush size: predicted 13 pages, workload max 89408 pages ASYNC Max flush size: predicted 13 pages, workload max 89408 pages
See the question marks (I’ve added the red color) in a few of the lines? That’s really what you’re looking for in this output. A varying number of question marks will be added to lines (portions of log files) where the specified syncmode might cause some performance impact. One question mark is mild impact, two question marks is moderate performance improvement, and three question marks is severe performance impact. If you see three question marks in a real world scenario, consider the fact that you should not use that syncmode, or if there is a requirement for the syncmode that you must somehow change one of the inputs – the disk speed, the network speed, or the transactional activity.
We turned automatic log compression off.too. If you ever need to do something with a database and archive log files and you have the log files compressed, you are out of luck. We discovered that in a production environment and found it just silly that the vendor wanted us to transmit our log files to them, have them uncompress them and send them back at 2 AM in the morning with no promise as to how many of these we would have to work through manually like this before getting the production environment back online and working. If the vendor wants to hold on to control of when this program is used they can simply use the same approach they use with db2cleancat. Have a new version for each new version of the database and have a 7 day password that you can only get by opening a PMR. Run the program, give it the valid password and uncompress your archive log files so you can use them the way you need to use them in an emergency situation. Otherwise, suffer through a restore of a backup and a partial roll forward if logs backed with that are corrupted too and then suffer through applications playing catch up while your CIO and CEO ask the question, and why do we have you people working for us? Vendors need to get some field experience and then they would understand more about their customers needs.
[…] 13,043 words (HADR Tools: HADR Calculator) […]
[…] or other factors might cause HADR to impact database performance on your primary database. See my series on the HADR Tools for details on how to do […]
Hi everybody…
i don(t understand what is represented by :
– flush duration (what is it)
– What reprersent the ‘numbers’ (Total 348 numbers, Sum 37504, Min 0, Max 7501, Avg 107.770115)
so i can’t completely read the output of db2logscan
Thank you for your answer…