Volume 16, Number 10 -- March 12, 2007

So Where Is PureXML for DB2/400?

Published: March 12, 2007

by Timothy Prickett Morgan

With much fan-fare last week, IBM rolled out its "Viper" database technology into the version of DB2 for its z/OS-based mainframes. Viper is not just a relational database, which can store information in the traditional format that is friendly to SQL and other query methods, but also can store information in an XML format as well--and do so natively.

IBM calls the native XML capability PureXML, and unlike past approaches, including prior releases and versions of DB2 for the mainframe as well as the Unix/Linux/Windows variant andcurrent approaches with DB2/400, PureXML allows XML documents to be stored without losing the hierarchical information that is inherent in them and still allows the elements of the XML documents to be queried. This technology has been in development for five years, and was first released in the DB2 V9 releases for Windows, Unix, and Linux in July 2006. IBM holds a patent on the PureXML approach, by the way.

According to Bernie Spang, director of data servers at IBM--data server being the new-fangled name for a database management system at Big Blue these days and not to be confused with a database hardware appliance--past approaches to dealing with XML data were not exactly ideal. The approach, he explained, is to store a whole XML document inside of a database field; while this works, SQL queries only work across cells, not within them, which means you could not easily index XML documents for fast searches and queries.

The other approach, which is called shredding, takes the XML document and parses it up into chunks and then stores the chunks inside different columns within the same row in the relational database management system. This approach allows for the elements of the XML document to be queried, but it is no longer a hierarchical XML document that can be used in production. Recomposing it on the fly out of the database obviously takes a lot more resources than hitting a single cell in the database to retrieve the whole XML document, as can be done in the other approach.

With PureXML, IBM has figured out a way to store the XML document, index the data within documents and across documents, and allow a single SQL query to scan documents. This capability is clearly important for the services oriented architecture (SOA) approach to application development, which uses XML as a kind of superglue between disparate and often incompatible systems and applications to create individual services and then composite applications built from those services.

"With SOA, you can't just say, 'Whatever. I just need an SQL data server,'" says Spang. "The decision about what data server you use is every bit as important as the application server you choose."

Various industries are standardizing the XML documents they intend to use for services--ACCORD in financial services, HIPPA in healthcare, ARTS in retail, and so forth--and this PureXML capability is something they are looking for--especially since the same DB2 database can store plain old row and column data used to traditional transaction processing systems. But, perhaps more importantly, the DB2 Viper family of products is showing that it can handle XML data with anywhere from three to right times the performance of prior DB2 versions, which were using the two other methods mentioned above to cope with XML documents.

Now that PureXML is available on the mainframe as well as Unix, Linux, and Windows servers, this begs the obvious question: When will the DB2/400 database at the heart of i5/OS get the PureXML technology? I contacted IBM's press relations people, and I received a cut response that "there's no release date on that yet." I asked if I could get a more concrete statement about whether it was in development or not, and if I could talk to the good people in the Rochester labs about if, when, and how the remaining strategic IBM server platform would get PureXML support. So far, my phone line has been real quiet. But, I will start poking around.

My guess is that one of the reasons why the future i5/OS V5R5 or i/OS V6R1--whatever IBM calls the future operating system version or release for the future Power6-based System i servers--has PureXML support, and if there are reasons to push that operating system release out to early 2008, then adding PureXML to the database is one good reason to take a little extra time. Then again, for all I know, IBM is happy for customers to keep using DB2 XML Extender, a tool for grafting XML support onto DB2/400 that has been around for several years.


DB2 for Mainframes Gets Native XML with V9.1 Release

IBM Previews "Viper" DB2 Database Version

                     Post this story to
               Post this story to Digg
    Post this story to Slashdot

Sponsored By

Make Your Office Paperless by
Eliminating Pre-printed Forms

Reduce paper, printing and storage costs.
Create e-forms from scratch or from existing spool files
and text reports. Add color logos, bar codes and graphics.

Visit us at
or call us at 888-RJS-SOFT for a free 30-day demo.

Editor: Timothy Prickett Morgan
Contributing Editors: Dan Burger, Joe Hertvik, Shannon O'Donnell,
Mary Lou Roberts, Victor Rozek, Kevin Vandever, Hesh Wiener, Alex Woodie
Publisher and Advertising Director: Jenny Thomas
Advertising Sales Representative: Kim Reed
Contact the Editors: To contact anyone on the IT Jungle Team
Go to our contacts page and send us a message.

