Migrating DB2 OLAP Integration Server

To help you create and execute your migration plan, this chapter provides information about platform support and hardware requirements, as well as planning for migrating OLAP outlines, databases, models, metaoutlines, and open database connectivity (ODBC) definitions.

Before you install DB2 OLAP Integration Serverm, back up all files from earlier releases. This will enable you to revert to an earlier release level if you encounter problems.

ODBC drivers on Windows

If you are using the DataDirect ODBC drivers supplied with a previous release of DB2 OLAP Integration Server on Windows, you must upgrade the drivers to version 4.2 when you install DB2 OLAP Integration Server Version 8.2. See Supported ODBC drivers and relational data sources for a complete listing of the ODBC drivers supported per database and operating system.

Supported JDBC drivers for XML import/export

JDBC drivers are required to support the XML Import/Export functionality in DB2 OLAP Integration Server.

JDBC Type 1 is installed when you install the Java Runtime Environment. With the exception of Oracle, JDBC Type 1 is compatible with all RDBMSs supported by DB2 OLAP Integration Server. For information on supported JDBC drivers, see Supported JDBC drivers for XML Import/Export in OIS.

Migrating existing OLAP metadata catalogs

If you have an existing OLAP Metadata Catalog from a previous release of DB2 OLAP Integration Server, you must update it before using OLAP Metadata Catalog with the new version of the software.

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

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

CAUTION:
After you update 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.2 catalog with previous releases of DB2 OLAP Integration Server. Doing so could result in corrupted OLAP Metadata Catalog data.