DB2 OLAP Server Installation Guide

Upgrading the OLAP Metadata Catalog

If you have existing OLAP Metadata Catalogs from a release earlier than DB2 OLAP Integration Server Version 8.1, and you choose to create the OLAP Metadata Catalog manually, you must upgrade the existing OLAP Metadata Catalogs before you can use them with this release.

Note:

If you used Essbase Integration Services Console to create an OLAP Metadata Catalog automatically after completing installation, the system upgrades your existing OLAP Metadata Catalog and you do not need to upgrade it.

Upgrade the tables of an OLAP Metadata Catalog with the same utility program you normally use to create tables running SQL scripts. The SQL scripts to upgrade tables for the OLAP Metadata Catalog are in the ocscript directory where you installed DB2 OLAP Integration Server. The upgrade scripts are named oc_upgrade6x_database_name.sql and are listed in Table 21 and Table 16, along with the utility programs with which they have been tested.

To upgrade tables for the OLAP Metadata Catalog database:

1. Start the utility program.
2. Connect to the database you created for the OLAP Metadata Catalog as the user who created the original OLAP Metadata Catalog tables.
3. Open the appropriate SQL script file in the ocscript directory.
4. Run the SQL script to upgrade the tables.
5. Verify that you have created the additional OLAP Metadata Catalog tables. For example, type the following command:

   SELECT * FROM OM_DESCRIPTION
   

   or start the RDBMS and verify that the OLAP Metadata Catalog has the new tables.

6. Close the utility program.