Responding to an automatic takeover

If the SYSPROC.SYSTS_UPDATE stored procedure fails to update the text search index because of a problem with the text search server, a takeover is attempted.

About this task

Usually, such a problem is indicated by message DSN5001I. After attempting a takeover, the SYSPROC.SYSTS_UPDATE stored procedure returns SQLCODE -20427 and error message OF00010I. The message indicates whether a takeover on the text search index was successful.

Return code 0 indicates a successful takeover after an unsuccessful text search index update. The index is now on a new text search server but is not updated yet.

If the return code is not 0, neither the update operation or the takeover was successful. This indicates that every text search server that is listed in the SYSIBMTS.SYSTEXTSERVERS administration table has a problem.

The message text in the following example shows a return code of 0: 
OF00010I (DSN20427E ERROR OCCURRED DURING TEXT SEARCH ADMINISTRATION STORED
PROCEDURE OF00010I Index takeover attempted during update. Return code 0. 
For details see event table 'SYSIBMTS'.'EVENTS_1')

Procedure

To respond to this message:

Depending on the return code that is associated with this message, you must complete one of the following actions.
Option Description
Return code 0 Call the SYSPROC.SYSTS_UPDATE stored procedure again.
Return code other than 0
  1. Re-enable at least one of the text search servers. For example, if all of the servers are down, restart at least one of the servers.
  2. Call the SYSPROC.SYSTS_UPDATE stored procedure again.