Preparing your DB2 database on a separate server from InfoSphere MDM

Set up the IBM® DB2® database for deployments where the database and InfoSphere® MDM installations are on different servers.


  1. On the machine where you plan to install InfoSphere MDM, you must do the following:
    1. Install the DB2 client software.
    2. Catalog the remote database to the local server. Use the following commands, replacing the placeholders with appropriate values:
      db2 catalog tcpip node <NODE_NAME> remote <DB_SERVER> server <PORT_NUMBER>
      db2 catalog db <DB_NAME> as <DB_NAME> at node <NODE_NAME> authentication server
  2. Use the WebSphere® Application Server Integrated Solutions Console to create a DB2_JDBC_DRIVER_PATH WebSphere Application Server environment variable, pointing to the DB2 instance home on the local machine and targeting the node level.