Troubleshooting invalid entries in administration tables

Invalid entries in the SYSIBMTS.SYSTEXTSERVERS and SYSIBMTS.SYSTEXTCONNECTINFO administration tables can result in messages that you can easily troubleshoot.

The following list provides descriptions of the possible invalid entries in the SYSIBMTS.SYSTEXTSERVERS and SYSIBMTS.SYSTEXTCONNECTINFO administration tables, the messages that result, and how you can troubleshoot these issues.

  • Incorrect values for SERVERAUTHTOKEN, SERVERNAME, or SERVERPORT in the SYSIBMTS.SYSTEXTSERVERS administration table result in the following message from the SYSTS_START stored procedure: 
    OF00317E [n] text search servers are not available. Check the console messages
for details.
    This message is accompanied by one or more console messages for the servers that fail: 
    +DSN5001I  ERROR OCCURRED WHILE CONTACTING OMNIFIND SERVER [server name]:
[port number] FOR SYSPROC.SYSTS_START ON COLLECTION
    To troubleshoot this issue, compare the values for SERVERAUTHTOKEN, SERVERNAME, and SERVERPORT, and verify that the server name and port number in the console message are correct for the text search server. Also, verify that you inserted the correct, case-sensitive SERVERAUTHTOKEN value from the text search server.
  • Incorrect values for SERVERAUTHTOKEN, SERVERNAME, or SERVERPORT in the SYSIBMTS.SYSTEXTSERVERS stored procedure might result in the following messages from the SYSTS_CREATE stored procedure: 
    OF00325E No text search server in table 'SYSIBMTS'.'SYSTEXTSERVERS' was able to 
perform the requested operation. Check the table entries, server, and network 
status. OF00801E A text search engine operation failed. Message code: 
ERR_CONNECT_SERVER. Exception oss::BaseException: "A connection could not be 
established with server [server name] on port [port number]. " was thrown in 
file /u/BCKE/ofbuild.851/wc.31bit/sutterr3c/src/components/comm/src/
cieWhitneyClient.cpp line 240.
    To troubleshoot this issue, compare the values for SERVERAUTHTOKEN, SERVERNAME, and SERVERPORT, and verify that the server name and port number in the console message are correct for the text search server. Also, verify that you inserted the correct, case-sensitive SERVERAUTHTOKEN value from the text search server.
  • An incorrect value for DB2ENCRYPTEDPW in the SYSIBMTS.SYSTEXTSERVERS table results in the following messages from the SYSTS_CREATE stored procedure: 
    DSN20427E ERROR OCCURRED DURING TEXT SEARCH ADMINISTRATION STORED PROCEDURE 
OF00325E No text search server in table 'SYSIBMTS'.'SYSTEXTSERVERS' was able 
to perform the requested operation. Check the table entries, server, and 
network status. OF00800E A text search server operation failed. Message code: 
IQQG0020E. Exception  : 'IQQG0020E ExtendedException: [...]'  where [...] 
stands for the reason codes from the text search server.
    Update the DB2ENCRYPTEDPW value by calling the SYSTS_ENCRYPT function with the correct input parameters. These input parameters are the SERVERMASTERKEY from the same row in the SYSIBMTS.SYSTEXTSERVERS table and the password for the user ID that you inserted in DB2UID in the SYSIBMTS.SYSTEXTCONNECTINFO table. Verify that you inserted the correct, case-sensitive SERVERMASTERKEY value from the text search server.

    Incorrect values for DB2HOSTNAME, DB2SERVICEPORT, or DB2UID in the SYSIBMTS.SYSTEXTCONNECTINFO table also result in a DSN20427E message from the SYSTS_CREATE stored procedure. You can troubleshoot this issue in the same way.