IBM OmniFind Text Search Server for DB2 for i5/OS enables full-text searching in integrated information environments

IBM United States Software Announcement 208-020
January 29, 2008


 ENUS208020.PDF (26KB)


Table of contents  Document options  
TOC link At a glance TOC link Publications
TOC link Overview TOC link Technical information
TOC link Key prerequisites TOC link Ordering information
TOC link Planned availability date TOC link Terms and conditions
TOC link Description TOC link IBM Electronic Services
TOC link Product positioning TOC link Prices
TOC link Offering Information TOC link Order now
Printable version Printable version

At a glance

OmniFind Text Search Server for DB2 for i5/OS delivers enhanced text search facilities within a database application development environment. OmniFind offers these technology and business benefits:

  • Improves knowledge worker productivity by breaking down information silos and making relevant information available quickly and easily.
  • Helps reduce the risk of unauthorized access by respecting the security of the underlying sources, and delivering a highly secure search experience every time.
  • Minimizes total cost of ownership by implementing a search system designed to integrate with your existing infrastructure.

For ordering, contact:

Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: AE001).
Back topBack to top


OmniFind™ Text Search Server for DB2® for i5/OS™ enables full-text document searching in DB2. Text search allows you to select a DB2 record based on the text of one or more documents stored in the record itself. Documents stored in DB2 are indexed by a search server and the resulting index stored in the server's file system. When a full-text search is performed against the DB2 stored documents, the search expression is compared with the index. Any records that match the search criteria are returned in the result rows.
Back topBack to top

Key prerequisites

i5/OS V6R1
Back topBack to top

Planned availability date

May 9, 2008
Back topBack to top


OmniFind Text Search Server for DB2 for i5/OS (5733-OMF)

OmniFind Text Search Server for DB2 for i5/OS enables full-text document searching in DB2. Text search allows you to find a DB2 record based on the text contained in the document itself. Documents are processed by a search server and stored in a file system and DB2. When a full-text search is performed, the search expression is compared with the index, and any records that contain your search text are returned in the search results.

The following document types are supported:

  • XML
  • HTML
  • Rich Text Format (RTF)
  • JustSystems Ichitaro
  • Lotus® 123
  • Lotus Freelance®
  • Lotus WordPro
  • Microsoft® Excel
  • Microsoft PowerPoint
  • Microsoft Word
  • PDF

A text index can be created over any character or binary data column:

  • BLOB
  • CHAR (FOR bit data, for mixed data, for sbcs data)
  • VARCHAR (FOR bit data, for mixed data, for sbcs data)
  • CLOB

Text search support offers a set of stored procedures and two built-in functions, CONTAINS and SCORES, that can be used to search documents stored in the DB2 table. The administrative procedures enable and disable text searching and create, update, and drop text indexes. Following is an example of searching using a text index:

  • Given a table, BOOKS, with a text index created over the STORY column
  • WHERE CONTAINS(STORY, 'mice chasing cats') = 1 AND YEAR > = 2000

    This would return AUTHOR and STORY for all of the rows where the STORY column matched on the string 'mice chasing cats' and YEAR is greater than or equal to 2000.

Accessibility by people with disabilities

You can request a U.S. Section 508 Voluntary Product Accessibility Template (VPAT) containing details on accessibility compliance at

Back topBack to top
Product positioning

OmniFind Text Search Server delivers scalable and secure entry-level enterprise search for DB2 for i5/OS.

  • Enhances knowledge workers' ability to find the critical business information they need with OmniFind-enabled applications.
  • Brings the flexibility, security, and rich functionality of OmniFind technology to System i™ enterprises.
  • Delivers improved semantic search and a framework for social search.

Business Partner information

If you are a Direct Reseller - System Reseller acquiring products from IBM, you may link directly to Business Partner information for this announcement. A PartnerWorld ID and password are required (use IBM ID).

BP Attachment for Announcement Letter 208-020


i5/OS, OmniFind, and System i are trademarks of International Business Machines Corporation in the United States or other countries or both.
DB2, Lotus, and Freelance are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
Microsoft is a registered trademark of Microsoft Corporation.
Other company, product, and service names may be trademarks or service marks of others.

Back topBack to top
Offering Information

Product information is available via the Offering Information Web site

Back topBack to top

No publications are shipped with this programs.

With the IBM Systems Information Center, users can use a single information center to access product documentation for IBM Systems hardware, operating systems, and server software. Through a consistent framework, users can efficiently find information and personalize their access to that information. The IBM Systems Information Center is at

Back topBack to top
Technical information

Specified operating environment

Hardware requirements

System i™ models 515, 520, 525, 550, 570, 595, 800, 810, 825, 870, 890, and MMA

OmniFind™ Text Search Server is also supported on BladeCenter® model 7998-61X.

Software requirements

i5/OS™ V6R1

Planning information

Packaging: OmniFind Text Search Server for DB2® for i5/OS is available on DVD.

Security, auditability, and control

OmniFind Text Search Server for DB2 for i5/OS uses the security and auditability features of the i5/OS operating system.

The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.

Software Services

IBM Software Services has the breadth, depth, and reach to manage your services needs. You can leverage the deep technical skills of our lab-based, software services team and the business consulting, project management, and infrastructure expertise of our IBM Global Services team. Also, we extend our IBM Software Services reach through IBM Business Partners to provide an unmatched portfolio of capabilities. Together, we provide the global reach, intellectual capital, industry insight, and technology leadership to support any critical business need.

To learn more about IBM Software Services or to contact a Software Services sales specialist, visit

Back topBack to top
Ordering information

Charge metric

                      Part number or
Program name          PID number           Charge metric
OmniFind Text         5733-OMF              Per Server
 Search Server for
 DB2 for i5/OS

Server: A server is a computer system that executes requested procedures, commands, or applications to one or more user and/or client devices. A PoE must be obtained for each server regardless of the number of processors and partitions in the server on which the program runs or for each server managed by the program. Where blade technology is employed, each blade is considered a separate server.

OmniFind Text Search Server for DB2 for i5/OS (5733-OMF)

Charge features

Initial order

 OmniFind Text Search Server
 for DB2 for i5/OS (5733-OMF)                     OTC
 OmniFind Text Search Server                      0001

Other chargeable features


Special delivery features

  Expedite -- Customer Expens                     3446

No-charge features


Language features

  Multilingual Language                           2935

Supply Features

  V6R1 OmniFind Text Search Supp                  5819

Other features

  ePoE Upg Reg                                    2001

Manufacturing features

  LPAR System Indicator                           3441

Special delivery features

  Electronic Software Delivery                    3450
  Do Not Ship Pubs                                3470
  Do Not Ship Media                               3471

Remove Keys/ePoEs for Transferred Software (5733-NKY)

No-charge features


ePoE features

  OmniFind (5733-OMF)                             2518

Back topBack to top
Terms and conditions

The information provided in this announcement letter is for reference and convenience purposes only. The terms and conditions that govern any transaction with IBM are contained in the applicable contract documents such as the IBM International Program License Agreement (IPLA), IBM International Passport Advantage® Agreement, and the IBM Agreement for Acquisition of Software Maintenance.

Licensing: IPLA including the license information (LI) document and proof of entitlement (PoE) govern your use of the program. PoEs are required for all authorized use.

Agreement for Acquisition of Software Maintenance: The IBM Agreement for Acquisition of Software Maintenance (Z125-6011) agreement applies for maintenance and does not require customer signatures.

Limited warranty applies: Yes

Limited warranty: IBM warrants that when the program is used in the specified operating environment, it will conform to its specifications. The warranty applies only to the unmodified portion of the program. IBM does not warrant uninterrupted or error-free operation of the program or that IBM will correct all program defects. You are responsible for the results obtained from the use of the program.

IBM provides you with access to IBM databases containing information on known program defects, defect corrections, restrictions, and bypasses at no additional charge. Consult the IBM Software Support Guide for further information at

IBM will maintain this information for at least one year after the original licensee acquires the program (warranty period).

Money-back guarantee: If for any reason you are dissatisfied with the program and you are the original licensee, you may obtain a refund of the amount you paid for it, if within 30 days of your invoice date you return the program and its PoE to the party from whom you obtained it. If you downloaded the program, you may contact the party from whom you acquired it for instructions on how to obtain the refund.

