IBM United States
Software Announcement 201-119
April 23, 2001
IBM DB2 Universal Database Extenders Bring XML and Text Retrieval to IBM iSeries
At a Glance
DB2 UDB Extenders for iSeries, Version 7.1 adds XML and Text Search capabilities to your iSeries database and:
For ordering, contact:
Your IBM representative, an IBM Business Partner, or IBM Americas Call Centers at 800-IBM-CALL (Reference: AE001).
Web-enabled e-business is driving most companies to redefine their IT strategy. Moving away from proprietary data formats towards an open, interchangeable format such as Extensible Markup Language (XML) to transact business on the Web is a key part of the strategy.
In this electronic age, the bulk of companies' managed data (90%), including e-mail, technical and business documents, contracts, problem reports, and customer complaints is still in textual form. Companies continue to look for efficient ways to leverage such massive textual data to provide valuable information.
The DB2 Universal Database® (UDB) Extenders for iSeries, Version 7.1 program comes with two major functions to extend DB2® to cover the storage, management, and retrieval of XML and text data for your enterprise:
XML is the standard for data interchange in e-business. The DB2 UDB XML Extender provides new data types that let you store XML documents in DB2 databases and new functions that assist you in working with these structured documents. Entire XML documents can be stored in DB2 databases as character data or stored as external files but still managed by DB2. Retrieval functions allow you to retrieve either the entire XML document or individual elements or attributes.
The DB2 UDB Text Extender gives you a powerful way to search for and extract key information in documents stored in DB2 databases or in files. You can use Text Extender to search through a full-text document or perform a structural text search. XML Extender understands the XML structures and allows application queries to be based on the structure of the document.
Together, the DB2 UDB XML Extender and DB2 UDB Text Extender help you leverage iSeries to manage your critical business information in DB2 databases to engage in business-to-business and business-to-customer solutions in the next generation of e-business.
The product is packaged on the media with the iSeries Version 5 Release 1. It can be freely used for up to a 70-day trial period.
DB2 UDB Extenders for iSeries, Version 7.1 consists of two powerful DB2 Extenders® that add to the capabilities of your DB2 to satisfy your enterprise applications needs for e-business:
DB2 UDB XML Extender
XML allows for a method to mark the meaning of the data so it can be more easily used. It is extensible in that the language itself is a meta-language that allows you to create your own language, depending on the needs of your enterprise.
XML support is being added to your DB2. It is now possible to combine structured XML information with traditional relational data. You can choose whether to store entire XML documents in DB2 as an XML Character Large Object (XMLCLOB), or you can map the XML content as traditional data in relational tables. The DB2 UDB XML Extender adds the ability for powerful searching of rich data types of XML element or attribute values, even for nontraditional XML data types.
Incoming XML documents can be decomposed into traditional SQL data types and placed in columns. This will allow for decomposing an XML document into one or more pieces for storing in tables. Data in existing relational tables can be used to compose XML documents.
By using the DB2 UDB XML Extender and its set of User-Defined Types
(UDTs), an application can store entire XML documents as column data in
an application table. The UDTs also provide for the composition or
decomposition of the contents of XML documents from or into an XML
collection. These XML collections can be made up of one or more regular
DB2 tables. These user-defined functions provide powerful capabilities
toward solving your enterprise application needs for e-business.
DB2 UDB Text Extender
The DB2 UDB Text Extender is based on the proven IBM Text Search Engine technology and provides full-text search capabilities with your DB2. It offers a rich set of text search features that allow for more complex and precise queries, and an improved recall in search operations.
The DB2 UDB Text Extender provides full-text search through a set of User-Defined Functions (UDFs). These extend the SQL query language by providing additional functionality. It is easy to combine full-text search with parametric search. Text search capabilities depend on index type chosen when the documents are indexed. All index types support:
Depending on the index types, you may have additional search functions:
Text Search on Structured Documents
Structured documents are documents that have an internal structure (sections) defined using tags. DB2 UDB Text Extender can recognize this structure and allows searches to be restricted to sections of the document. Structured documents defined by DB2 UDB XML Extender can be recognized. In addition HTML or user-defined tagged ASCII files can also be recognized by the Text Extender.
Accessibility by People with Disabilities
The following features support use by people with disabilities:
This program is not impacted by euro currency.
Visit the following Web site for additional information:
The appropriate curriculum will include the enhancements described in this announcement.
Call IBM Education and Training at 800-IBM-TEACH (426-8322) for catalogs, schedules, and enrollments.
Product information is available through Offering Information (OITOOL) at:
No publications are shipped with this program.
The following publications can be ordered by contacting your IBM representative.
Order Title Number Language DB2(R) UDB Extenders for SC27-1172 English iSeries XML Extender Version 7 DB2 UDB Extenders for SH12-6720 English iSeries Text Extender Version 7
The Publication Notification System (PNS) is available by order number/product number. Customers currently subscribing to PNS will receive automatically notifications by e-mail. Customers who want to subscribe, can visit the PNS Web site location at:
The IBM Publications Center portal at:
The Publications Center is a worldwide central repository for IBM product publications and marketing materials with a catalog of 70,000 items. Extensive search facilities are provided, as well as payment options via credit card. Furthermore, a large number of publications are available online in various file formats, which can currently be downloaded free of charge.
Note: PNS subscribers most often order their publications via the Publications Center.
Title Language DB2 UDB Extenders for iSeries English XML Extender Version 7 DB2 UDB Extenders for iSeries English Text Extender Version 7
Terms and conditions for use of the machine-readable files are shipped with the files.
These PDF books can also be accessed on the Internet at:
iSeries or AS/400® that can run OS/400® Version 5 Release 1
The Text Extender for iSeries has the following differences:
Security, Auditability, and Control
DB2 UDB Extenders for iSeries, Version 7.1 uses the security and auditability features of OS/400 V5R1.
The customer is responsible for evaluation, selection, and implementation of security features, administrative procedures, and appropriate controls in application systems and communication facilities.
DB2 UDB Extenders for iSeries, Version 7.1 has a single charge unit based on Processor Group.
For detailed ordering information, refer to Software Announcement 201-114 , "IBM iSeries V5R1 Software Terms, Ordering Information, and Prices," dated April 23, 2001.
Terms and Conditions
For further information on terms, conditions, and usage restrictions, refer to Software Announcement 201-114 , "IBM iSeries V5R1 Software Terms, Ordering Information, and Prices," dated April 23, 2001.
For Pricing information, refer to Software Announcement 201-114 , "IBM iSeries V5R1 Software Terms, Ordering Information, and Prices," dated April 23, 2001.
Customer Financing: IBM Global Financing offers attractive financing to credit-qualified commercial and government customers and Business Partners in more than 40 countries. IBM Global Financing is provided by the IBM Credit Corporation in the United States. Offerings, rates, terms, and availability may vary by country. Contact your local IBM Global Financing organization. Country organizations are listed at:
Use Priority/Reference Code: AE001 Phone: 800-IBM-CALL Fax: 800-2IBM-FAX Internet: firstname.lastname@example.org Mail: IBM Atlanta Sales Center Dept. AE001 P.O. Box 2690 Atlanta, GA 30301-2690
You can also contact your local IBM Business Partner or IBM representative. To identify them, call 800-IBM-4YOU.
Note: Shipments will begin after the planned availability date.