I'm trying to use DB2 Text Search with DB2 9.7 FP1 on Windows. Text search uses the standard configuration. Basically it works, it is possible to create and update text indexes for smaller tables, but if larger tables are used, the updates index runs for a long time and then crashes.
I created an index for text on a varchar column of a table with 45 000 rows. The update index command runs about 1 hour before it ends with an error. If I copy the table and reduce it to 10 rows the update index works.
I didn’t find a hint in the documentation how to change the configuration to support larger tables. Does anyone has an idea?
Command:
db2ts "update index vm.tlname1 for text"
Errors from event view:
'OPERATION' 'TIME' 'SEVERITY' 'SQLCODE' 'MESSAGE' 'PK01'
'2010-04-14-11.53.25.437000' 1 0 'CIE00003 Index update started. '
0 '2010-04-14-12.56.47.609000' 8 -20427 'CIE00701 Internal Error. Position: "1082", "2". CIE00701 Internal Error. Position: "1086", "2". ' 1046793
'2010-04-14-12.56.54.609000' 8 -20427 'CIE00756 Connection to Host "localhost" on Port "55000" failed. '
'2010-04-14-12.56.54.609000' 1 0 'CIE00004 Index update stopped’
Part of db2diag.log at error time:
2010-04-14-12.56.47.562000+120 I85197002H420 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, Text Search, CieWorkQueue::waitForElementInList, probe:2
MESSAGE : CIE reason
DATA #1 : Hexdump, 4 bytes
0x0012DF88 : BD02 0000 ....
2010-04-14-12.56.47.562000+120 I85197424H415 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : Message
DATA #1 : String, 49 bytes
CIE00701 Interner Fehler. Position: "1086", "2".
2010-04-14-12.56.47.562000+120 I85197841H423 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, Text Search, CieParserResultReceiverQueue::reserve, probe:2
MESSAGE : CIE reason
DATA #1 : Hexdump, 4 bytes
0x0012E570 : BD02 0000 ....
2010-04-14-12.56.47.562000+120 I85198266H415 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : Message
DATA #1 : String, 49 bytes
CIE00701 Interner Fehler. Position: "1082", "2".
2010-04-14-12.56.50.562000+120 I85198683H417 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, Text Search, CieError::makeDiagnosticMessage, probe:1
MESSAGE : CIE reason
DATA #1 : Hexdump, 4 bytes
0x0012DF88 : F402 0000 ....
2010-04-14-12.56.50.578000+120 I85199102H455 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : Message
DATA #1 : String, 89 bytes
CIE00756 Verbindungsherstellung ist auf Host "localhost" an Port "55000" fehlgeschlagen.
2010-04-14-12.56.50.578000+120 I85199559H343 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
MESSAGE : CIE reason
DATA #1 : Hexdump, 4 bytes
0x0012DF88 : F502 0000 ....
2010-04-14-12.56.50.578000+120 I85199904H440 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : Message
DATA #1 : String, 74 bytes
CIE00757 Empfang ist auf Host "localhost" an Port "55000" fehlgeschlagen.
2010-04-14-12.56.54.593000+120 I85200346H343 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
MESSAGE : CIE reason
DATA #1 : Hexdump, 4 bytes
0x0012DF88 : F502 0000 ....
2010-04-14-12.56.54.593000+120 I85200691H440 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging fu, probe:0
MESSAGE : Message
DATA #1 : String, 74 bytes
CIE00757 Empfang ist auf Host "localhost" an Port "55000" fehlgeschlagen.
2010-04-14-12.56.54.593000+120 I85201133H417 LEVEL: Severe
PID : 4756 TID : 5748 PROC : cieadmsv.exe
INSTANCE: DB2 NODE : 000
APPID : *LOCAL.DB2.100414143315
EDUID : 5748
FUNCTION: DB2 UDB, Text Search, CieError::makeDiagnosticMessage, probe:1
MESSAGE : CIE reason
DATA #1 : Hexdump, 4 bytes
0x0012DF88 : F402 0000 ....