DB2 XML:  The Big Picture

• Beyer, K. and 17 additional co-authors.  "DB2 goes hybrid:  Integrating XML and XQuery with relational data and SQL", IBM Systems Journal, Vol. 45, Number 2, 2006.
• Howard, Philip. "The business benefits of DB2 9", Bloor Research white paper, July 2006.
• Nicola, Matthias and Bert Van der Linden. "Native XML Support in DB2 Universal Database", Proceedings of the 31st Annual VLDB, 2005.
• North, Ken. "XML in Focus", DB2 Magazine 3 Quarter 2006. 
• Saracco, C. M. "Managing XML for Maximum Return", IBM White Paper, October 2005. 
• Saracco, Cynthia and Matthias Nicola.  "DB2 9.7: Taking pureXML to the Data Warehouse,"  IDUG Solutions Journal, April 2009. 
• Zhang, Guogen.  "Leveraging DB2 9 for z/OS pureXML Technology (2nd Edition)," August 2008.

Query Languages, Reporting, and Search

• Chamberlin, Don. "XQuery: An XML query language", IBM Systems Journal, Vol. 41, Number 4, 2002. 
• Ledezma, Sal and Bert van der Linden.  "Shred XML documents using DB2 pureXML," IBM developerWorks, January 2008.
• Ozcan, Fatma and Don Chamberlin, Krishna Kulkarni, Jan-Eike Michels.  "Integration of SQL and XQuery in IBM DB2", IBM Systems Journal, Vol. 45, Number 2, 2006.
• Patterson, Bryan and Dexiong Terry Zhang. "Create business reports for XML data using IBM DataQuant and DB2 pureXML,", IBM developerWorks, January 2009.
• Saracco, C. M.  "DB2 9 Fundamentals exam 730 prep, Part 7: Introducing XQuery", IBM developerWorks, July 2006.  
• Saracco, C. M. and Tad Worley. "Create business reports for XML data with Cognos BI and DB2 pureXML," IBM developerWorks, November 208.
• Seubert, Holger and Sabine Perathoner-Tschaffler. "XML full-text search in DB2",IBM developerWorks,  June 2006.
• Singh, Hardeep. "How to write hybrid queries for DB2 9" (1.8MB) , queries with SQL/XML and XQuery, August 2006.
• SQL and XQuery Tutorials for IBM DB2 , IBM developerWorks, 2006.

Application Development

• Bendel, Peter.  "Mine DB2 XML columns with DB2 Data Warehouse Edition data mining," IBM developerWorks, Sept. 2006.
• Bittner, Torsten.  "Generate SQL/XML queries with Rational Data Architect," IBM developerWorks, September 2006.
• Bordia, Aakash, and Eileen Lin, Ioana Ursu, Sebastian Hahnel.  "Use WebSphere Federation Service Version 9.1 to integrate XML data," IBM developerWorks, March 2007.
• Farahbod, Farzad and Chat Chatterton, Chenhong Xia.  "Develop proof-of-concept .NET applications, Part 4: Wire your application to DB2 pureXML data," IBM developerWorks, August 2006.
• Farahbod, Farzad.  "XML data validation using IBM DB2 Visual Studio 2005 .Net Add-in" IBM developerWorks, November 2006.
• Kogan, Irina. "Using the Altova Tools with IBM DB2 pureXML,"IBM developerWorks, December 2007.
  Kogan, Irina. "Integration of Altova Tools with IBM DB2 9 pureXML demonstrated in the Online Brokerage Application Scenario," Altova and IBM White Paper, February 2008.
• Ledezma, Sal. "The Viper Solution:  A Data Persistence Model using DB2 and PHP", Proceedings of the XTech 2006 Conference, May 2006.
• Ledezma, Sal.  "Work with XML Data in the Zend Framework," Zend Developer Zone, Sept. 2006.
• Leung, Gerald and Lin Sun, "Kick-start your J2EE applications using DB2 9 with pureXML and Websphere Community Edition", IBM developerWorks, September 2006.
• Malaika, Susan and Christian Pichler, "WebSphere DataPower and DB2 pureXML, Part 1: XML schema and content validation using DataPower and DB2 pureXML", IBM developerWorks, June 2008
• Malaika, Susan and Christian Pichler, "WebSphere DataPower and DB2 pureXML, Part 2: DB2 pureXML as an audit log for WebSphere DataPower", IBM developerWorks, June 2008
• Nelson, Philip.  "DB2 9 pureXML Speeds Rudy on Rails Florist Application," IBM Database Magazine, Quarter 3, 2008.
• Moro, Mirella Moura and Susan Malaika, Lipyeow Lim.  "Preserving XML queries during schema evolution," IBM developerWorks, June 2007.
• Saracco, C. M. "Opening the door to XML" (an introduction for Java developers),  DB2 Magazine, 3 Quarter 2006.
• Singh, Hardeep and Amir Malik. "Use DB2 native XML with PHP", IBM developerWorks, October 2005.
• Singh, Hardeep.  "XML Programming with PHP and Ajax,"  DB2 Magazine, 3 Quarter 2006.
• Singh, Hardeep. "XML tooling in DB2 9" (3.2MB) , DB2 Developer Work Bench and Control Center, August 2006
• Singh, Hardeep, "Programming with XML for DB2, Part 1: Understanding the Data Model", IBM developerWorks, July 2007.
• Singh, Hardeep, "Programming with XML for DB2, Part 2: Leverage database support for XML in your application architecture", IBM developerWorks, Aug 2007.
• Singh, Hardeep, "Programming with XML for DB2, Part 3: Program with XML in the client", IBM developerWorks, Aug 2007.
• Singh, Hardeep, "Programming with XML for DB2, Part 4: Integrate data from different data sources in your Web-based DB2 application", IBM developerWorks, Sept 2007.
• Whitney, Justin. "XML Everywhere: DB2 9 and Ajax, Part 1" , DevX.com, October 2006.
• Whitney, Justin. "XML Everywhere: DB2 9 and Ajax, Part 2," DevX.com, November 2006.

Performance

• Balmin, Andrey and Kevin Beyer, Fatma Ozcan, Matthias Nicola.  "On the Path to Efficient XML Queries," VLDB Conference Proceedings, 2006.   
• Haide, Michael and Claus Kempfert: "Tuning the Performance of Full-Text Indexing in the DB2 Net Search Extender", IBM White Paper, December 2006.
• King, Nelson. "XML Performance: A Surprising Ace in the Hole," , IBM Database Magazine, May 2008.
• Kogan, Irina and Matthias Nicola, Berni Schiefer. "DB2 9 XML performance characteristics", IBM developerWorks, June 2006.
• Intel, "DB2 9 pureXML Scalability on Intel® Xeon® MP Platforms Using IBM N Series Storage", December 2006.
• Nicola, Matthias and Jasmi John. "XML Parsing:  A Threat to Database Performance," CIKM Conference Proceedings, 2003.
• Rodrigues, Vitor.  "Indexing XML Documents in DB2 9 pureXML™", IBM White Paper, May 2006.

Administration

• Barnak, Branislav and Amir Bar-or, Cynthia Saracco, Paul Stanley.  "IBM InfoSphere DataStage and DB2 pureXML Part 1: Integrate XML operational data into a data warehouse," IBM developerWorks, August 2009.
• Barnak, Branislav and Amir Bar-or, Cynthia Saracco, Paul Stanley. "IBM InfoSphere DataStage and DB2 pureXML Part 2: Building an XML-enabled data warehouse," IBM developerWorks, September  2009.
• Dua, Aarti. "XML Schema Registration and Validation," IBM white paper, July 2006.   (An accompanying .zip file containing samples is also available for download from this page.)
• Faraaz, K and Ronny Bartsch, Susan Malaika.  "Evolving your XML Schemas using DB2 pureXML", IBM developerworks, March 2008.
• Farabhod, Farzad.  "Introduction to annotated XML schema decomposition using the DB2 Visual Studio 2005 Add-in", IBM developerWorks, November 2006.
• Lapis, George. "XML and Relational Storage - Are they mutually exclusive?". Proceedings of the Xtech 2005 Conference, 2005.
• Olson, Laura and Andre Tost. "Use WebSphere Service Registry and Repository as the master registry for DB2 pureXML schemas" IBM Developerworks, April 2008.
• Pradhan, Mayank. "Default mapping for annotated XML schema",  IBM developerWorks, April 2006.
• Pradhan, Mayank. "From DAD to annotated XML schema decomposition",  IBM developerWorks, April 2006.
• Spalten, Randy and Preethi Vishwanath.  "XML in a non-Unicode database," IBM developerWorks, July 2007.  An accompanying guide to the conversion UDFs, along with sample code, is also available for separate download.
• Williams, Brian. *"Document-Level Security using DB2 9 pureXML and LBAC",*IBM developerWorks, July 2006.
• Vishwanath, Preethi and Randy Spalten.  "Guide to Conversion UDFs," IBM white paper, August 2007.  An accompanying .zip file containing sample code is also available;  click on the link for "UDFs and Client Samples.zip." 
• Yuk, Nelson. "EXPORT and IMPORT for XML Data Type Support", IBM white paper, June 2006.

