Prepare to upgrade DB2 OLAP Integration Server

If you are upgrading to DB2 OLAP Integration Server Version 8.2 from a previous release, you should assess several system environment and data migration issues before installing the new software.

The following tasks cannot be completed until after you have installed DB2 OLAP Integration Server:

Migrating existing OLAP Metadata Catalogs

If you have an existing OLAP Metadata Catalog from an earlier version of DB2 OLAP Integration Server, you must upgrade it before using the OLAP Metadata Catalog with the current release of the software.

You cannot upgrade an existing OLAP Metadata Catalog until after you have completed the installation process. The Essbase Integration Services setup program installs the scripts that are needed for the upgrade (see Creating or upgrading OLAP Metadata Catalogs).

CAUTION:
If you have installed the sample application from a previous release of Essbase Integration Services, you should back up your existing sample database, OLAP Metadata Catalog, and the OLAP models and metaoutlines stored in the catalog. You can then upgrade your existing catalog to be compatible with the current release of the software. You cannot, however, store new sample OLAP models and metaoutlines in your previous catalog.

To upgrade an existing OLAP Metadata Catalog, perform the following tasks:

  1. Complete the upgrade steps for the existing OLAP Metadata Catalog described in Creating or upgrading OLAP Metadata Catalogs.
  2. When connecting to the relational database, make sure to use the same user name and password that you used when you created the original OLAP Metadata Catalog. This procedure adds new tables to the OLAP Metadata Catalog without disturbing the existing information.
CAUTION:
After you upgrade an OLAP Metadata Catalog, you cannot roll back to the previous release. The new release of OLAP Metadata Catalog is not compatible with previous releases of DB2 OLAP Integration Server. In addition, do not attempt to use the Version 8.1 OLAP Metadata Catalog with previous releases of the software; doing so could result in corrupted catalog data.