|
Problem IT04352
|
Status: Closed |
HIGH DISK I/O WHEN USING DB2READLOG API, HADR MULTIPLE STANDBY, OR HADR SUPERASYNC |
| product: |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 |
| Problem description: |
You may notice high disk read I/O in the following environments
- When running the db2ReadLog API
- On an HADR primary in an HADR Multiple Standby environment
- On an HADR primary using SUPERASYNC
From a db2pd -stack output you will notice the function
sqlpgReadXhdrFromFile in the stack for the db2lfr edu.
57:<StackTrace>
58------FUNC-ADDR---- ------FUNCTION + OFFSET------
59-0x00002AD172C1365A_Z25ossDumpStackTraceInternalmR11OSSTrapFil
eiP7siginfoPvmm +0x020a
60- (/data1/db2inst1/sqllib/lib64/libdb2osse.so.1)
61-0x00002AD172C133EB ossDumpStackTraceV98 + 0x002b
62- (/data1/db2inst1/sqllib/lib64/libdb2osse.so.1)
63-0x00002AD172C0E313 _ZN11OSSTrapFile6dumpExEmiP7siginfoPvm
+0x0103
64- (/data1/db2inst1/sqllib/lib64/libdb2osse.so.1)
65-0x00002AD16E8362C7 sqlo_trce + 0x0407
66- (/data1/db2inst1/sqllib/lib64/libdb2e.so.1)
67-0x00002AD16E880514 sqloDumpDiagInfoHandler + 0x0104
68- (/data1/db2inst1/sqllib/lib64/libdb2e.so.1)
69-0x00000039D5E0ECA0 address: 0x00000039D5E0ECA0 ;
dladdress:0x00000039D5E00000 ; offset in lib: 0x000000000000ECA0
;
70- (/lib64/libpthread.so.0)
71-0x00000039D5E0E5C8 pread + 0x0058
72- (/lib64/libpthread.so.0)
73-0x00002AD16D188163 sqloReadBlocks + 0x0323
74- (/data1/db2inst1/sqllib/lib64/libdb2e.so.1)
75-0x00002AD16D1A73B0_Z21sqlpgReadXhdrFromFilePKcP12SQLO_FHANDLE
jmP10SQLPG_XHDRPtm +0x00a0
76- (/data1/db2inst1/sqllib/lib64/libdb2e.so.1)
77-0x00002AD16D1A70DF _Z8sqlpgolfPKcP10SQLPG_XHDRP9SQLP_LFCBm
+0x00ef
78- (/data1/db2inst1/sqllib/lib64/libdb2e.so.1)
79-0x00002AD16D1F0476 _Z8sqlpgoleP9SQLP_DBCBPKcPP9SQLP_LECBjmPc+
0x05c6
80- (/data1/db2inst1/sqllib/lib64/libdb2e.so.1) |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 Version 10.5 Fix Pack 5. *
**************************************************************** |
| Local Fix: |
|
| Solution |
First fixed in Version 10.5 Fix Pack 5. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.09.2014
12.02.2015
12.02.2015 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 10.5.0.5
|
 |
