About this task
A database definition file holds the physical data
model that details all the database resources, such as the schema,
the tables, and other resources, that you need access to.
Note: Database
definition files in the IBM® Integration Toolkit are
not automatically updated. If you modify your database, you must recreate
the database definition file describing the connection to the database.
Procedure
Complete the following steps to create the CLIENTS.dbm database
definition file by using the New Database Definition File wizard:
- In the Application Development view,
right-click and select .

The New Database Definition File wizard
is displayed.
- From the Data design project drop-down
list, select AddressBook_DD. From the Database drop-down
list, select DB2 for Linux, Unix, and Windows.
From the Version drop-down list, select V9.7.
Then, click Next.
- Create a database connection. In the New Database
Definition File - Select connection, select New.

A New
Connection window opens.
- In the New Connection - Connection Parameters,
edit the following properties to configure the CLIENTS database
connection:
- Enter CLIENTS as the Database value.
- Enter db2admin as the User
name, and enter your database administrator password in Password.
Note: You can use a different user name to connect to the
database. This user must have database administration permissions.
- Click Test Connection to verify
the settings that you selected for your database.
If
the connection is successful, the following window opens:

- Select Save Password.
- In the New Connection - Connection Parameters,
click Finish.
The CLIENTS1 connection
is created.

- Select the CLIENTS1 connection,
and then select Next.

- Select the schema ADDRESSBOOK, and
then click Next.

- In the New Database Definition File - Database
Elements window, select Tables,
then click Finish.
Results
The CLIENTS.dbm database definition file is available in
the Application Development view under Independent
resources. The database definition file is created inside
the AddressBook_DD data project.

The following
figure shows the CLIENTS database definition
file opened in the Physical Data Model Editor.

What to do next
After you create the database definition file CLIENTS.dbm,
you must configure your integration solution to access specific database
resources. For more information, see Configuring an integration solution to access database resources.