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:
DB2CMD
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:
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