Troubleshooting SQL code -20423 with message OF00801E

Even though you can run administration stored procedures, SQL code -20423 with message OF00801E might be returned for only the CONTAINS function and the SCORE function.

About this task

The message text reads as follows:

SQLCODE = -20423, ERROR:  ERROR OCCURRED DURING TEXT SEARCH PROCESSING 
(server, indexname, OF00801E A text search engine operation failed. 
Message code: ERR_CONNECT_SERVER. Exception oss::BaseException: 
"A connection could not be established with server <server> on port 
<port number>." was thrown [...].)

Procedure

To resolve this problem:

  1. Assign an OMVS segment to the RACF® user ID that is associated with the DSNDBMI address space started task.
    Typically, this user ID is SYSDSP.
  2. Restart Db2 for z/OS®.