DB2 - Problembeschreibung
| Problem IT11882 | Status: Geschlossen |
TEXT SEARCH MIGRATION IS FAILING DURING DB2 MIGRATION FROM VERSION 9.7 TO 10.5 | |
| Produkt: | |
DB2 FOR LUW / DB2FORLUW / A50 - DB2 | |
| Problembeschreibung: | |
Text Search migration is failing during DB2 upgrade from version
9.7 to 10.5 with following error:
db2 "CALL SYSPROC.SYSTS_UPGRADE_INDEX('', ?)"
SQL20427N An error occurred during a text search administration
procedure or command. The error message is "CIE0320E Table space
"" does not exist."
SQLSTATE=38H14
In the database logs are following entries:
2015-09-03-15.42.43.658269+120 I126250A471 LEVEL: Error
PID : 27983912 TID : 12853 PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
HOSTNAME: host1
EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Text Search, CieDB2Catalog::checkTableSpace,
probe:2
MESSAGE : CIE reason
DATA #1 : Hexdump, 4 bytes
0x0A00000003BF4168 : 0000 0140
...@
2015-09-03-15.42.43.658749+120 I126722A461 LEVEL: Error
PID : 27983912 TID : 12853 PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
HOSTNAME: host1
EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary
logging function), probe:30
MESSAGE : Message
DATA #1 : String, 40 bytes
CIE0320E Table space "" does not exist.
2015-09-03-15.42.43.659228+120 I127184A458 LEVEL: Error
PID : 27983912 TID : 12853 PROC :
db2sysc
INSTANCE: db2inst1 NODE : 000 DB :
SAMPLE
HOSTNAME: host1
EDUID : 12853 EDUNAME: db2agent (SAMPLE) 0
FUNCTION: DB2 UDB, Text Search,
CieUpgradeVersion101::upgradeTSIndex,
probe:310
DATA #1 : <preformatted>
upgrading sysibmts.systsmodels failed during the text search
upgrade... | |
| Problem-Zusammenfassung: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 10.5 Fix Pack 5 * **************************************************************** | |
| Local-Fix: | |
| Lösung | |
First Fixed in DB2 10.5 Fix Pack 5 | |
| Workaround | |
keiner bekannt / siehe Local-Fix | |
| Weitere Daten | |
Datum - Problem gemeldet : Datum - Problem geschlossen : Datum - der letzten Änderung: | 21.10.2015 09.05.2017 09.05.2017 |
| Problem behoben ab folgender Versionen (IBM BugInfos) | |
| Problem behoben lt. FixList in der Version | |
| 10.5.0.7 |
|