This page contains information specific to DB2 for z/OS, and may contain cross-references to other areas.

Technical Articles

• Zhang, Guogen.  "Leveraging DB2 9 for zOS pureXML Technology," IBM white paper, March 2007. Revised and Expanded 2nd Edition:"Leveraging DB2 9 for z/OS pureXML Technology (2nd Edition)," August 2008.

• From DB2 for z/OS XML development. "XSR Setup and Troubleshooting" V0.8 This article provides pointers to references for XML Schema Repository (XSR)-related setup and examples, and many commonly seen symptoms and troubleshooting tips. January 2009.

• From DB2 for z/OS XML development. "DB2 9 for z/OS pureXML FAQs" V0.8 Some frequently asked questions, and XPath diagnosis check list. January 2009.

• Ruby-Brown, Judy and Hoshikawa, Akiko, "DB2 9 and z/OS XML System Services Synergy Update," IBM Whitepaper, Document ID:
  WP101227, May 2008.

• 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.)

Webcasts and Podcasts

DB2 9 for z/OS pureXML Podcast Series by Guogen Zhang (GGZ), 2008:
This is a 10-part introductory podcast series on pureXML business value and technical knowledge. The first part covers overview and business value, and the follow-on 8 parts cover different aspects of pureXML. The last part talks about best practices.

• Part 1: pureXML in DB2 9 for z/OS makes XML consumable (mp3, 6.4MB, 14:02) Part 1 transcript in pdf

• Part 2: Getting started with pureXML (mp3, 6.7MB, 14:34) Part 2 transcript in pdf

• Part 3: Querying XML data with XPath in SQL for Beginners (mp3, 6.4MB, 13:56) Part 3 transcript in pdf

• Part 4: SQL/XML Constructor functions (publishing functions) (mp3, 6.1MB, 13:21) Part 4 transcript in pdf

• Part 5: Leveraging SQL for XML data with XMLTABLE function (mp3, 4.9MB, 10:36) Part 5 transcript in pdf

• Part 6: XML Indexes and Access Plans (mp3, 5.6MB, 12:19) Part 6 transcript in pdf

• Part 7: XML Schema Support (mp3, 5.1MB, 11:06) Part 7 transcript in pdf

• Part 8: pureXML Performance and Cost Factors (mp3, 5.6MB, 12:19) Part 8 transcript in pdf

• Part 9: pureXML Utility Features and Impact on DBAs (mp3, 4.8MB, 10:35) Part 9 transcript in pdf

• Part 10: Best Practices of pureXML in DB2 9 for z/OS (mp3, 6.1MB, 13:18) Part 10 transcript in pdf

• Give us feedback on whether this introductory podcast series is useful to you. If so, we will prepare follow-on podcast for more advanced topics of your interests. Thank you.

Presentations and Demonstrations

• Materializing the Value of pureXML in DB2 9 for z/OS: Accelerate application development, achieve greater business agility and improve business insights with DB2 9 for z/OS pureXML Presentation for Telecon on April 21, 2009. Audio recording for the telecon (mp3, 5.5MB, 48:01)

• Ten Essential DBA Tasks for DB2 9 for z/OS pureXML IBM IOD 2008 Global Conference presentation. October 2008.

• Ten Common Usage Patterns of pureXML for DB2 for z/OS Applications IBM IOD EMEA 2008 presentation. June 2008.

• DB2 9 pureXML demo for z/OS, May 2008.

• DB2 9 for z/OS pureXML - Survival Guide for DBAs IDUG Europe 2008 and IOD 2007 presentation.

• Generating XML from relational data using SQL in DB2 V8 presentation This is a "re-used" presentation from IM tech conference '05. It is largely applicable to DB2 9 today.

Samples and Downloads

• IOD 2008 HOL2585 Material: Learning SQL/XML and XPath with CLP (and SPUFI) IBM IOD 2008 Global Conference one of the Hands-on Lab sessions. This download file includes materials for the CLP lab part but not the SPUFI part as that was set up on the z/OS server. Use examples to learn more SQL/XML with XPath.

• Zhang, Guogen, Download samples: "W3C XQuery use cases converted to SQL/XML in DB2 9 for z/OS." August 2008. This sample package illustrates how W3C XQuery use cases can be converted to SQL/XML queries that generates the same results and that are accepted by DB2 9 for z/OS, which does not support XQuery yet.

• IOD 2007 DB2 9 for z/OS XML Hands-on Lab material. This package contains the lab material used in IOD 2007 XML lab, including DDL, Java samples, query samples, examples for schema registration, validation, and decomposition. This material is for educational use only without any warrant, express or implied.

• XML QuickDemo This zip file contains some CLP scripts and their output capture. The CLP scripts are DDLs and SQL/XML queries illustrating some XML features in DB2 9 for z/OS.

• XML4TABLE and XML4ENTITY1 SQL PL stored procedures for DB2 9 for z/OS This zip file contains two SQL PL stored procedure samples to convert relational data into XML documents. XML4TABLE is to generate an XML document for an entire table, while XML4ENTITY1 is to generate an XML document for an entity from multiple tables connected with RIs. It contains some CLP scripts and a Java sample with sample output.

Comments or Questions?

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