IBM Support

OmniFind documentation, articles, useful tips

Question & Answer


Question

Where can I find documentation and tips regarding the usage and optimization of the OmniFind product?

Cause

Information on the OmniFind product is scarce and inconsistent on the web.

Answer

This document seeks to provide the general users of the OmniFind product with all the information they would need to properly utilize it's capabilities. The below is to be understood as a list of separate information sources that can be used to further strengthen/improve one's knowledge of the OmniFind Text Search Server for the IBM i operating system.

The documents and articles listed below are not directly related to each other but are rather gathered in one place in order to provide the clients with easy access to all available documentation at one place. The information is provided as is and any specific questions or concerns that clients may have are to be addressed via the regular support initiation process for further assistance.

As of 2023, OmniFind is a no charge LPP. Refer to IBM i Portfolio Simplification for steps to download through ESS.

1. OmniFind Articles:

 

2. OmniFind manuals:

 

3. OmniFind White Papers

4. Additional documents and resources:

 

5. How to completely clean up an environment before doing a fresh install of the OmniFind product:

If we want a totally clean system to install OmniFind, as if the system has never been installed with OmniFind before, the following should be done:


A) Stop and shut down OmniFind server

For V7R2 and later, issue the following instructions.

1) Issue STRSQL from 5250 command line

2) CALL SYSPROC.SYSTS_SHUTDOWN()

B) Clean up Catalog files

RUNSQLSTM SRCSTMF('/QOpenSys/QIBM/ProdData/TextSearch/resetOMF.sql') COMMIT(*NONE) NAMING(*SQL)


C) Uninstall OmniFind

1)  Issue DLTLICPGM LICPGM(5733OMF) from a 5250 command line

You should receive messages similar to the ones below (n is the release number): 

*LNG objects for NLV 2924 for product 5733OMF option *BASE release V1RnM0 deleted.

*PGM objects for product 5733OMF option *BASE release V1RnM0 deleted. 

Objects for product 5733OMF option *ALL release *ONLY deleted.

2) Verify that library QDBTSLIB does not exist, delete it if exists via DLTLIB QDBTSLIB


D) Manually remove IFS directories (some directories will be preserved during the uninstall)

1)  Start QShell from a 5250 command line - QSH

2) Run the following: rm -r /QOpenSys/QIBM/ProdData/TextSearch

 

6.OmniFind indexing of partitioned tables
When a text search index is built over a range partitioned table, the text index is created over the entire table. The index cannot be isolated to a particular partition.

It is not possible for keys in another member to cause duplicate keys in the text search index.
http://publib.boulder.ibm.com/infocenter/iseries/v7r1m0/index.jsp?topic=/dbmult/partrestrict.htm

Important considerations:
- A primary key cannot be built over a single partition.
- A unique index must contain all keys that make up the partition. (Else SQLSTATE 42997)
- Records are not allowed to be moved from one partition to another (must be dropped and inserted)
- OmniFind Triggers fire for all members of the partition.

[{"Type":"MASTER","Line of Business":{"code":"LOB68","label":"Power HW"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SWG60","label":"IBM i"},"ARM Category":[{"code":"a8m0z0000001gofAAA","label":"IBM i Db2-\u003EOmnifind (5733OMF)"}],"ARM Case Number":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"All Versions"}]

Document Information

Modified date:
13 May 2026

UID

nas8N1022233

Page Feedback