|
Problem IC98263
|
Status: Closed |
AFTER PERFORMING AN OFFLINE REORG IN HADR ENVIRONMENT, INDEX SMS TABLESPACES HAVE DIFFERENT SIZES ON PRIMARY COMPARED TO STANDBY |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
After performing an offline reorg in HADR environment, index SMS
tablespaces have different sizes on Primary compared to Standby.
The reason being is that the index manager does not write its
own log record to trigger the truncate on redo. As a result,
when the logs are replayed on the Standby this doesn't take
effect. This causes a difference in the size of index SMS
tablespaces.
The index manager should write it's own log record to trigger
the truncate on redo. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to DB2 version 9.7.0.10. *
**************************************************************** |
| Local Fix: |
|
| Solution |
The problem is first fixed in DB2 version 9.7.0.10. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 11.12.2013
10.11.2014
10.11.2014 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.0.10
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.10
|
 |
