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.
- On the machine where you plan to install InfoSphere MDM,
you must do the following:
- Install the DB2 client software.
- Catalog the remote database to the local server. Use
the following commands, replacing the placeholders with appropriate
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
- Use the WebSphere® Application Server Integrated
Solutions Console to create a
DB2_JDBC_DRIVER_PATHWebSphere Application Server environment variable, pointing to the DB2 instance home on the local machine and targeting the node level.