XML Extender Administration and Programming
In this section, you prepare the database for use with the XML
Extender. You will:
- Create the database.
- Enable 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:
- 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.
- Open the DB2 Command Window from the Windows NT Start menu, or enter the
following command from the Windows NT command prompt:
DB2CMD
- From the DB2 Command Window, run the following command:
getstart_db.cmd
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:
- Creates all the user-defined types (UDTs) and user-defined functions
(UDFs).
- Creates and populates control tables with the necessary metadata that the
XML Extender requires.
- Creates the db2xml schema and assigns the necessary privileges.
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 ]