|
Problem IC80105
|
Status: Closed |
MEMORY LEAK HAPPENS ON HADR PRIMARY WHEN HADR IS IN REMOTE CATCHUP STATE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
When HADR primary is in remote catchup state, 64 bytes memory
leak happens each time when db2lfr opens a log file to send to
standby. This could be very serious for HADR with superasync
mode, because HADR is always in remote catchup state with
superasync mode. When hitting this problem, dbheap can increase
very quickly. For example, from output of "db2pd -memb sort 2",
we can see many blocks as follows are left there and increase
quickly.
Memory blocks sorted by size for dbh pool:
PoolID PoolName TotalSize(Bytes) TotalCount LOC File
2 dbh 131703424 2057866 230
1727183880 |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* HADR *
****************************************************************
* PROBLEM DESCRIPTION: *
* When HADR primary is in remote catchup state, 64 bytes *
* memory leak happens each time when db2lfr opens a log file *
* to send to standby. This could be very serious for HADR with *
* superasync mode, because HADR is always in remote catchup *
* state with superasync mode. When hitting this problem, *
* dbheap can increase very quickly. For example, from output *
* of "db2pd -memb sort 2", we can see many blocks as follows *
* are left there and increase quickly. *
* *
* Memory blocks sorted by size for dbh pool: *
* PoolID PoolName TotalSize(Bytes) TotalCount LOC *
* File *
* 2 dbh 131703424 2057866 230 *
* 1727183880 *
****************************************************************
* RECOMMENDATION: *
* Update to version 9.7 fixpack 6 or later fixpacks. *
**************************************************************** |
| Local Fix: |
Use other HADR synchronous modes, eg. ASYNC or NEARSYNC. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
|
| Solution |
This problem is first fixed in version 9.7 fixpack 6. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 30.11.2011
04.06.2012
04.06.2012 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP6
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.6
|
 |
