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. |
