Use this scenario as a reference when planning and installing InfoSphere MDM on a WebSphere Application Server cluster with a DB2 database and IBM WebSphere MQ messaging. This scenario is applicable for DB2 on Microsoft Windows, Linux, or UNIX operating systems.
This scenario is accomplished through four procedures.
1. Prepare your application server.
2. Prepare your DB2 database.
3. Prepare IBM WebSphere MQ messaging.
4. Install InfoSphere MDM.
In this scenario, the topology is:
v Machine A:
– WebSphere Application Server Deployment Manager – DB2 client software
– IBM Installation Manager and InfoSphere MDM v Machines B, C, and D:
– WebSphere Application Server managed nodes – DB2 client software
v Machine E:
– DB2 database v Machine F:
– IBM WebSphere MQ
Preparing the IBM DB2 database:
Use this procedure to install and prepare your DB2 database as a second step in completing this scenario.
About this task
The resulting topology from this procedure is that machine E hosts the DB2 software and database, and machines A, B, C, and D have the DB2 client software.
Procedure
1. Install DB2 database. Use the IBM DB2 installation documentation as a guide.
a. Install DB2 on machine E.
b. Install DB2 client software on machines A, B, C, and D.
c. Catalog DB2 client on machine A to connect to the DB2 database server on machine E. Repeat this step for machines B, C, and D.
2. Create the database and table spaces by using the scripts that are provided in the Installation Startup Kit.
3. Make sure that DB2 Client $HOME/sqllib/bin is included in the PATH on machine A. This step is required for IBM Installation Manager to implement the
$HOME/sqllib/bin/db2utility when running the SQL scripts.
Related tasks:
“Installing and setting up the database” on page 81
“Preparing a DB2 database” on page 82
“Installing the Installation Startup Kit” on page 73 Related reference:
“DB2 or DB2 for z/OS data source worksheet” on page 27
Preparing WebSphere Application Server Network Deployment:
For the first step in completing this installation scenario, install and prepare your application server.
About this task
The resulting topology from this procedure is that machine A has WebSphere Application Server Deployment Manager and machines B, C, and D have WebSphere Application Server managed nodes.
Procedure
1. Install and configure WebSphere Application Server on machines A, B, C, and D. Use the WebSphere Application Server Network Deployment documentation as a guide.
2. Create two WebSphere Application Server clusters. CLUSTER1 for the MDM operational server and CLUSTER2 for the user applications.
3. Create a DB2_JDBC_DRIVER_PATH WebSphere Application Server
environment variable for each node in the cluster. The path must point to the JDBC drivers for each machine. For example, if the DB2 client and JDBC drivers are installed at $USER_HOME/sqllib/java, specify the
DB2_JDBC_DRIVER_PATH equal to $USER_HOME.
4. Make sure that all managed nodes are properly synchronized before you begin installing InfoSphere MDM.
5. Make sure that you know the WebSphere Application Server Deployment Manager host name and SOAP port before you start the InfoSphere MDM installation. Use the WebSphere Application Server configuration worksheet to record your values.
6. Make sure your cluster is started before you begin the InfoSphere MDM installation.
Related concepts:
“Installing and setting up the application server” on page 75 Related tasks:
“Preparing WebSphere Application Server Network Deployment for a managed server deployment” on page 76
“Preparing your DB2 database to use InfoSphere MDM in a clustered environment” on page 84
Related reference:
“WebSphere Application Server installation worksheet” on page 33 Preparing IBM WebSphere MQ:
Use this procedure to install and prepare IBM WebSphere MQ as a third step in completing this scenario.
Procedure
1. Install IBM WebSphere MQ on machine F. Use the IBM WebSphere MQ installation documentation as a guide.
2. Create the WebSphere MQ queue manager, channel, and queues by using the custSetupMQServer.mqscand ChannelAuth.mqsc scripts. These scripts are included in the Installation Startup Kit.
Related tasks:
“Installing the Installation Startup Kit” on page 73 Related reference:
“InfoSphere MDM application configuration worksheet” on page 36
“Installation Startup Kit for custom installations” on page 10 Installing InfoSphere MDM:
Use this procedure to install InfoSphere MDM and any selected user applications as the final step in completing this scenario.
About this task
Make sure that your application server and database are started before you begin the InfoSphere MDM installation.
Procedure
1. Start IBM Installation Manager on machine A and choose your InfoSphere MDM offering. Continue through the prompts.
2. Specify the InfoSphere MDM installation home and shared directories. For example, MDM_INSTALL home /usr/IBM/MDM/E001/mdm and Shared -/usr/IBM/MDM/E001/Shared
3. Choose the MDM Database, MDM Operational Server, and any user applications or other features you want to install. For example: select the Applications feature to install all user applications, or select specific applications.
4. On the Database Configuration panel, specify the database type and database parameters. You can choose whether you want to test the database connection by selecting Test Connection or select No connection test required.
5. On the WebSphere Application Server Configuration panel, specify the application server parameters. Select Retrieve Host Details to obtain your Cell, Node, and Server information. Select Install MDM application on cluster. Choose CLUSTER1 from the Cluster list.
6. On the Application Configuration panel, select IBM WebSphere MQ messaging and enter the parameters. Clear the Configure messaging server option to prevent IBM Installation Manager from creating a queue manager on machine A (because the queue manager is enabled on machine F).
7. On each individual user application configuration panel, provide the parameters. Select Install MDM application on cluster. Choose CLUSTER2 from the Cluster list.
8. Click Verify Installation Requirements to run the prerequisite checks. Review and correct any errors or warnings, then click Recheck.
9. When the verification checks pass successfully, click Install.
10. When the installation is complete, view the logs and use the installation verification tools.
Related concepts:
“Prepare IBM Installation Manager” on page 72
“Worksheets for installation and configuration” on page 26
“Verifying the base installation” on page 159 Related tasks:
“Installing a custom deployment of InfoSphere MDM” on page 113 Troubleshooting an installation
Scenario: Installing InfoSphere MDM on a WebSphere Application Server cluster, using an Oracle database and WebSphere Default Messaging
Use this scenario as a reference when planning and processing an InfoSphere MDM installation on a WebSphere Application Server cluster. This scenario uses an Oracle database and WebSphere Default Messaging.
This scenario is accomplished through three procedures.
1. Prepare your application server.
2. Prepare your Oracle database.
3. Install InfoSphere MDM.
In this scenario, the topology is:
v Machine A:
– WebSphere Application Server Deployment Manager – Oracle client software
– IBM Installation Manager and InfoSphere MDM v Machines B, C, and D:
– WebSphere Application Server managed nodes – Oracle client software
v Machine E:
– Oracle database
Preparing the Oracle database:
Use this procedure to install and prepare your Oracle database as a second step in completing this scenario.
About this task
The resulting topology from this procedure is that machine E hosts the Oracle software and database, and machines A,B,C, and D have the Oracle client software.
Procedure
1. Install Oracle database. Use the Oracle installation documentation as a guide.
a. Install Oracle on machine E.
b. Install the Oracle client software on machines A, B, C, and D.
c. Point the TNS name on machine A to connect to the remote Oracle database server on machine E.
2. Create the database and table spaces by using the scripts that are provided in the Installation Startup Kit.
To install MDM with Oracle, your DB user name and schema name must be the same.
3. Make sure Oracle Client sqlplus is included in the PATH on machine A. This step is required for IBM Installation Manager to implement the sqlplus utility when running the SQL scripts.
Related tasks:
“Installing and setting up the database” on page 81
“Preparing an Oracle database” on page 87
“Installing the Installation Startup Kit” on page 73
Related reference:
“Oracle data source worksheet” on page 31
Preparing WebSphere Application Server Network Deployment:
Use this procedure to install and prepare your application server as a first step in completing this scenario.
About this task
The resulting topology from this procedure is that machine A has WebSphere Application Server Deployment Manager, and machines B, C, and D have WebSphere Application Server managed nodes.
Procedure
1. Install and configure WebSphere Application Server on machines A, B, C, and D. Use the WebSphere Application Server Network Deployment documentation as a guide.
2. Create a WebSphere Application Server cluster named CLUSTER1 for the MDM operational server.
3. Create an ORACLE_JDBC_DRIVER_PATH WebSphere Application Server environment variable for each node in the cluster. The path must point to the JDBC drivers for each machine. For example, if the Oracle client and JDBC drivers are installed at $USER_HOME/jdbc/lib/ojdbc6.jar, specify the ORACLE_JDBC_DRIVER_PATH equal to $USER_HOME.
4. Make sure that all managed nodes are properly synchronized before you begin installing InfoSphere MDM.
5. Make sure that you know the WebSphere Application Server Deployment Manager host name and SOAP port before you start the InfoSphere MDM installation. Use the WebSphere Application Server configuration worksheet to record your values.
6. Make sure your cluster is started before you begin the InfoSphere MDM installation.
Related concepts:
“Installing and setting up the application server” on page 75 Related tasks:
“Preparing WebSphere Application Server Network Deployment for a managed server deployment” on page 76
“Preparing your Oracle database to use InfoSphere MDM in a clustered environment” on page 89
Related reference:
“WebSphere Application Server installation worksheet” on page 33 Installing InfoSphere MDM:
Use this procedure to install InfoSphere MDM and any selected user applications as the final step in completing this scenario.
About this task
Make sure that your application server and database are started before you begin the InfoSphere MDM installation.
Procedure
1. Start IBM Installation Manager on machine A and choose your InfoSphere MDM offering. Continue through the prompts.
2. Specify the InfoSphere MDM installation home and shared directories. For example, MDM_INSTALL Home /usr/IBM/MDM/E001/mdm and Shared -/usr/IBM/MDM/E001/Shared
3. Choose the MDM Database, MDM Operational Server, and any user applications or other features you want to install. For example: select the Applications feature to install all user applications, or select specific applications.
4. On the Database Configuration panel, specify the database type and database parameters. You can choose whether you want to test the database connection by selecting Test Connection or select No connection test required.
5. On the WebSphere Application Server Configuration panel, specify the application server parameters. Select Retrieve Host Details to obtain your Cell, Node, and Server information. Select Install MDM application on cluster. Choose CLUSTER1 from the Cluster list.
6. On the Application Configuration panel, select IBM WebSphere Default Messaging.
7. On each individual user application configuration panel, provide the parameters. Select Install MDM application on cluster. Choose CLUSTER1 from the Cluster list.
8. Click Verify Installation Requirements to run the prerequisite checks. Review and correct any errors or warnings, then click Recheck.
9. When the verification checks pass successfully, click Install.
10. When the installation is complete, view the logs and use the installation verification tools.
Related concepts:
“Prepare IBM Installation Manager” on page 72
“Worksheets for installation and configuration” on page 26
“Verifying the base installation” on page 159 Related tasks:
“Installing a custom deployment of InfoSphere MDM” on page 113 Troubleshooting an installation