IBM Books

XML Extender Administration and Programming

Setting up

In this section, you prepare the database for use with the XML Extender. You will:

  1. Create the database.
  2. Enable the database.

Creating the database

In this section, you use a command to set up the database. This command creates a sample database, connects to it, creates the tables to hold data, and then inserts the data.

To create the database:

  1. Change to the DXX_INSTALL\samples\cmd directory, where DXX_INSTALL is the drive and directory where you installed the XML Extender. The c:\dxx directory is assumed in these lessons. Change these values if your drive and directory are different.
  2. Open the DB2 Command Window from the Windows NT Start menu, or enter the following command from the Windows NT command prompt:
    DB2CMD
    
  3. From the DB2 Command Window, run the following command:
    getstart_db.cmd
    

Enabling the database

To store XML information in the database, you need to enable it for the XML Extender. When you enable a database for XML, the XML Extender:

To enable the database for XML:

From the DB2 Command Window, run the following script to enable the SALES_DB database:

getstart_prep.cmd

This script binds the database to the XML Extender stored procedures and the DB2 CLI. It also runs the dxxadm command option that enables the database:

dxxadm enable_db SALES_DB


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]