Setting up the XML schema repository

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)
  • Start of changez/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
  • 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:

  1. 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.
  2. Define the WLM environment and startup procedure for the C language XML schema repository stored procedures.
  3. Define the WLM environment and startup procedure for the Java language XML schema repository stored procedure.
  4. Define the XML schema repository stored procedures to DB2.
  5. 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.

  6. Bind the packages for the IBM Data Server Driver for JDBC and SQLJ.
  7. Test the XML schema repository setup.