Upgrading PMF Data

In this section:

Whenever a new release of Performance Management Framework is introduced, refer to this section of the manual for special migration instructions.


Top of page

x
Upgrade Prerequisites

Back up any existing data that you are currently using.

Note: It is important to back up existing data marts. If the migration procedure is not completed as expected, you will still have working copies.


Top of page

x
Migrating a PMF Data Mart From PMF 5 and Upward

If you are using a PMF data mart that is V5 level or higher, PMF will be able to autonomically upgrade its data mart. When logged in as an administrator, PMF will check to see if your data mart is current. If it is out of date, you will be prompted to allow it to be upgraded.


Top of page

x
Migrating a PMF Data Mart From PMF 4.2 to PMF 5

How to:

This topic describes how to migrate Performance Management Framework from Release 4.2 to Release 5. Migrating from PMF 4.2 to 5 consists of two procedures, running the PMF conversion utility program and synchronizing the dimensions in your underlying database with the WebFOCUS metadata files provided with PMF 4.2.

PMF 5 is delivered with a database-specific migration script that converts your existing PMF 4.2 database structures to PMF 5. You must run the script using an appropriate tool for your RDBMS. For example, for Oracle you would likely use SQL*Plus, while for SQL Server, you would likely use the Query Manager.



x
Procedure: How to Run the PMF Conversion Utility Program
  1. Back up existing PMF data marts.
  2. Start the applicable tool for your RDBMS and select the data mart to migrate.
  3. Open the migration scripting query file:
    \ibi\apps\restore\Upgrade_Database\50_42_sqlmss_migrate.sql
  4. Run the query file. Depending on the size of your measures table, this may take several minutes to complete.
  5. Verify that there were no errors during execution of the query file.
  6. Synchronize the dimensions in your underlying database with the WebFOCUS metadata files.



Example: How to Run the PMF Conversion Utility Program For SQL Server

The following instructions are specific to SQL Server.

  1. Back up existing PMF data marts.
  2. Start the SQL Server Query Manager and select the data mart to migrate.
  3. In SQL Server Query Analyzer, select File > Open, and open the migration scripting query file:
     \ibi\apps\restore\Upgrade_Database\50_42_sqlmss_migrate.sql
  4. Run the query file. Depending on the size of your measures table, this may take several minutes to complete.
  5. Verify that there were no errors during execution of the query file.
  6. Synchronize the dimensions in your underlying database with the WebFOCUS metadata files, as described in the following topic.

WebFOCUS