DB2 - Problem description
Problem IT24115 | Status: Closed |
DB2ACD MIGHT INCORRECTLY CHOOSE INDEX REBUILD DURING AUTOMATIC TABLE MAINTENANCE EVEN WHEN NO OFFLINE WINDOW IS AVAILABLE | |
product: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
Problem description: | |
The db2acd might choose index rebuild when reorg is necessary for an index. When no offline window is setup e.g. in the auto maintenance policies the reorg might fail with: SQL22022N The duration of the maintenance window is not long enough to run the maintenance activity. Due to this, the index will not be reorganized and might take more space and might have a higher number of levels than necessary. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Upgrade to Db2 Version 10.5 Fix Pack 10. * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT24004 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 19.02.2018 12.07.2018 12.07.2018 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |