Running Performance Warehouse in a data-sharing environment

The Performance Warehouse database is maintained by the OMEGAMON® Collector that runs with the startup parameter PERFORMANCEWAREHOUSE=YES. In a data-sharing group, the OMEGAMON Collectors might be installed on more than one member.

Start the Performance Warehouse server task only for one OMEGAMON Collector in the data-sharing group to avoid conflicts.

Figure 1 shows a typical data-sharing environment running Performance Warehouse.
Figure 1. Performance Warehouse in a data-sharing environment
Performance Warehouse in a data-sharing environment
The environment includes:
  • Two MVS systems in a Parallel Sysplex® environment with one data-sharing group, DSG 1, that comprises the members A1, A2, and A3, and additional Db2® subsystems B1 and C1.
  • A Performance Warehouse that contains the performance data of the Db2 subsystems A1, A2, and A3, and a Performance Warehouse each for B1 and C1.
  • OMEGAMON Collector 1 that is dedicated to data-sharing group DSG 1 on MVS 1 maintains the Performance Warehouse database in a data-sharing group.

The OMEGAMON Collectors 1, 2, and 4 run the processes to produce reports and load data into the Performance Warehouse database. If SMF data is to be loaded, the OMEGAMON Collector requires read access to the corresponding SMF data set.

Performance Expert Clients that want to use Performance Warehouse connect to the Db2 subsystem or the Db2 data sharing group that contains Performance Warehouse. If you wanted to connect to the data-sharing group and access Performance Warehouse, you would specify the location of DSG 1 as the database name and MVS 1 or MVS 2 as the host name when cataloging the DB2PM database of the OMEGAMON Collector regardless of which member of DSG 1 you want to connect to.