SOA, Web services, and electronic Forms

• Bommireddipalli, Vijay.  "Generate Web services for DB2 9 pureXML," IBM developerWorks, June 2007.
• Daniel, Bryan.  "IBM Workplace Forms V2.6 integration with IBM DB2 V9," IBM developerWorks, March 2007.
• Devlin, Karen.  "Exposing DB2 9 pureXML using WebSphere Integration Developer," IBM developerWorks, September 2007.
• El-Hilaly, Mohab and Andre Tost, Alaa Youssef. "Using industry standard data formats with WebSphere ESB and DB2 Version 9 pureXML," IBM developerWorks, June 2007. 
• Malaika, Susan and Christian Pichler, "Universal Services for pureXML using Data Web Services", IBM developerWorks, April 2008.
• Patterson, Bryan and Dexiong Zhang, "Build an intelligent eForms solution based on DB2 pureXML, Lotus Forms, and Web services" , IBM developerWorks, April 2009.
• Patterson, Bryan, "Creating an XML electronic forms solution with an Adobe PDF form and IBM DB2 pureXML" , Adobe Developer Connection, November 2009.
• Shetty, Dinesh and Srinandan K Sridhar, Andre Tost, "Using DB2 Version 9 pureXML with WebSphere ESB", IBM WebSphere Developer Technical Journal, August 2006.
• Wells, Keith, Susan Malaika, and Christian Pichler, "XForms and DB2 pureXML", IBM developerWorks, May 2008
• White Paper, "Lotus Forms, XForms and DB2 pureXML, IBM, May 2008.

 Solutions 

• Giddings, Laura and Andy Stewart.  "XML data solutions with xfy and DB2 9, Part 2: Deliver dynamic XML information solutions,"IBM developerWorks, October 2006.
• Hiura, Hideki. "XML data solutions with xfy and DB2 9, Part 1: Use pureXML to get the full value of your data," IBM developerWorks, September 2006. 
• Malaika, Susan.  "Get started with industry formats and services with pureXML," IBM developerWorks, May 2007.
• Morrell, John (Coral8).  "Complex Event Processing with DB2 and Coral8", IBM developerWorks, April 2007.
• Saracco, Cynthia M.  "Improving the derivatives trading process with DB2 pureXML," IBM White Paper, June 2007.
• Saracco, Cynthia M. and Robert Snider.  "Supporting SEPA with DB2pureXML," IBM White paper, Sept. 2007.
• Schwartz, Philip and Cynthia M. Saracco, Neal Keene. "Automating the confirmation of derivatives trades," IBM and Thunderhead white paper, September 2007.
• Vann, Danielle and Jim Hobler.  "Processing SEPA Payments with DB2 pureXML and WebSphere Transformation Extender," IBM developerWorks, April 2009.

DB2 9 Certification Exam Tutorials

• DB2 9 fundamentals certification 730 prep series, IBM developerWorks, 2006.
• DB2 9 database administration 731 certification prep series, IBM developerWorks, 2006.

 DB2 for z/OS

• Catterall, Robert, "The Cool Factor: Modern developments stomp the mainframe-as-dinosaur myth for good" (the mainframe is a great platform for the most modern IT initiatives, including those that use service-oriented architectures, XML, J2EE applications, and more.)
• See "Leveraging DB2 9 for zOS pureXML Technology," (listed under "The Big Picture" above).
• Ruby-Brown, Judy and Hoshikawa, Akiko, "DB2 9 and z/OS XML System Services Synergy Update," IBM Whitepaper, Document ID:
  WP101227, May 2008.
• Zhang, Guogen, Download samples: "W3C XQuery use cases converted to SQL/XML in DB2 9 for z/OS." August 2008.

Please also visit the DB2 z/OS section of this Wiki.

Comments or Questions?

Please post any questions or comments you may have about this page to the DB2 9 Forum.