IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > High Availability Guide for Distributed Systems > Create clusters with Tivoli Monitoring components in an HACMP environment > Define the base cluster for Tivoli Monitoring
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Create the database for the portal server or data warehouse on clusternode1
About this task
The last step is to create the database, either for the portal server or for the data warehouse:
Procedure
- Bring the basic cluster resources online on clusternode1 if you have not already done so.
- Create a directory for the database on the shared file system:
/sharedFS/DBdirectory
- Grant full access to or ownership of this directory to the DB2 instance owner, usually to the user db2inst1.
- Switch to the user ID of the instance owner.
- Create a database using the DB2 CLI on the active node, using one of these commands:
- for the portal server:
db2 create database <DBName> on /sharedFS/DBdirectory
- for the data warehouse:
db2 create database <DBName> on /sharedFS/DBdirectory using codeset UTF-8
territory US
- Test the connection to the database using the command:
db2 connect to <DBName>
- After a successful connection, reset the connection with this command:
db2 connect reset
- Create a database user ID on both nodes with the same GID and UID, and grant full access to the database to this user ID on clusternode1. Because of the same IDs it should now also work for the same user on clusternode2.
Parent topic:
Define the base cluster for Tivoli Monitoring