Before you start
This is the second installment in a series on how to get started with XML in IBM® DB2® for z/OS®. This series provides different approaches for creating simple applications that manipulate XML data. The objective is to provide some familiarity with the technology and demonstrate the ease with which XML applications can be developed, but the downloadable material may also serve as a starting point for prototyping.
This tutorial describes how to set up Web access to your pureXML data in DB2 for z/OS in a few easy steps, supplying a download bundle complete with instructions for you to install.
The operations supplied are insert, update, delete, select, and query. The query operation supplies the functionality of applying any XPath expression entered through the Web page to your XML document in DB2, thus providing an environment for experimenting with XPath as well as a starting point for creating more specific queries.
This tutorial also provides instructions on how to import the Universal Services into Data Studio as a project for further development.
The content in this tutorial is based on the article "Universal Services for pureXML using Data Web Services" (developerWorks, August 2008). However, it has been adopted to target DB2 for z/OS, whereas the original article works with DB2 for Linux®, UNIX®, and Windows®.
In order to install and run Universal Services, the following software needs to be available:
- DB2 9 for z/OS
- JRE 1.5 or later on z/OS
- JDK 1.5 or later on the Windows server
- DB2 Connect, Version 8 or later
- This tutorial uses a type 4 JDBC driver, so DB2 Connect does not actually need to be installed, but the license must be available.
- One of the following Web servers:
- IBM WebSphere® Application Server, Version 7 or later
- WebSphere Application Server Community Edition, Version 2.1 or later
- Apache Tomcat, version 5.5 or later
You can download both WebSphere Application Server Community Edition and Tomcat free of charge (see Resources).