|
Problem IC62537
|
Status: Closed |
Index marked bad during upgrade causes upgrade to fail when bad index is used before it is rebuilt |
| product: |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 |
| Problem description: |
Upgrade can fail when an index is marked for recreation during
the upgrade process and that index is later needed before the
index is actually recreated.
As part of the upgrade, index pages may need to be expanded to
handle additional information. If there is not sufficient room
in the index page, the index will be flagged as needing to be
rebuilt.
The marking of indexes to be rebuilt is not an error in
processing and may be expected in some circumstances:
2009-08-10-22.08.56.934351-240 I108371A581 LEVEL: Info
PID : 430200 TID : 2315 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.090811020855
AUTHID : DB2INST1
EDUID : 2315 EDUNAME: db2agent (SAMPLE ) 0
FUNCTION: DB2 UDB, index manager, sqliMigrateRootPage, probe:31
DATA #1 : <preformatted>
Index will be marked to be rebuilt and migration will continue.
Root page=2 index IID= 1
TableSpaceID=0 TableId=31 Index_TableSpaceId=0 Index_ObjectId=31
2009-08-10-22.08.56.946684-240 E108953A538 LEVEL: Warning
PID : 430200 TID : 2315 PROC : db2sysc
0
INSTANCE: instpm1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.090811020855
AUTHID : DB2INST1
EDUID : 2315 EDUNAME: db2agent (SAMPLE ) 0
FUNCTION: DB2 UDB, index manager, sqliMigrateIndexes, probe:421
MESSAGE : ADM9516W Indexes on the table
"TBSPACEID=0.TABLEID=31" were marked
to be rebuilt while upgrading the database.
However, in some cases, the index may need to be referenced
before the upgrade has rebuilt the index. In those cases, an
error may be reported which will halt the upgrade:
2009-08-10-22.08.58.970597-240 I258972A895 LEVEL: Severe
PID : 430200 TID : 2315 PROC : db2sysc
0
INSTANCE: db2inst1 NODE : 000 DB : SAMPLE
APPHDL : 0-7 APPID:
*LOCAL.db2inst1.090811020855
AUTHID : DB2INST1
EDUID : 2315 EDUNAME: db2agent (SAMPLE ) 0
FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc,
probe:300
DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes
sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 sqlerrml: 70
sqlerrmc: SYSROUTINES Migration DMS rc=8404007e: Fetch BNAME
for specific routin
sqlerrp : SQLRM14A
sqlerrd : (1) 0x00000002 (2) 0xFFFFFFFF (3)
0x00000000
(4) 0x00000003 (5) 0xFFFFF6C7 (6)
0x00000000
sqlwarn : (1) (2) (3) (4) (5) (6)
(7) (8) (9) (10) (11)
sqlstate: |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* All *
****************************************************************
* PROBLEM DESCRIPTION: *
* Upgrade can fail when an index is marked for recreation *
* during *
* the upgrade process and that index is later needed before *
* the *
* index is actually recreated. *
* *
* *
* *
* As part of the upgrade, index pages may need to be expanded *
* to *
* handle additional information. If there is not sufficient *
* room *
* in the index page, the index will be flagged as needing to *
* be *
* rebuilt. *
* *
* *
* *
* The marking of indexes to be rebuilt is not an error in *
* *
* processing and may be expected in some circumstances: *
* *
* *
* *
* *
* *
* 2009-08-10-22.08.56.934351-240 I108371A581 LEVEL: *
* Info *
* PID : 430200 TID : 2315 PROC : *
* db2sysc *
* 0 *
* *
* INSTANCE: db2inst1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-7 APPID: *
* *
* *LOCAL.db2inst1.090811020855 *
* *
* AUTHID : DB2INST1 *
* *
* EDUID : 2315 EDUNAME: db2agent (SAMPLE ) *
* 0 *
* FUNCTION: DB2 UDB, index manager, sqliMigrateRootPage, *
* probe:31 *
* DATA #1 : <preformatted> *
* *
* Index will be marked to be rebuilt and migration will *
* continue. *
* Root page=2 index IID= 1 *
* *
* TableSpaceID=0 TableId=31 Index_TableSpaceId=0 *
* Index_ObjectId=31 *
* *
* *
* 2009-08-10-22.08.56.946684-240 E108953A538 LEVEL: *
* Warning *
* PID : 430200 TID : 2315 PROC : *
* db2sysc *
* 0 *
* *
* INSTANCE: instpm1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-7 APPID: *
* *
* *LOCAL.db2inst1.090811020855 *
* *
* AUTHID : DB2INST1 *
* *
* EDUID : 2315 EDUNAME: db2agent (SAMPLE ) *
* 0 *
* FUNCTION: DB2 UDB, index manager, sqliMigrateIndexes, *
* probe:421 *
* MESSAGE : ADM9516W Indexes on the table *
* *
* "TBSPACEID=0.TABLEID=31" were marked *
* *
* to be rebuilt while upgrading the database. *
* *
* *
* *
* *
* *
* *
* *
* However, in some cases, the index may need to be referenced *
* *
* before the upgrade has rebuilt the index. In those cases, *
* an *
* error may be reported which will halt the upgrade: *
* *
* *
* *
* *
* *
* 2009-08-10-22.08.58.970597-240 I258972A895 LEVEL: *
* Severe *
* PID : 430200 TID : 2315 PROC : *
* db2sysc *
* 0 *
* *
* INSTANCE: db2inst1 NODE : 000 DB : *
* SAMPLE *
* APPHDL : 0-7 APPID: *
* *
* *LOCAL.db2inst1.090811020855 *
* *
* AUTHID : DB2INST1 *
* *
* EDUID : 2315 EDUNAME: db2agent (SAMPLE ) *
* 0 *
* FUNCTION: DB2 UDB, relation data serv, sqlrr_dump_ffdc, *
* *
* probe:300 *
* *
* DATA #1 : SQLCA, PD_DB2_TYPE_SQLCA, 136 bytes *
* *
* sqlcaid : SQLCA sqlcabc: 136 sqlcode: -902 *
* sqlerrml: 70 *
* sqlerrmc: SYSROUTINES Migration DMS rc=8404007e: Fetch *
* BNAME *
* for specific routin *
* *
* sqlerrp : SQLRM14A *
* *
* sqlerrd : (1) 0x00000002 (2) 0xFFFFFFFF (3) *
* *
* 0x00000000 *
* *
* (4) 0x00000003 (5) 0xFFFFF6C7 (6) *
* *
* 0x00000000 *
* *
* sqlwarn : (1) (2) (3) (4) (5) *
* (6) *
* (7) (8) (9) (10) (11) *
* *
* sqlstate: *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Version 9.7 Fix Pack 1 or later. *
**************************************************************** |
| 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 |
Problem was first fixed in Version 9.7 Fix Pack 1. |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 13.08.2009
22.12.2009
22.12.2009 |
| Problem solved at the following versions (IBM BugInfos) |
9.7.FP1
|
| Problem solved according to the fixlist(s) of the following version(s) |
| 9.7.0.1
|
 |
