Troubleshooting
Problem
Executing any select sql using the db2ext.contains function throws the following error: SQL0430N User defined function "DB2EXT.TEXTSEARCH_8K64" (specific name "CTE21") has abnormally terminated. SQLSTATE=38503
Symptom
Select sql returned the following error message:
SQL0430N User defined function "DB2EXT.TEXTSEARCH_8K64" (specific name "CTE21") has abnormally terminated. SQLSTATE=38503
The db2diag.log file will contain the following message:
CTE0101 A search engine operation failed. Reason code: "17", "100001", "0", "File read failed: 22
", "ItlClFileAccess::itlMread(char *&, off_t, size_t, int &), line 291".
Cause
The text index directory is on a filesystem that has CIO (Concurrent Input Output) enabled.
Environment
Linux, UNIX and AIX
Diagnosing The Problem
If the text index directory is on a filesystem that has CIO (Concurrent Input Output) enabled and text search returns SQL0430N User defined function "DB2EXT.TEXTSEARCH_8K64" (specific name "CTE21") has abnormally terminated. SQLSTATE=38503
Resolving The Problem
Disable the CIO on the filesystem that contains the text index directory.
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21516479