DB2 FOR LUW / DB2FORLUW / 910 - DB2

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.

DB2 Version 9.1 Fix Pack 10  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 11  for Linux, UNIX and Windows
 DB2 Version 9.1 Fix Pack 12  for Linux, UNIX and Windows
 

keiner bekannt / siehe Local-Fix

a new service option to the db2dart tool in 9.1.0.10 so that a 
customer may determine which indexes will need to be 
rebuilt after database upgrade to DB2 9.7.

Vorgänger  : APAR is sysrouted TO one or more of the following: IC73478 IC73479 IC73480 IC75425 
Nachfolger : 

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

23.12.2010
14.06.2011
14.06.2011