Configuring the metrics database
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.
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.
This topic includes the following sections:
To install the JDBC driver
- Download the JDBC driver for your database platform from the database company or other provider.
- Copy the driver to the AO_HOME/lib/add-ons directory on the configuration distribution peer (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.
- 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
- In the Grid Manager application, perform the appropriate action:
- To collect grid performance metrics and audit records, select the Administration tab and then select the Database Configuration tab.
- To collect process metrics, select the Manage tab and then select the Process Metrics tab.
The current collection status is indicated on the page. Use the Turn on or Turn off check box to toggle the status off and on.
Select the database type for your database platform.
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 displays 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. You can change this value as needed to reflect the fully qualified class name for the selected JDBC driver for the metrics database.
See Database URLs and drivers for more information.
- (Optional) Type new values for the URL and driver as needed.
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.
- Enter and confirm the database user password.
- Using the Upload Once Every list, select the frequency with which to upload metrics data.
- Click OK to save the database connection configuration.
Collecting grid metrics and audit records
The following BMC Communities video series demonstrates how to check on the performance of the overall grid and individual peers as well as how you can capture any grid level changes as a part of auditing.
Part one (5:47) provides an overview of grid metrics and audit records. It demonstrates how to set up an external database and add the database driver to the CDP server.
Part two (5:44) demonstrates how to configure the metrics and audit records database in Grid Manager, how to restart the CDP service, so that it reads the database driver file and creates the relevant metrics tables in the database, and how to verify that the audit records were created in the database.
Part three (6:13) demonstrates how to activate an adapter (to verify that audit records collect this user activity), how to configure the grid performance metrics in Grid Manager, designate the CDP as a sync point, and verify that the grid performance metric tables were created in the database.
The video mentions the Value Dashboard component, which is not supported in 7.7.x releases (it is available in 7.8 and later), however, you can use the graphing server to generate reports.
Collecting process metrics
The following BMC Communities video series demonstrates how to collect process metrics data generated through the execution of BAO workflow processes.
Part one (5:42) shows how to set up an external database, configure the process metrics database in Grid Manager, and designate a peer as a sync point.
The video mentions the Value Dashboard component, which is not supported in 7.7.x releases (it is available in 7.8 and later), however, you can use the graphing server to generate process metrics reports.
Part two (8:11) demonstrates how to restart the peer service, so that it reads the database driver file and creates the relevant metrics tables in the external database and how to verify that the tables are in the database. It shows how to set up a workflow to capture process metrics, export the export the process, activate it on the grid, set up appropriate permissions for the workflow, set up a process schedule that runs the workflow, turn on metrics collection, and verify that the metrics were collected.