Setting up the database

To run the Data Warehouse sample you require a database with one table. An ODBC definition for the database is also required, and the integration node must be configured with a user identifier and password to use when accessing the database.

Complete the following tasks to setup the database environment:

Create the database and ODBC definition.
Follow the instructions that are relevant to your database manager:
- Setting up DB2
- Setting up Oracle
Specify the user identifier and password that are associated with the data source name USERDB.
Use the mqsisetdbparms command to specify a user identifier and password that the integration node can use with the USERDB data source. This user identifier must be the same user identifier that you used when you created the database in the previous step. The user identifier determines the database schema name and the integration node must use the same user identifier when accessing the table. For example, if your user identifier is USERID, the fully qualified name of the DATAWAREHOUSE table name is USERID.DATAWAREHOUSE.
1. Open a command console window in which you can run IBM Integration commands. Enter the following command to specify the user identifier and password.
```
mqsisetdbparms IB9NODE -n USERDB -u <user ID> -p <password>
```
2. Enter the following command to reload the integration server.
```
mqsireload IB9NODE -e "Data Warehouse"
```

Back to sample home