By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,610 Members | 1,672 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,610 IT Pros & Developers. It's quick & easy.

DB2 z/OS Text Searching

P: n/a
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

Jan 31 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Anyone?
Feb 2 '07 #2

P: n/a
On Feb 2, 10:08 pm, "Spencer" <spen...@tabbert.netwrote:
Anyone?

I can't answer your question myself, but suggest you try the DB2-L
Listserve group, which works via email. As I understand it, this group
is primarily used by users of Windows and Unix, whereas the listserve
group is primarily used for IBM mainframes.

Try sending the message "subscribe db2-l Larry Ludwig"
to li******@www.idugdb2-l.org. It's some time since I subscribed so
you might like tor check the subscribing details on google, I also got
the following information when I originally subscribed, but have since
unsubscribed, so don't know if it's up to date.

More information on LISTSERV commands can be found in the
LISTSERV
reference card, which you can retrieve by sending an "INFO
REFCARD"
command to LI******@WWW.IDUGDB2-L.ORG.

Robert

Feb 3 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.