For clarification, note that for programs acquired under any of IBM's On/Off Capacity on Demand (On/Off CoD) software offerings, this term does not apply since these offerings apply to programs already acquired and in use by you.

Authorization for use on home/portable computer: You may not copy and use this program on another computer without paying additional license fees.

Volume orders (IVO): Yes. Contact your IBM representative.

Passport Advantage applies: No

IBM Operational Support Services — SoftwareXcel: Yes

System i Software Maintenance applies: Yes

Variable charges apply: No

Educational allowance available

Yes. A 15% education allowance applies to qualified education institution customers.
Back topBack to top

IBM Electronic Services

IBM has transformed its delivery of hardware and software support services to help you achieve higher system availability. Electronic Services is a Web-enabled solution that offers an exclusive, no-additional-charge enhancement to the service and support available for IBM servers. These services are designed to provide the opportunity for greater system availability with faster problem resolution and preemptive monitoring. Electronic Services comprises two separate, but complementary, elements: Electronic Services news page and Electronic Services Agent.

The Electronic Services news page is a single Internet entry point that replaces the multiple entry points traditionally used to access IBM Internet services and support. The news page enables you to gain easier access to IBM resources for assistance in resolving technical problems.

The Electronic Service Agent™ is no-additional-charge software that resides on your server. It monitors events and transmits system inventory information to IBM on a periodic, client-defined timetable. The Electronic Service Agent automatically reports hardware problems to IBM. Early knowledge about potential problems enables IBM to deliver proactive service that may result in higher system availability and performance. In addition, information collected through the Service Agent is made available to IBM service support representatives when they help answer your questions or diagnose problems. Installation and use of IBM Electronic Service Agent for problem reporting enables IBM to provide better support and service for your IBM server.

To learn how Electronic Services can work for you, visit

Back topBack to top

The prices provided in this announcement are suggested retail prices for the U.S. only and are provided for your information only. Dealer prices may vary, and prices may also vary by country. Prices are subject to change without notice. For additional information and current prices, contact your local IBM representative.

OmniFind Text Search Server for DB2 for i5/OS (5733-OMF)

Charge Features

Initial order

 OmniFind Text Search Server        OTC
 for DB2 for i5/OS (5733-OMF)       Feature        OTC
 OmniFind Text Search Server        0001           $0

Other chargeable features

                                    number         OTC

Special delivery features

 Expedite -- Customer Expense       3446           $30

IBM Global Financing

IBM Global Financing offers competitive financing to credit-qualified customers to assist them in acquiring IT solutions. Offerings include financing for IT acquisition, including hardware, software, and services, from both IBM and other manufacturers or vendors. Offerings (for all customer segments: small, medium, and large enterprise), rates, terms, and availability can vary by country. Contact your local IBM Global Financing organization or visit

IBM Global Financing offerings are provided through IBM Credit LLC in the United States, and other IBM subsidiaries and divisions worldwide to qualified commercial and government customers. Rates are based on a customer's credit rating, financing terms, offering type, equipment type, and options, and may vary by country. Other restrictions may apply. Rates and offerings are subject to change, extension, or withdrawal without notice.
Back topBack to top

Order now

To order, contact the Americas Call Centers, your local IBM representative, or your IBM Business Partner.

To identify your local IBM representative or IBM Business Partner, call 800-IBM-4YOU (426-4968).

 Phone:      800-IBM-CALL (426-2255)
 Fax:        800-2IBM-FAX (242-6329)
 Mail:       IBM Teleweb Customer Support
    Sales Execution Center, Americas North
             3500 Steeles Ave. East, Tower 3/4
             Markham, Ontario
             L3R 2Z1
 Reference:  AE001

The Americas Call Centers, our national direct marketing organization, can add your name to the mailing list for catalogs of IBM products.

Note: Shipments will begin after the planned availability date.


System i, OmniFind, i5/OS, and Electronic Service Agent are trademarks of International Business Machines Corporation in the United States or other countries or both.
BladeCenter, DB2, and Passport Advantage are registered trademarks of International Business Machines Corporation in the United States or other countries or both.
Other company, product, and service names may be trademarks or service marks of others.

Back to topBack to top

Printable version Printable version  

Share this page

Digg Linked In

Contact IBM