DB2 - Problem description
Problem IT21801 | Status: Closed |
CTE0243 AND CTE0277 ERROR WHEN CALLING DB2EXT.TEXTSEARCH PROCEDURE EVEN THOUGH THE CACHE FOR THE INDEX IS ACTIVATED. | |
product: | |
DB2 FOR LUW / DB2FORLUW / B10 - DB2 | |
Problem description: | |
When calling db2ext.textSearch procedure, CTE0243 and CTE0277 error can occur even though the cache for the index is activated. This occurs due to wrong file permission for the persistent cache files. $ db2 "call db2ext.textSearch('"hoge"','NSE105F7','NSEIDX',0,0,0,0,?,?)" SQL0443N Routine "*XTSEARCH" (specific name "") has returned an error SQLSTATE with diagnostic text "CTE0243 The cache for text index "NSE105F7"."NSEIDX" has no". SQLSTATE=38843 Here is db2diag.log errors: 2016-11-08-00.36.49.110996+540 I241083E469 LEVEL: Error PID : 30430 TID : 140068639635264 PROC : db2fmp ( INSTANCE: nse105f7 NODE : 000 DB : P66566 APPID : *LOCAL.nse105f7.161107143608 HOSTNAME: hadr1 FUNCTION: DB2 UDB, Net Search Extender, CteIndexSharedMemory::CteIndexSharedMemory, probe:2 MESSAGE : CTE reason DATA #1 : Hexdump, 4 bytes 0x00007FFEE9F3CF80 : 1501 0000 .... 2016-11-08-00.36.49.124452+540 I241553E452 LEVEL: Error PID : 30430 TID : 140068639635264 PROC : db2fmp ( INSTANCE: nse105f7 NODE : 000 DB : P66566 APPID : *LOCAL.nse105f7.161107143608 HOSTNAME: hadr1 FUNCTION: DB2 UDB, trace services, sqlt_logerr_string (secondary logging function), probe:30 MESSAGE : Message DATA #1 : String, 53 bytes CTE0277 A cache memory segment could not be attached. 2016-11-08-00.36.49.127847+540 E242006E707 LEVEL: Warning PID : 30430 TID : 140068639635264 PROC : db2fmp ( INSTANCE: nse105f7 NODE : 000 DB : P66566 APPID : *LOCAL.nse105f7.161107143608 HOSTNAME: hadr1 FUNCTION: DB2 UDB, routine_infrastructure, sqlerFencedTruncateTokensUserSqlState, probe:100 DATA #1 : signed integer, 4 bytes -443 DATA #2 : String with size, 5 bytes 38843 DATA #3 : String with size, 17 bytes DB2EXT.TEXTSEARCH DATA #4 : String with size, 10 bytes TEXTSEARCH DATA #5 : String with size, 131 bytes CTE0243 The cache for text index "NSE105F7"."NSEIDX" has not been activated. CTE0277 A cache memory segment could not be attached. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * DB2 Text Search users * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 11.1 Mod 2 Fix Pack 2. * **************************************************************** | |
Local Fix: | |
Changing the group of the persistent cache files which are under the directory specified by CACHE TABLE PERSISTENT IN option to the secondary group used by NSE . | |
Solution | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : IT17953 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 04.08.2017 18.10.2017 18.10.2017 |
Problem solved at the following versions (IBM BugInfos) | |
Problem solved according to the fixlist(s) of the following version(s) |