We have z/OS and DB2 v7. I have various fields on tables that I need
to perform searching through using the LIKE operator and wildcards
such as %. Currently on our million row plus tables the performance
we are getting is like 25 seconds for this query to execute solely
because have to do a table scan. I can't believe that there isn't a
better way to do full text indexing for DB2 on z/OS such that I can
get near sub-second response on the queries we are issuing.
Is the DB2 Universal Database Text Extender for z/OS located here the
product we should be looking at? http://www-306.ibm.com/software/data/
db2/extenders/text/te390/ It doesn't appear there is a cost to this
product, correct? Are there anymore additional technical documents
regarding this extender that are more developer oriented?
Spencer