IBM Books

XML Extender Administration and Programming

Setting up

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.

Important: If you have completed the XML column lesson and have not cleaned up your environment, you might be able to skip this step. Check to see if you have a SALES_DB database.

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:

Important: If you have completed the XML column lesson and have not cleaned up your environment, you might be able skip this step.

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 ]