Wednesday, March 09, 2005

SQL0443N Routine "*RCH_1K16" (specific name "") has returned an error SQLSTATE with diagnostic text "CTE0101 A search engine operation failed

Received this error while trying to do db2text (NetSearchExtender) operation on a database that was restored from a different machine.

Noticed the text index was not there in the restored databases. Recreating & Updating the Text index helped.