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.
If you are using the MERANT ODBC drivers supplied with a previous release of DB2 OLAP Integration Server on Windows NT, 2000, or XP, you must upgrade the drivers to version 4.0 when you install DB2 OLAP Integration Server Version 8.1. See Supported ODBC drivers and relational data sources for a complete listing of the ODBC drivers supported per database and operating system.
AIX and HP-UX: DB2 OLAP Server Version 8.1 supports Java Runtime Environment (JRE) 1.2.2, whereas DB2 OLAP Integration Server Version 8.1 requires JRE 1.3. If both DB2 OLAP Server and DB2 OLAP Integration Server are installed on same computer and the same user ID starts both servers, you must set the Java environment variables associated with each server so that, depending on whether you are logged on as the DB2 OLAP Server user or the DB2 OLAP Integration Server user, the correct version of Java is referenced.
For examples of how you might set the JAVA_HOME and related variables to point to the version of Java required by OLAP Server and Integration Services, see Chapter 6, Installing and configuring Java.
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.
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.
Attention: 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, as described in this section. You cannot, however, store new sample OLAP models and metaoutlines in the previous catalog.
Caution:
After you have updated 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 catalog with previous
releases of DB2 OLAP Integration Server. Doing so could result in
corrupted OLAP Metadata Catalog data.
To update an existing OLAP Metadata Catalog, complete the upgrading steps as described in this guide. When connecting to the relational database, make sure that you use the same user name and password as you used when you created the original OLAP Metadata Catalog.
The OLAP Metadata Catalog Setup dialog box is displayed at the initial logon to Essbase Integration Services Console. You can use this dialog box to upgrade an existing OLAP Metadata Catalog automatically.