Specific to upgrade from v9.1 to v9.7, database upgrade can
fail when catalog index on SYSIBM.SYSTABLES is marked
for recreation during the upgrade and the database contains
user partitioned tables.
As part of the upgrade, index root pages may need to be
expanded to handle additional information. If there is not
sufficient room in the index root page, the index will be
flagged as
needing to be rebuilt. If index of SYSIBM.SYSTABLES
is marked to be rebuilt and database
contains user partitioned tables, the database upgrade fails
during SYSDATAPARTITIONS migration. The db2diag.log has the
following error messages:
2009-10-01-14.16.08.157791-240
I345321A598 LEVEL: Info PID : 369596
TID : 1821 PROC : db2syscINSTANCE: katylao2
NODE : 000 DB : SYSTAB APPHDL : 0-13
APPID: *LOCAL.katylao2.091001180946
AUTHID : KATYLAO2
EDUID : 1821
EDUNAME: db2agent (SYSTAB ) FUNCTION: DB2 UDB, index
manager, sqliMigrateRootPage,
probe:14685055086129564619
DATA #1 : <preformatted>
Index will be marked to be rebuilt and migration will continue.
Root page=105 index IID= 0
TableSpaceID=0 TableId=5 Index_TableSpaceId=0 Index_ObjectId=5
<....>
2009-10-01-14.22.02.555274-240 I556179A498 LEVEL:
WarningPID : 369596 TID : 1821 PROC :
db2syscINSTANCE: katylao2 NODE : 000 DB :
SYSTAB APPHDL : 0-13 APPID:
*LOCAL.katylao2.091001180946
AUTHID : KATYLAO2
EDUID : 1821 EDUNAME: db2agent (SYSTAB )
FUNCTION: DB2 UDB, catalog migration, sqlrlm_catalog_migrate,
probe:4754
DATA #1 : <preformatted>
Catalog table: SYSTABLES:FID(5) TID(0) Migration Status: 2
<....>
2009-10-01-14.36.57.801996-240 I762315A861 LEVEL: Info
PID : 369596 TID : 1821 PROC :
db2syscINSTANCE: katylao2 NODE : 000 DB :
SYSTAB APPHDL : 0-13 APPID:
*LOCAL.katylao2.091001180946
AUTHID : KATYLAO2
EDUID : 1821 EDUNAME: db2agent (idle)
FUNCTION: DB2 UDB, oper system services, sqlofica, probe:10
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 49
sqlerrmc: SYSDATAPARTITIONS Migration DMS rc=8404007e: Open
sqlerrp : SQLRM094
sqlerrd : (1) 0x801A006D (2) 0x00000001 (3)
0x00000000
(4) 0x00000003 (5) 0xFFFFDEE7 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: 58005 |
