|
Problem IC62588
|
Status: Closed |
SLOW HADR STANDBY DEACTIVATION CAN CAUSE HADR PRIMARY TO PAUSE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
In an HADR environment, the deactivation of standby involves
flushing all dirty pages to disk. When the bufferpool is huge,
it may take some time to flush all the dirty pages, and if HADR
is in SYNC mode, the primary side will not be able to ship logs
to the standby during this period. The primary will appear to
hang until the standby is completely deactivated. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* In an HADR environment, the deactivation of standby involves *
* *
* flushing all dirty pages to disk. When the bufferpool is *
* huge, *
* it may take some time to flush all the dirty pages, and if *
* HADR *
* is in SYNC mode, the primary side will not be able to ship *
* logs *
* to the standby during this period. The primary will appear *
* to *
* hang until the standby is completely deactivated. *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 9.7 FP1 *
**************************************************************** |
| Local Fix: |
Tune softmax, chngpgs_thresh and/or use db2pdcfg -flushbp
to reduce the number of dirty pages in the standby bufferpool
before deactivating the database on the standby. |
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
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 9a 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 10 for Linux, UNIX, and Windows
|
| Solution |
Problem was first fixed in Version 9.7 Fix Pack 1 |
| Workaround |
Tune softmax, chngpgs_thresh and/or use db2pdcfg -flushbp
to reduce the number of dirty pages in the standby bufferpool
before deactivating the database on the standby. |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 19.08.2009
23.02.2010
23.02.2010 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
