home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
11.1.0.7 FixList
10.5.0.9 FixList
10.1.0.6 FixList
9.8.0.5 FixList
9.7.0.11 FixList
9.5.0.10 FixList
9.1.0.12 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

DB2 - Problem description

Problem IT06132 Status: Closed

ERRORS SUCH AS SQL20427N USING DB2 TEXT SEARCH IF THE APPLICATION CODE PAGE
IS NOT UTF-8.

product:
DB2 FOR LUW / DB2FORLUW / A50 - DB2
Problem description:
If the application code page is not UTF-8 then you might get 
errors when you run DB2 Text Search commands. 
For example, when you run the command: 
 db2ts UPDATE INDEX <index-name> FOR TEXT 
replacing <index-name> with the name of a text search index, you 
might get this error: 
 SQL20427N  An error occurred during a text search 
administration procedure or command. The error message is 
"CIE0341E Update index errors. [...]"
Problem Summary:
**************************************************************** 
* USERS AFFECTED:                                              * 
* All platforms                                                * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* See Error Description                                        * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to DB2 LUW v10.5 FixPack 7 or later.                 * 
****************************************************************
Local Fix:
As a workaround you can configure the operating system so that 
the application code page is UTF-8. 
 
For example, on AIX you can do that by logging in as root and 
running smit, then selecting: 
 System Environments -> 
 Manage Language Environment -> 
 Change/Show Primary Language Environment -> 
 Change/Show Cultural Convention, Language, or Keyboard 
then enter Esc+4 to List the available cultural conventions, 
highlight one for which the code page is UTF-8, and press Enter 
to accept it. 
Then reboot the machine in order for the change to take effect.
Solution
First fixed in DB2 LUW v10.5 FixPack 7.
Workaround
not known / see Local fix
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
17.12.2014
26.01.2016
26.01.2016
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)
10.5.0.7 FixList