Creating the scenario database configuration

The message flow that is 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. DB2® must be set up in advance.

Complete the following steps to set up the sample DB2 database configuration that was used to develop the scenario:

1. Create a database that is named CLIENTS.
   1. Open a DB2 command prompt and create the database. Click Start > All Programs > IBM DB2 > DatabaseInstance > Command Line Tools, and select Command Window. DatabaseInstance is your DB2 instance name. The default name is DB2COPY1 (default).

      A DB2 - CLP window opens.

   2. Create the CLIENTS database. Run the following command: DB2 CREATE DB CLIENTS

      You receive the following message: DB20000I The CREATE DATABASE command completed successfully.

   3. Test the database connection. Run the following command: DB2 CONNECT TO CLIENTS
      Note:

      If you receive the error ErrorCode = -4499, SQLState = 08001, check that the port used is correct, and try again.

2. Create the tables using the SQL createdbtablesclients.sql script that is provided in the scenario.
   1. Unzip the file createdbtablesclients.zip.
   2. 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 that is named CLIENTS, and the following database tables are created under the ADDRESSBOOK schema:

• PERSON
• ADDRESS
• PHONE