Sponsored Links

Guild Companies:  Search OS/400 titles in our bookstore
LXI:  Disk to disk backup with centralized control
COMMON:  Join us at the 2007 conference, April 29 May 3, in Anaheim, California


IT Jungle Store Top Book Picks

The System i Pocket RPG & RPG IV Guide: List Price, $69.95
The iSeries Pocket Database Guide: List Price, $59.00
The iSeries Pocket Developers' Guide: List Price, $59.00
The iSeries Pocket SQL Guide: List Price, $59.00
The iSeries Pocket Query Guide: List Price, $49.00
The iSeries Pocket WebFacing Primer: List Price, $39.00
Migrating to WebSphere Express for iSeries: List Price, $49.00
iSeries Express Web Implementer's Guide: List Price, $59.00
Getting Started with WebSphere Development Studio for iSeries: List Price, $79.95
Getting Started With WebSphere Development Studio Client for iSeries: List Price, $89.00
Getting Started with WebSphere Express for iSeries: List Price, $49.00
WebFacing Application Design and Development Guide: List Price, $55.00
Can the AS/400 Survive IBM?: List Price, $49.00
The All-Everything Machine: List Price, $29.95
Chip Wars: List Price, $29.95


The Linux Beacon
Red Hat Readies RHEL 5 for March 14 Launch

Novell Gets Pinched By Rising Costs, Falling Sales

Midrange Boxes, Big Iron Drive Server Growth in Q4 2006

The X Factor: How Many Servers, How Much Juice, How Much Money?

Four Hundred Stuff
VAI Says 'No Thanks' to the Quick Buck

nCipher Brings Key Management Software to i5/OS

Vision Taps SteelEye for Linux HA on iSeries

Business Objects Unveils Two BI Offerings for J.D. Edwards

Big Iron
DB2 for Mainframes Gets Native XML with V9.1 Release

Top Mainframe Stories From Around the Web

Chats, Webinars, Seminars, Shows, and Other Happenings

Four Hundred Guru
Multiple Display Files in One Program

Three Little Words That Simplify Debugging

Admin Alert: Better Subsystem Throughput Via Multiple Job Queues, Part Two

System i PTF Guide
March 3, 2007: Volume 9, Number 9

February 24, 2007: Volume 9, Number 8

February 17, 2007: Volume 9, Number 7

February 10, 2007: Volume 9, Number 6

February 3, 2007: Volume 9, Number 5

January 27, 2007: Volume 9, Number 4

The Windows Observer
Microsoft Lacks Innovation, Fairness in Pricing of Protocols, EC Says

Symantec Gives Vista Security a So-So Grade

Midrange Boxes, Big Iron Drive Server Growth in Q4 2006

HP Ships Virtual Connect I/O for Blades, Adds Blade Workstation

The Unix Guardian
Midrange Boxes, Big Iron Drive Server Growth in Q4 2006

SCO's Unix Sales Continue to Slide, But Red Ink Is Shallower

HP Unix Behemoth Squeaks By IBM Big Iron on TPC Test

Mad Dog 21/21: Paved With Good Intentions

Four Hundred Monitor
Four Hundred Monitor's
Full iSeries Events Calendar


Seagull Software
RJS Software Systems

IBM's Plan for an Adjacent, Custom Systems Market

WDSc Version 7.0 Standard Edition Is Missing Two Key Features

Is Upgrading a Silly Waste of Time and Money?

As I See It: The Digital Life

But Wait, There's More:

So Where Is PureXML for DB2/400? . . . IBM Tops HP in Latest Gartner Disk Array Ranking, Both Trail EMC . . . Zend and IBM Sponsor Wiki for System i PHP Redbook Development . . . Rumors Say Farm Bureau to Dump AS/400s for Windows Boxes . . . DataMirror Grows Revenues in Q4, Boosts Bottom Line Even More . . . Gates Says Infinite H1-B Visas, Scholarships Needed to Boost Tech Competitiveness . . .

The Four Hundred


Subscription Information:
You can unsubscribe, change your email address, or sign up for any of IT Jungle's free e-newsletters through our Web site at

Copyright © 1996-2008 Guild Companies, Inc. All Rights Reserved.
Guild Companies, Inc., 50 Park Terrace East, Suite 8F, New York, NY 10034

Privacy Statement