Health Checker

Health checker is an environment verification tool that can be used to diagnose any OmniFind Text Search Server for DB2® for i configuration problems. It can be used to verify that the OmniFind Text Search Server for DB2 for i text servers and indexes are correctly functioning, and will generate a report with warnings or errors for any potential issues found.

Prerequisites

The OmniFind Text Search Server for DB2 for i health checker is based on ARE (Application Runtime Expert for i, product 5770-ARE). Therefore, ARE must be installed for this tool to run.

Health Checker Procedures

Health checker is invoked through a series of DB2 SQL stored procedures. The procedures can be invoked through any SQL interface, including from a high level language such as RPG and COBOL. All information, including warnings or errors, is returned through a corresponding result set.

SYSPROC.SYSTS_HC_GENERAL()

This stored procedure is used to check the general health of the OmniFind Text Search Server for DB2 for i product. The procedure checks the configuration of the product. This is an example to return all warning and error messages related to general OmniFind Text Search Server for DB2 for i configuration information: 
> CALL SYSPROC.SYSTS_HC_GENERAL();

SYSPROC.SYSTS_HC_USR_AUTH()

This stored procedure is used to identify any authority issues for the invoking user that would prevent them from using the OmniFind Text Search Server for DB2 for i for searches. This is an example to return any warnings or errors regarding the invoking user’s authorities:
> CALL SYSPROC.SYSTS_HC_USR_AUTH();

SYSPROC.SYSTS_HC_IDX()

This stored procedure is used to check all OmniFind Text Search Server for DB2 for i text indexes to ensure they are in a valid state. Note: If using an IASP (Independent Auxiliary Storage Pool) group, this only applies to the IASP group currently active in the job.

SYSSTS.HC_SVR()

This stored procedure is used to check the health of all local OmniFind Text Search Server for DB2 for i text servers that have been defined.

Additional Information

More information about the OmniFind Text Search Server for DB2 for i health checker, including numerous additional stored procedures options as well as a QShell interface, is available on developerWorks OmniFind Text Search Server for DB2 for i under the article ’Health Checker’.