IBM Tivoli Monitoring > Version 6.3 Fix Pack 2 > Installation Guides > High Availability Guide for Distributed Systems > Create clusters with monitoring components in a System Automation for Multiplatforms environment > Set up a cluster for Tivoli Monitoring > Predefined Tivoli System Automation for Multiplatforms Cluster for Tivoli Monitoring > Building a Tivoli System Automation for Multiplatforms Cluster for the portal server and Tivoli Data Warehouse components
IBM Tivoli Monitoring, Version 6.3 Fix Pack 2
Create the Database for Portal server/Tivoli Data Warehouse on node1
The next step is to create the database, either for the portal server or for the Tivoli Data Warehouse:
Use lsrg -m to find the active cluster node. On the active node, perform the following steps:
Procedure
- Create a directory for the database on the shared file system, such as:
/shareddisk/DBdirectory
- Grant full access or ownership of this directory to the DB2 instance owner, typically to the user db2inst1, by running:
chown db2inst1 /shareddisk/DBdirectory
- 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 /shareddisk/DBdirectory
- For Tivoli Data Warehouse: db2 create database <DBName> on /shareddisk/DBdirectory using codeset UTF-8 territory US
- Test the connection to the database using the command:
db2 connect to <DBName>
- After successful connection, reset the connection using the command:
db2 connect reset
- Create a database user ID on both nodes with the same GUUID and UUID.
- Grant full database access to this user ID on node1.
Use the same IDs on both nodes allows the database operations to work correctly.
Parent topic:
Building a Tivoli System Automation for Multiplatforms Cluster for the portal server and Tivoli Data Warehouse components