Updating the Performance Warehouse

If you created a Performance Warehouse for an earlier version, you must manually update it for 5.4.0.

Before you begin

Due to data model changes, you will need to manually update data stored in Statistics tables to 5.4.0.

If Performance Warehouse is enabled, the new OMEGAMON Collector automatically detects older Performance Warehouse versions and stops the Performance Warehouse server task.

If you are starting with version 5.4.0, delete the existing Performance Warehouse database DB2PM from the old version and drop the plan DB2PM and its packages. There are no further update steps. Note that if Performance Warehouse is enabled in the configuration, the OMEGAMON® CollectorOMEGAMON Collector of the new version automatically manages the bind of its packages in the plan DB2PM and creates the Performance Warehouse tables.

Note: After you update the Performance Warehouse tables, Db2 might place the table space STAT in advisory REORG-pending (AREO*) status because existing data is not immediately converted to its new definition. You can reorganize the table space to prevent possible performance degradation. When data is in REORG-pending or AREO* status, you can automatically re-organize partitions using the REORG utility with the SCOPE PENDING option - you do not need to identify which partitions need to be reorganized or customize the REORG control statement.

Procedure

  1. Disconnect all workstation clients and stop the OMEGAMON Collector enabled for the Performance Warehouse.
  2. Drop the table space STAT in the database DB2PM.
  3. Start the new OMEGAMON Collector with the newly created Performance Warehouse configuration and Performance Warehouse response file.
    The Collector recreates the table space STAT and create the new Statistics tables. The table space STAT has a default size of 32K and a minimum size of 4K.
    Note: If this step fails, continue to step 5; otherwise, continue with step 4.
  4. Stop the Performance Warehouse server task using the following console command: /F <started task>,F PESERVER,F <db2ssid>, PWH=N.
  5. Restart the Performance Warehouse server task in FORCE mode by using the following console command: /F <started task>,F PESERVER,F <db2ssid>, PWH=F .