IBM Support

DB2 Net Search Extender text search terminates abnormaly with SQL0430N error message

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.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Extenders - Net Search","Platform":[{"code":"PF002","label":"AIX"}],"Version":"9.7;9.5;9.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}},{"Product":{"code":"SSEPFH","label":"Db2 Net Search Extender"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":" ","Platform":[{"code":"PF002","label":"AIX"}],"Version":"9.7;9.5;9.1","Edition":"All Editions","Line of Business":{"code":"","label":""}}]

Document Information

Modified date:
16 June 2018

UID

swg21516479