An existing Business Measures group has a new column

When you add a new business measure (metric) to an existing Business Measures group, a new column is added in some instances tables in the State, Runtime, and Historical databases.

The tables, which are updated with the new columns, are selected according to the Usage in WebSphere Business Monitor attribute of the metric being added. The affected databases are shown in the following table:
Metric usage in WebSphere® Business Monitor databases
Usage in WebSphere Business Monitor State database Runtime database Historical database
Temporary calculation Yes No No
Active data about running processes Yes Yes No
Quantitative data in dimensional analysis Yes Yes Yes
Aggregation group in dimensional analysis Yes Yes Yes
After you add a new business measure (metric) in the Business Measures editor, you use the Schema Generator to generate the scripts needed to alter the created databases (State, Runtime and Historical databases) and replication settings. To alter the databases, deploy the Database Definition Language (DDL) scripts on the DB2® command window to add the new columns to the database tables.

To synchronize replication among databases, update the DB2 Replication Center with the new columns that correspond to the newly added metric by deploying replication scripts on the DB2 command window.

When a new metric is added to a process, you need to do the following:

Copyright IBM Corporation 2005, 2006. All Rights Reserved.