IBM i Search Service / Application

[jyoung]

For all you IBM i gurus out there, is there an IBM i search service or application like AWS ElasticSearch, Azure Search or Apache's Solr?

We have some data that it would be really nice to have a fast, text based searching mechanic for. I've been thinking about trying to spin up Solr to allows to search for data more easily.

Current we use a File (Table) on the IBM i that has an index for words, but its not really accurate.

For example, if we have a user named "John Phillip Smith" with id 0001, then this index table would have

Code: Select all

John    | 0001
Phillip | 0001
Smith   | 0001

This makes it difficult to find users named "John Smith" without including ALL users that have John or Smith in the index. It makes it easy to find all the users named "John" OR "Smith" but not so much where the name is "John" AND "Smith"

I am thinking having a dedicated text based search engine would make the search faster and more accurate.

Thoughts?

Joe

[soa]

Have a look at Omnifind for iseries db2

https://www.ibm.com/support/knowledgece ... ickoff.htm

[soa]

Also there is something called db2 text extender which allows google type text searches over iseries tables.

I think this is a no charge licensed product.

http://www-01.ibm.com/support/docview.w ... sh12672001

[atostaine]

Joe: The IBM i experts mostly all hang out at a mailing list hosted at midrange.com. Midrange.com started as a BBS when the Sys/36 was still selling.

The midrange-l list is for general inquiries and the one I would ask your question to. There are other lists for RPG development, Web, etc.

Art