Extremely pureXML in DB2 10 for z/OS

An IBM Redbooks publication

Published 28 January 2011

cover image

ISBN-10: 0738435147
ISBN-13: 9780738435145
IBM Form #: SG24-7915-00
(334 pages)

More options

Rate and comment

Authors: Paolo Bruni, Neale Armstrong, Ravi Kumar, Kirsten Ann Larsen, Tink Tysor, Hao Zhang


The DB2® pureXML® feature offers sophisticated capabilities to store, process and manage XML data in its native hierarchical format. By integrating XML data intact into a relational database structure, users can take full advantage of DB2's relational data management features.

In this IBM® Redbooks® publication, we document the steps for the implementation of a simple but meaningful XML application scenario. We have chosen to provide samples in COBOL and Java™ language. The purpose is to provide an easy path to follow to integrate the XML data type for the traditional DB2 for z/OS® user.

We also add considerations for the data administrator and suggest best practices for ease of use and better performance.

Table of contents

Chapter 1. Introduction
Chapter 2. XML and DB2 for z/OS
Chapter 3. Application scenario
Chapter 4. Creating and adding XML data
Chapter 5. Validating XML data
Chapter 6. DB2 SQL/XML programming
Chapter 7. Using XML with Java
Chapter 8. Using XML with COBOL
Chapter 9. Utilities with XML
Chapter 10. XML-related tasks for the DBA
Chapter 11. Performance considerations
Appendix A. Application scenario documents
Appendix B. Additional material

Follow IBM Redbooks

Follow IBM Redbooks