DB2 - Problem description
Problem IC65875 | Status: Closed |
DB2TS Update index returns SQL20427N error on Windows | |
product: | |
DB2 FOR LUW / DB2FORLUW / 970 - DB2 | |
Problem description: | |
Environment : 1. DB2 Version : DB2 9.7 Enterprise Edition 2. OS : Windows 2003 32bits 3. Symptoms : SQL20427N is returned during 'update index for text' Problem Discription: DB2 Text Search sends documents for processing and indexing to the TextServer component. The TextServer is a Java process which is currently started with a restrictive flag on Windows platforms. This can cause the following error: SQL20427N An error occurred during a text search administration procedure or command. The error message is 'CIE00341 Index update Error' SQLSTATE=38H14. | |
Problem Summary: | |
Users affected: All Problem Description: See above Problem Summary: See above | |
Local Fix: | |
Remove the flag "-Xjit:disableVMThreadGRA" from the Java call (line 69) in file startup.bat. The file can typically be found in C:\Program Files\IBM\SQLLIB\db2tss\bin. | |
available fix packs: | |
DB2 Version 9.7 Fix Pack 2 for Linux, UNIX, and Windows | |
Solution | |
First fixed in DB2 UDB Version 9.7 fp2 | |
Workaround | |
N/A | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 27.01.2010 10.08.2010 10.08.2010 |
Problem solved at the following versions (IBM BugInfos) | |
9.7.FP2 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.7.0.2 |