IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > High Availability Guide for Distributed Systems > Create clusters with Tivoli Monitoring components in a Microsoft Cluster Server environment > Set up Tivoli Data Warehouse components in a Microsoft Cluster Server > Install and set up Tivoli Data Warehouse components in the cluster
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Set up the Tivoli Data Warehouse database and ODBC DSN in the cluster
Set up the Tivoli Data Warehouse DB by completing the following steps:
Make sure the Tivoli Data Warehouse resource group is running on clusternode1.
Parent topic:
Install and set up Tivoli Data Warehouse components in the cluster
On clusternode1
Procedure
- Create a local user on clusternode1 (for the Tivoli Data Warehouse DB access, for instance, ITMUser).
- Create the Tivoli Data Warehouse database under the clustered instance on the shared drive R, for instance, Warehouse.
- Grant access to the Tivoli Data Warehouse DB to the user.
- In the ODBC data sources on the computer, create a System DSN named ITM Warehouse, point to the previously created Tivoli Data Warehouse database, and test the connection.
- Move the Tivoli Data Warehouse resource group to clusternode2.
On clusternode2
Procedure
- Create a local user (same as in clusternode1) on clusternode2 for the Tivoli Data Warehouse DB access.
- Start the DB2 Control Center and make sure that the access has been granted to the user.
- In the ODBC data sources, create a System DSN named ITM Warehouse, point to the Tivoli Data Warehouse database, and test the connection.
- Move the Tivoli Data Warehouse resource group back to clusternode1.