Before you can do XML schema validation on your XML documents,
you need to set up an XML schema repository.
Before you begin
Besides DB2® for z/OS®, XML schema repository setup
requires that the following software is installed and configured:- Workload Manager for z/OS (WLM)
z/OS XML
System Services. For improved schema validation performance with binary
XML format use a z/OS Version
1 Release 13 or later environment.![End of change](KC_ROOT/images/ddita/deltaend.gif)
- Java 2 Technology Edition,
V5 or later, 31-bit version
- IBM® Data Server Driver for JDBC and
SQLJ
About this task
Setting up an XML schema repository involves defining
a set of DB2 tables and indexes
that store XML schema information, and setting up a set of stored
procedures that operate on the XML schemas that are stored in the
tables.
Procedure
To set up the XML schema repository:
- Define the XML schema repository tables and indexes.
The table spaces are:
- SYSIBM.SYSXSR
- SYSIBM.SYSXSRA1
- SYSIBM.SYSXSRA2
- SYSIBM.SYSXSRA3
- SYSIBM.SYSXSRA4
The tables are:
- SYSIBM.XSRANNOTATIONINFO
- SYSIBM.XSRCOMPONENT
- SYSIBM.XSROBJECTCOMPONENTS
- SYSIBM.XSROBJECTGRAMMAR
- SYSIBM.XSROBJECTHIERARCHIES
- SYSIBM.XSROBJECTPROPERTY
- SYSIBM.XSROBJECTS
- SYSIBM.XSRPROPERTY
The indexes are:
- SYSIBM.XSRANNINFOIDX
- SYSIBM.XSRCOMP01
- SYSIBM.XSRCOMP02
- SYSIBM.XSRHIER01
- SYSIBM.XSRHIER02
- SYSIBM.XSROBJ01
- SYSIBM.XSROBJ02
- SYSIBM.XSROBJ03
- SYSIBM.XSROBJ04
- SYSIBM.XSRXCC01
- SYSIBM.XSRXCP01
- SYSIBM.XSRXOG01
- SYSIBM.XSRXOP01
Installation job DSNTIJRT invokes a program
that executes the CREATE DATABASE, CREATE TABLESPACE, CREATE TABLE
and CREATE INDEX statements for the XML schema repository tables and
indexes. After the installation process customizes job DSNTIJRT, you
can run DSNTIJRT without further modification to create those tables
and indexes.
Important: Do not drop these objects after you begin to do XML
schema validation. Doing so can cause unexpected behavior.
- Define the WLM environment and startup procedure for the
C language XML schema repository stored procedures.
- Define the WLM environment and startup procedure for the Java language XML schema repository
stored procedure.
- Define the XML schema repository stored procedures to DB2.
- Bind the packages for the XML schema repository stored
procedures.
Installation job DSNTIJRT
invokes a program that binds the packages for the XML schema repository
stored procedures. After the installation process customizes job DSNTIJRT,
you can run DSNTIJRT without further modification to bind the packages.
- Bind the packages for the IBM Data Server Driver for JDBC and
SQLJ.
- Test the XML schema repository setup.