The message flow used in this scenario requires an external
database, which is used in one of the message maps that enriches the
message data as it runs the transformation. The database must be set
up in advance.
Procedure
Complete the following steps to set up the sample DB2
database configuration that was used to develop the scenario:
- Create a database named CLIENTS.
- Open a DB2 command prompt and create the database. Click , and select Command Window. DatabaseInstance is
your DB2 instance name, which by default is the following: DB2COPY1 (default).
A DB2 - CLP window opens.
- Create the CLIENTS database.
Run the following command: DB2 CREATE DB CLIENTS
You receive the following message: DB20000I
The CREATE DATABASE command completed successfully.
- Test the database connection. Run the following command: DB2 CONNECT TO CLIENTS
- Create the tables using the SQL createdbtablesclients.sql script provided in the scenario.
- Unzip the file createdbtablesclients.zip.
- From the DB2 command prompt, run the following command:
db2 -vf Sqlscriptdirectory\createdbtablesclients.sql, where Sqlscriptdirectory\ is the directory where
you unzip createdbtablesclients.zip.
Results
You have a database named CLIENTS, and the following database
tables created under the
ADDRESSBOOK schema: