|
Problem IT28321
|
Status: Closed |
NEW SEMI-DETACHED INDEX FRAGMENT INCURRED DURING LOGICAL RECOVERY WILL CAUSE DEFERRED INDEX RECREATION OF WHOLE INDEX
|
| product: |
INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10 |
| Problem description: |
Adding a new fragment to a fragmented table is a leight weight
operation even with indexes defined on it. In case of
'semi-detached' indices - no explicit storage specification, so
index following table's fragmentation - this would involve
equally simple and cheap index fragment creation.
If such new index fragment creation is incurred during logical
recovery, whether at server restart or during a logical restore,
it is deferred until after logical recovery completed, then
progressed on the final set of data. Yet now it's not only this
single new index fragment that's being created, but all
pre-existing fragments of this index would be dropped and
re-created as well - a potentially very costly and time
consuming operation delaying the affected table becoming fully
operational. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* Uses of IDS prior to 12.10.xC13. *
****************************************************************
* PROBLEM DESCRIPTION: *
* New semi-detached index fragment incurred during logical *
* recovery will cause deferred index recreation of whole *
* index. *
****************************************************************
* RECOMMENDATION: *
**************************************************************** |
| Local Fix: |
|
| Solution |
|
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 06.03.2019
26.09.2019
26.09.2019 |
| Problem solved at the following versions (IBM BugInfos) |
12.10.xC13
|
| Problem solved according to the fixlist(s) of the following version(s) |
