HADR Tools: the DB2 Log Scanner

Posted by

The DB2 Log Scanner 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 DB2 Log Scanner

One of the nice things I’ve learned about the DB2 Log Scanner is that it works at least partially on circular log files – even though you would not be able to use HADR with circular logging. Why is this nice? Well, I have a data warehouse that I need to implement HADR for, and it happens to currently use circular logging. Luckily I can get information using the HADR tools on it the way it is and don’t have to try to squeeze in a change from circular to archive prior to moving this database between servers – when I’ll be making that change anyway.

Like the HADR simulator, the DB2 log scanner is a stand-alone tool. This means that all you have to do to install it is to move the right file for your OS to the server where the log files exist. You could even copy log files to some other server and analyze them there, since an installation of DB2 is not even required.

Scanning the Transaction Logs with the DB2 Log Scanner

After you have downloaded the correct executable for your OS and placed it on the server, the DB2 log scanner can be used fairly simply:

./db2logscan_linux -f logfiles.list > db2logscan.sample.out

In the above example, the logfiles.txt file holds the fully qualified name of each log file that I want to analyze, with each file on a separate line. I redirect the output to a file, because the output from this tool is a bit cryptic, and I need to be able to pass that as input into the HADR calculator.

Here’s what the output looks like:

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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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

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
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

There are some interesting distributions there at the end that might be graphed, but the bulk of the output is not really great to look at. The power in this tool is simply in generating the output file that we can feed into the HADR calculator.

Lead Db2 Database Engineer and Service Delivery Manager , XTIVIA
Ember is always curious and thrives on change. Working in IT provides a lot of that change, but after 17 years developing a top-level expertise on Db2 for mid-range servers and more than 7 years blogging about it, Ember is hungry for new challenges and looks to expand her skill set to the Data Engineering role for Data Science. With in-depth SQL and RDBMS knowledge, Ember shares both posts about her core skill set and her journey into Data Science. Ember lives in Denver and work from home for XTIVIA, leading a team of Db2 DBAs.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.