Extensions to Index and Search Non-DB2 Data

The OmniFind Text Search for DB2® for i provides an additional set of stored procedures to create, administer, and search text search collections.

Extensions Overview
OmniFind Text Search Server for DB2 for i provides an additional set of stored procedures to create, administer, and search text search collections. A text search collection is used to index data associated with system objects such as spool files in an output queue, or stream file data in the integrated file system.
Creating a Text Search Collection
This procedure creates an empty search collection. An SQL schema will be created on the system to contain information about the collection. The schema will contain DB2 objects necessary to track and index objects.
Adding an Object Set for Spool File Data
The stored procedure is in the DB2 schema to add an object set for spool file data.
Removing Object Set for Spool File Data
This stored procedure will remove an object set for spool file data from a text search collection.
Adding an Object Set for Stream File Data
The stored procedure is in the DB2 schema to add an object set for stream file data.
Removing Object Set for Stream File Data
The stored procedure is in the DB2® schema to remove an object set for stream file data.
Adding an Object Set for Multiple Members Source Physical File
The stored procedure is in the DB2® schema to remove an object set for multi-member source physical file.
Removing an Object Set for Multiple Members Source Physical File
The stored procedure is in the DB2® schema to remove an object set for multi-member source physical file.
Removing an Object Set
This stored procedure will remove an object set from a text search collection.
Update the Collection
This stored procedure updates the collection. When called initially, all objects included in the object sets for the collection are indexed. When this stored procedure is called after a successful initial update has completed, all changed objects are updated in the index. The procedure will not return control to the caller until after the update has completed.
Repopulate the Text Search Collection
The REPRIME stored procedure clears the collection, and then performs an initial update. The procedure will not return control to the caller until after the update has completed.
Search the Collection
This procedure allows a user to search a text search collection for objects that match a search.
Query Object Set Information
This procedure allows a user to see the list of object sets that are contained within the collection.
Retrieve Status of Indexes Objects
This procedure returns the status of all objects in the text search collection.
Get Objects Not Indexed
This procedure returns the objects which are not indexed in the text search collection.
Retrieve Status of Collection
This procedure returns the status of the text search collection.
Dropping a Text Search Collection
This procedure removes a text search collection from the system.
Altering a Text Search Collection
You can call this stored procedure to modify attributes of a collection that was created by SYSPROC.SYSTS_CREATE_COLLECTION. Only attributes explicitly specified on this procedure are changed. All other attributes of the index remain unchanged.
Independent ASP Considerations for Text Search Collections
IASP considerations for a text search collection.
Backup and Restore Considerations for Text Search Collections
Saving and restoring a text search collection.

Parent topic: OmniFind Text Search Server for DB2 for i