IBM BPM, V8.0.1, All platforms > Administer the IT infrastructure

Manage Business Performance Data Warehouses

The Business Performance Data Warehouses in your IBM BPM configuration retrieve and store tracked performance data, which enables users in IBM Process Designer to create reports and also analyze processes using the Optimizer.

Use the Performance Admin Console to work with Performance Data Warehouse queues, manage data transfer errors, and monitor overall performance. To access the Performance Admin Console, use one of the following options:

• Point your web browser to http://[host_name]:[port]/PerformanceAdmin, providing the name of the host where the Performance Data Warehouse is installed and the port designated for the Performance Data Warehouse during IBM BPM installation.

• If you are working on a Windows host where the Performance Data Warehouse is installed, click Start > IBM BPM > Performance Admin Console .

Log in to the Process Admin Console with the administrator account and password that was specified on the Administrative Security page during IBM BPM profile creation.

• Viewing and managing Performance Data Warehouse queues
  As part of IBM BPM maintenance, you might need to view the Performance Data Warehouse load queue to determine which records have yet to be loaded to the database. You might also need to view the error queue to determine whether any errors occurred while data was being loaded from the process server to the Performance Data Warehouse.
• Viewing and managing data transfer errors
  The View Errors page in the Performance Admin Console shows all errors resulting from data transfer between the Process Server and Performance Data Warehouse.
• Viewing Performance Data Warehouse statistics
  The Performance Admin console includes a View Statistics page that enables you to see the number of rows in the tables and views in the Performance Data Warehouse.
• Monitoring the Performance Data Warehouse
  To assess overall performance, you can view statistics (such as duration) for data transfer and other functions run in the Performance Data Warehouse. Use the View Instrumentation page to help identify performance bottlenecks to capture instrumentation data for further analysis.
• Use the Performance Data Warehouse command-line tool
  To ensure that performance databases are performing optimally, use the command-line tool to resolve any pending records. When you run the command available with the tool, it generates an SQL script that you can use to make the appropriate database changes.
• Disable automatic schema management
  Use the <automatic-schema-management> configuration property to control automatic schema management for the Performance Data Warehouse.

Administer the IT infrastructure

Related concepts:
Business Performance Data Warehouse tracking group views