DB2 - Problem description
Problem IT28188 | Status: Closed |
DB2TS UPDATE INDEX COMMAND FAILS WITH CIE00759 COMMUNICATION TIMEOUT AFTER 2-HOURS HANG | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
The document type affected by this defect is Office Open XML Format document (DOCX, PPTX, XLSX file), which file signature is not "50 4B 03 04 14 00 06 00", and has embedded image. When UPDATE INDEX command fails, the following IQQP0008W message with -20427 error code will be logged in the event view SYSIBMTS.TSEVENT_nnnnnn. OPERATION TIME SEVERITY SQLCODE MESSAGE ----------- -------------------------- ----------- ----------- ----------------------- 0 2017-06-13-11.18.33.902000 8 -20427 "IQQP0008W Unable to index document CAACAAAAAAAAAA==/ppt/media/image00.png because the binary filter was not found or the MIME type [image/png] is unsupported. In hanging UPDATE INDEX command case, the following CIE00759 message with -20427 error code will be logged in SYSIBMTS.TSEVENT_nnnnnn. OPERATION TIME SEVERITY SQLCODE MESSAGE ----------- -------------------------- ----------- ----------- ----------------------- - 2017-06-15-14.05.24.602000 8 -20427 CIE00759 Communications timeout on host named "unknown" and port "0". You will also see the IQQP0008W messages in default0.log and trace0.log files induced by "-logLevel FINER -trace on" option of admintool configureTrace command as well. IQQP0008W Unable to index document CAACAAAAAAAAAA==/word/media/image00.png because the binary filter was not found or the MIME type [image/png] is unsupported. This 2-hour timeout is configured by UPDATETIMEOUTINMINUTES in SYSIBMTS.SYSTSDEFAULTS table and you can reduce the hanging UPDATE INDEX command duration by tuning of UPDATETIMEOUTINMINUTES value as below. ex, update SYSIBMTS.SYSTSDEFAULTS set value = XXX where name='UPDATETIMEOUTINMINUTES' Note: This value should not be changed unless IBM Support suggests. Currently its default is 120 and valid range is 5 - 100000. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * ALL * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Will be fixed in DB2 v11.5 * **************************************************************** | |
Local Fix: | |
Solution | |
Workaround | |
not known / see Local fix | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 21.02.2019 02.10.2020 02.10.2020 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |