Process metrics data is generated by schedules and through the execution of workflow processes. You can collect this data from processes running on a grid by configuring the connection to the database appropriately.
For successful collection of process metrics data, the grid must have a configured connection to the database, and at least one peer on that grid must be designated as a synchronization point (sync point). Peers that have been designated as sync points upload the process metrics data to the database.
The first time that process metrics data is uploaded to the database, the system verifies that tables exist to contain the data. If the tables do not exist, the system creates them automatically.
Note
The database user ID used in metric configuration must have authority to create tables, indexes, and sequences, and to populate data into the created tables on an ongoing basis.
The process metrics tables might become large over time as workflows execute. (For schema information for the process metrics tables, see Process metrics table information). You must resize these tables appropriately for your environment and execution load, and decide if and when to archive and purge the data.
Recommendation
BMC recommends that you contact your company's reporting, data warehouse, or database administrator for assistance with exporting and purging metric table data.
BMC Atrium Orchestrator Grid Manager does not display any collected process metrics. To view process metrics, you must use the tools available for the database program that you are using to collect the data. However, if you install the graphing components on the CDP, you can generate process metrics reports.