Configuring the metrics database - Documentation for (archive) BMC Atrium Orchestrator Platform 7.6.03

To gather and store metrics information, you must turn on data collection and configure the database connection. You must turn on collection and configure the database connection separately for process metrics and grid performance metrics, even if the same database is used.

To install the JDBC driver

BMC Atrium Orchestrator must have access to the JDBC driver for the database that you are configuring. The JDBC driver is a Java class that is usually distributed in a .jar file by the database company. BMC Software provides the driver for Oracle (ojdbc-1.4.jar) in the AO_HOME/lib/shared directory. To use any other database, you must obtain and install the JDBC driver for that database.

1. Download the JDBC driver for your database platform from the database company or other provider.
2. Copy the driver to the AO_HOME/lib/add-ons directory on the CDP and on each peer designated as a sync point.

   You can designate a peer as a sync when you add it to the grid. You can also change the sync attribute of a peer.

3. Restart the BMC Atrium Orchestrator service on each computer on which you installed the driver.
   Grid Manager will look first in the AO_HOME/lib/shared directory and then in the AO_HOME/lib/add-ons directory for a driver.

To turn on metrics collection and configure the connection to the database

1. Perform the appropriate action in the Grid Manager application:
2. Select the database type for your database platform.

   Note

   Databases listed in the Supported section are supported by BMC Customer Support. Databases listed in the Other section can interface with BMC Atrium Orchestrator but are not supported by BMC Customer Support.

   After you select a database type, the URL field populates with a default value. The URL is used to establish JDBC connectivity to the database; you can change the default value as needed.

   The Driver field is also populated with a default value when you select a database type. You can change this value as needed to reflect the fully qualified classname for the selected JDBC driver for the metrics database.

   See the topic Database URLs and drivers for more information.

3. (optional) Type new values for the URL and driver as needed.
4. In User, type the name of the user for the database.
   This user must have permissions to create tables, to insert records into those tables, and to select records.
5. Enter and confirm the database user password.
6. Using the Upload Once Every list, select the frequency with which to upload metrics data.
7. Click OK to save the database connection configuration.

Related topics

Database URLs and drivers
Adding peers
Changing peers