Hi All!

I'm using DB2 text search for finding text in DBCLOB fields.
Code:
SET DB2DBDFT=DLIB

db2ts "START FOR TEXT"

db2ts "ENABLE DATABASE FOR TEXT"

db2ts "CREATE INDEX DLIB.TX_TEXT FOR TEXT ON DLIB.dl_documents(text)"

db2ts "UPDATE INDEX DLIB.TX_TEXT FOR TEXT"
And Test SQL Command -
Code:
SELECT COUNT(*) FROM DLIB.dl_vdoclinks d WHERE (CONTAINS(d.text, 'probe') = 1)
When there's one Text service on machine -DB2 Text Search (DB2TS) - DB2 finding requeired records.

Added DB2 Net Search Extender (DB2NSE) - and got -
DB2 SQL Error: SQLCODE=-21000, SQLSTATE=42724, SQLERRMC=null, DRIVER=3.63.123

DB2 Text Search or DB2 Net Search Extender is not installed or not properly configured on this server.

Both services started by /db2admin user.

Maybe OS first start DB2TS after DB2NSE? Is it so critical?
Or how properly install DB2TS together with DB2NSE?


I'm using Java (Hibernate) application as DB client.
DB2 version - 9.7.5 Workgroup Server