Database components cluster configuration

Plan and prepare the configuration according to the information set out in this appendix. The appendix contains information specific to BMC-supplied PostgreSQL and third-party database servers (for example, Oracle, MSSQL) that are dedicated to a Control-M application.

If you are planning for clusters on a third-party database server that is not dedicated to a Control-M application, contact the site DBA and Control-M administrator regarding specific cluster requirements.

In a PostgreSQL or existing third-party database server installation, the database server is always installed within the same file system, and the Control-M tablespace can reside on a different file system. Both file systems must belong to the same resource group.

You can use the following types of implementations for the Control-M database in a Windows cluster environment:

• clustered configuration: A single database installation on the cluster can be accessed by both nodes. The database files are located on the shared disk and the database server availability is controlled by the cluster.
• remote database configuration: The database is installed on a non-clustered server or on a cluster different from where Control-M is installed. In this case, only database clients are installed on each of the Control-M cluster nodes.

The database server and the Control-M database must be located on the same file system as Control-M.