home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Neueste VersionenFixList
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Haben Sie Probleme? - Kontaktieren Sie uns.
Kostenlos registrieren anmeldung-x26
Kontaktformular kontakt-x26

DB2 - Problembeschreibung

Problem IC75425 Status: Geschlossen

UPGRADE TO DB2 9.7 CAN REQUIRE AN UNEXPECTEDLY LONG TIME FOR INDEX REBUILD

Produkt:
DB2 FOR LUW / DB2FORLUW / 950 - DB2
Problembeschreibung:
In DB2 9.7 new meta data has been added to all index root pages. 
During database upgrade we check if there is enough space to 
upgrade the root page page and if there is not, then we mark the 
entire index object as invalid and the index will be rebuilt 
after database upgrade.  Index rebuild can take several hours 
and will acquire and hold a Z lock on the table for the entire 
duration of the index rebuild.  This can leave the database 
unusable for several hours after the upgrade. 
 
This change adds a new service option to the db2dart tool in 9.1 
so that a customer may determine which indexes will need to be 
rebuilt after database upgrade to DB2 9.7.  The new code will 
execute when db2dart is run with both the "/ico y" and "/serv 
16" options. 
Note:  This requires using the service password. 
 
Usage:  db2dart <dbName> /ico y /serv 16 /scr m /pw 
<servicePassword> 
 
The "/ico y /serv 16" can also be used with actions /DB (the 
default) or /T or /TS.
Problem-Zusammenfassung:
**************************************************************** 
* USERS AFFECTED:                                              * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* In DB2 9.7 new meta data has been added to all index root    * 
* pages.                                                       * 
* During database upgrade we check if there is enough space to * 
*                                                              * 
* upgrade the root page page and if there is not, then we mark * 
* the                                                          * 
* entire index object as invalid and the index will be rebuilt * 
*                                                              * 
* after database upgrade.  Index rebuild can take several      * 
* hours                                                        * 
* and will acquire and hold a Z lock on the table for the      * 
* entire                                                       * 
* duration of the index rebuild.  This can leave the database  * 
*                                                              * 
* unusable for several hours after the upgrade.                * 
*                                                              * 
*                                                              * 
*                                                              * 
* This change adds a new service option to the db2dart tool in * 
* 9.1                                                          * 
* so that a customer may determine which indexes will need to  * 
* be                                                           * 
* rebuilt after database upgrade to DB2 9.7.  The new code     * 
* will                                                         * 
* execute when db2dart is run with both the "/ico y" and       * 
* "/serv                                                       * 
* 16" options.                                                 * 
*                                                              * 
* Note:  This requires using the service password.             * 
*                                                              * 
*                                                              * 
*                                                              * 
* Usage:  db2dart <dbName> /ico y /serv 16 /scr m /pw          * 
*                                                              * 
* <servicePassword>                                            * 
*                                                              * 
*                                                              * 
*                                                              * 
* The "/ico y /serv 16" can also be used with actions /DB (the * 
*                                                              * 
* default) or /T or /TS.                                       * 
**************************************************************** 
* RECOMMENDATION:                                              * 
****************************************************************
Local-Fix:
Lösung
Workaround
keiner bekannt / siehe Local-Fix
Kommentar
The new db2dart option can be found in DB2 9.5.0.8.
Weitere Daten
Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:
30.03.2011
29.07.2011
29.07.2011
Problem behoben ab folgender Versionen (IBM BugInfos)
Problem behoben lt. FixList in der Version