|
Problem IC96452
|
Status: Closed |
HADR STANDBY CAN BE SLOW DUE TO INDEX MAINTENANCE |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
HADR standby can slow down due to index maintenance. The reason
is due to the fact that lot of the index page split, page merge
and other records generated in the log are mostly tablespace
blocking records which cause them to run serially on the same
tablespace.
Some log records related to create/reorg index have also had
their blocking level improved to allow for faster replay on the
standby. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Apply the workaround i..e spread the indexes in multiple *
* tablespaces and upgrade to DB v9.7 Fixpack 9 *
**************************************************************** |
| Local Fix: |
Spread the indexes to different tablespaces. |
| available fix packs: |
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 |
Fixed in DB2 v9.7 Fixpack 9. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 27.09.2013
16.12.2013
16.12.2013 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP9
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.9
|
 |
| 9.7.0.9
|
|
