Device Manager


Installing the IBM DB2 database client

The database client must be installed on the Device Manager server (if your database server is installed on a different computer) and on any client computers where you want to run the Device Manager console.

The basic steps to installing the DB2 database client are:

  1. Install the database client
  2. Configure the database client
  3. Set up the database client to use JDBC 2

1. Install the database client

Run Setup from the DB2 product CD to display the DB2 Universal Database Enterprise Edition interface.

From the DB2 Universal Database Enterprise Edition interface:

  1. On the left, click Install. The Setup window appears.
  2. Select the DB2 Administration Client checkbox.
  3. Select the Typical radio button.
  4. Accept the default or type a value in the Path field, then click Next.
  5. Type dmsadmin in the Username field and ibmdb2 in the password fields, then click Next.
  6. To create the ID, click Yes.
  7. To start copying files, click Next. Progress indicators and message windows appear.
  8. On the Setup Complete window, click Finish.
  9. On the left of the DB2 Universal Database Enterprise Edition interface, click Exit.

2. Configure the database client

On the Windows desktop, click Start --> Programs --> IBM DB2 --> Client Configuration Assistant to start the IBM DB2 for Windows Client Configuration Assistant interface.

From the IBM DB2 for Windows Client Configuration Assistant interface:

  1. On the Welcome window, click Add Database.

  2. On the Source tab, select the Manually configure a connection radio button and click Next.

  3. On the Protocol tab, Select the TCP/IP radio button and click Next.

  4. On the TCP/IP tab:
    1. Type the database server name and domain in the Host name field
      (for example, mydbhost.ibm.com)
    2. Complete the Port number field (for example, 55555).
    3. Leave the optional Service name field blank.
    4. Click Next.
  5. On the Database tab, type dms in Database name and Alias fields, and click Next.

  6. Click Finish.

  7. On the Confirmation window, click Test Connection to verify database communications are okay.

  8. On the Connect to DB2 Database window, type dmsadmin in the User ID field and ibmdb2 in the Password field, then click OK.

    When the message The connection test was successful appears, click OK.

  9. To exit the window, click Close.

  10. To exit the Client Configuration Assistant interface, click Close.

3. Set up the database client to use JDBC 2

The DB2 database client must be set up to use the JDBC 2 driver.

  1. On the Windows desktop, click Start --> Settings --> Control Panel --> Services and stop any running DB2 services.

  2. Open a DOS window.

  3. From the DOS prompt, issue the following commands in the order given: 
    cd program files
cd sqllib
cd java12
jdbc20
usejdbc2

  4. Restart the Windows computer, and close the Client Configuration Assistant interface if it appears.

Return to:

Downloading the Device Manager console