DB2 FOR LUW / DB2FORLUW / 970 - DB2

When migrating to v9.7, the root page of an index is also 
migrated. If db2 does not find enough space on the root page to 
migrate it, it will mark the index invalid.  These indexes are 
rebuilt in the later part of the migration. 
. 
. 
Similarly, When there isn't enough space on the root page of the 
indexes on SYSIBM.SYSTABLESPACES, we mark the indexes invalid. 
You will see following db2diag.log entry: 
. 
. 
FUNCTION: DB2 UDB, index manager, sqliMigrateRootPage, 
probe:8796043655424 
DATA #1 : <preformatted> 
Index will be marked to be rebuilt and migration will 
continue. 
Root page=5 index IID= 4 
TableSpaceID=0 TableId=16 Index_TableSpaceId=0 
Index_ObjectId=16 
. 
. 
In this case tableid=16, tablespaceid=0 refers to table 
SYSIBM.SYSTABLESPACES. 
. 
. 
Later in the migration where we try to scan the catalog table 
with the bad index, we get stuck into a loop with the following 
entries repeating in the db2diag.log: 
. 
. 
FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:7390^M 
MESSAGE : ADM5572I  One or more indexes on table 
"TBSPACEID=0.TABLEID=16" are marked invalid and require 
rebuilding. 
.

When migrating to v9.7, the root page of an index is also 
migrated. If db2 does not find enough space on the root page to 
migrate it, it will mark the index invalid.  These indexes are 
rebuilt in the later part of the migration. 
. 
. 
Similarly, When there isn't enough space on the root page of the 
indexes on SYSIBM.SYSTABLESPACES, we mark the indexes invalid. 
You will see following db2diag.log entry: 
. 
. 
FUNCTION: DB2 UDB, index manager, sqliMigrateRootPage, 
probe:8796043655424 
DATA #1 : <preformatted> 
Index will be marked to be rebuilt and migration will 
continue. 
Root page=5 index IID= 4 
TableSpaceID=0 TableId=16 Index_TableSpaceId=0 
Index_ObjectId=16 
. 
. 
In this case tableid=16, tablespaceid=0 refers to table 
SYSIBM.SYSTABLESPACES. 
. 
. 
Later in the migration where we try to scan the catalog table 
with the bad index, we get stuck into a loop with the following 
entries repeating in the db2diag.log: 
. 
. 
FUNCTION: DB2 UDB, data management, sqldLoadTCB, probe:7390^M 
MESSAGE : ADM5572I  One or more indexes on table 
"TBSPACEID=0.TABLEID=16" are marked invalid and require 
rebuilding.

REORG or recreate indexes on SYSIBM.SYSTABLESPACES before the 
migration.  This will create enough space on the root page to 
allow the migration or the root page. Hence, the index will not 
be marked invalid.

DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 3a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 4 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 5 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 6 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 7 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 8 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 9 for Linux, UNIX, and Windows
 DB2 Version 9.7 Fix Pack 10 for Linux, UNIX, and Windows
 

Defect   => wsdbu00604952 
Fixed in => V9.7 + FP2 
Module   => ENGN_SQRL

REORG or recreate indexes on SYSIBM.SYSTABLESPACES before the 
migration.  This will create enough space on the root page to 
allow the migration or the root page. Hence, the index will not 
be marked invalid.

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

14.12.2009
10.06.2010
10.06.2010

9.7.