|
Problem IT20912
|
Status: Closed |
UPGRADING DB2 V10.1 TO V11.1 WITH TEXT SEARCH RESULTS IN INCORRECT CATALOG UPDATE |
| product: |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 |
| Problem description: |
When upgrading from DB2 v10.1 to v11.1 with a custom install
selecting DB2 Text Search, the upgrade leaves text search in an
incorrect intermediary state. The proper upgrade procedure from
10.1 to 11.1 should work by initially updating 10.1 to 10.5 then
from 10.5 to 11.1. There is a bug with an incorrect catalog
update which mistakenly skips the last update step. |
| Problem Summary: |
****************************************************************
* USERS AFFECTED: *
* ALL *
****************************************************************
* PROBLEM DESCRIPTION: *
* See Error Description *
****************************************************************
* RECOMMENDATION: *
* Upgrade to Db2 11.1 Mod 3 Fix Pack 3 or higher *
**************************************************************** |
| Local Fix: |
Run the following commands:
1) db2 "update sysibmts.systsdefaults set value = 'DB2
11.01.0000' WHERE NAME='VERSION'"
2) db2 "CALL SYSPROC.SYSTS_UPGRADE_CATALOG('', ?)"
3) db2 "CALL SYSPROC.SYSTS_UPGRADE_INDEX('', ?)" |
| available fix packs: |
Db2 Version 11.1 Mod 3 Fix Pack 3 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix001 for Linux, UNIX, and Windows
Db2 Version 11.1 Mod3 Fix Pack3 iFix002 for Linux, UNIX, and Windows
|
| Solution |
First fixed in Db2 11.1 Mod 3 Fix Pack 3 |
| Workaround |
not known / see Local fix |
| Timestamps |
Date - problem reported :
Date - problem closed :
Date - last modified :
| 07.06.2017
19.03.2018
19.03.2018 |
| Problem solved at the following versions (IBM BugInfos) |
|
| Problem solved according to the fixlist(s) of the following version(s) |
