|
Problem IC63527
|
Status: Closed |
INDEX ON SYSIBM.SYSTABLES MAY BE MARKED INVALID DURING UPGRADE CAUSING UPGRADE TO FAIL IF DATABASE CONTAINS PARTITIONED TABLES |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
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 |
| Problem Summary: |
INDEX ON SYSIBM.SYSTABLES MAY BE MARKED INVALID DURING UPGRADE
CAUSING UPGRADE TO FAIL IF DATABASE CONTAINS PARTITIONED TABLES |
| Local Fix: |
|
| available fix packs: |
DB2 Version 9.7 Fix Pack 1 for Linux, UNIX, and Windows
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 7 for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 9a for Linux, UNIX, and Windows
DB2 Version 9.7 Fix Pack 6 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
|
| Solution |
First fixed in DB2 UDB Version 9.7, FixPak 1 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 01.10.2009
28.12.2009
28.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
