OLAP Setup and User's Guide

Installing DB2 OLAP Server

You can use DB2 OLAP Server with a new or existing DB2 or DB2 Universal Database, or with a multidimensional storage manager. The Dual Storage Manager component enables you to create applications that use either storage manager, and the ability to switch storage managers for existing applications. See "Selecting a Storage Manager".

If you are installing DB2 OLAP Server and you want to use an RDBMS, you must install the RDBMS separately. DB2 and DB2 Universal Database can be installed either before or after you install DB2 OLAP Server. If you install DB2 Universal Database, make sure that you install the latest DB2 Universal Database fixpack, available from the DB2 Service and Support Web page at http://www.ibm.com/software/data/db2/db2tech/

If you want to install DB2 OLAP Server and Information Catalog Manager on the same system, we recommend that you install both products at the same time.

Information You Need Before You Install

During installation you are asked what edition and options you purchased. This information is used to build a license key for DB2 OLAP Server.

If your installation is new, or if you do not have an existing RDBMS configuration file (rsm.cfg), you will be prompted for information about your relational database name, user ID, and password. You can either add this information during installation, or update the rsm.cfg file after installation is complete.

If you use DB2 or DB2 Universal Database you will need the following information:

Relational database name

The name of the relational database where you want to store your multidimensional data.

Relational database user ID

The user ID that you want DB2 OLAP Server to use to log on to your relational database.

Relational database password

The password for the user ID that you want DB2 OLAP Server to use to log on to your relational database. This password is stored unencrypted in the relational storage manager configuration file (rsm.cfg). You can choose to leave the user ID and password fields blank. If you do not specify a user ID or password, DB2 OLAP Server will attempt to log on to the relational database using the ID and password you used to log on to your workstation. If this user ID does not have access to the relational database, you will be denied access to the relational database.

DB2 OLAP Server Components and Add-ons

Components of DB2 OLAP Server version 7.1:

• Documentation
• Information Catalog Manager
• Client components:
  • Hyperion Essbase Server
  • The ESSCMD command line interface
  • Multidimensional Storage Manager
  • IBM's Relational Storage Manager
  • Application Manager
  • Spreadsheet Add-ins
  • Integration Server Desktop
• Server components:
  • DB2 OLAP Server
  • Sample applications
• Add-on components, that you can purchase:
  • DB2 OLAP Integration Server, including the Administration Manager
  • ODBC drivers for the DB2 OLAP Integration Server
  • SQL Interface, including ODBC drivers
  • API
  • Currency Conversion
  • Extended Spreadsheet Toolkit
  • Web Gateway
  • Objects
  • Allocations Manager
  • Partitioning

Installation Steps

To install and set up DB2 OLAP Server on Windows:

1. On a server, insert the CD-ROM into the CD-ROM drive to display the installation launchpad. If the launchpad does not appear, you can run setup.exe from the root directory.
2. Select Install from the launchpad. To cancel installation at any time, click Cancel. To display Help at any time, press F1.
3. When prompted, select the edition of DB2 OLAP Server that you purchased.
4. When prompted, select the optional components that you purchased. For a list of the optional components. See "DB2 OLAP Server Components and Add-ons".
5. Recommendation. If you want to install DB2 OLAP Server and Information Catalog Manager on the same system, we recommend that you install both products at the same time.
6. Provide the requested information on the remaining installation windows.
7. Optional. When installation is complete, check your Windows environment variables. See Manually Updating Environment Variables.
8. Restart your server.
9. Optional. Install DB2 OLAP Integration Server add-on. See "Installing DB2 OLAP Integration Server".
10. Optional. Install the SQL Interface. The SQL Interface includes the ODBC drivers. See "Loading and Configuring ODBC for the SQL Interface".
11. Optional. Install any additional add-on components.
12. If you installed the sample applications, use the Application Manager to load data into them. See the Application Manager online help and Essbase documentation.

The DB2 OLAP Server installation program, performs the following actions:

• Copies the DB2 OLAP Server files to the c:\program files\essbase\bin directory (or another directory that you specify) on your hard disk. The installation program creates the directories, if they don't exist. The directory structure is:

  ESSBASE
    BIN
    APP   
  

  The BIN subdirectory contains DB2 OLAP Server software.

  The APP subdirectory contains a subdirectory for each DB2 OLAP Server application that you create. An activity log file, which tracks all user requests made to the application or to databases within the application, is stored in the top directory for each application.

• Installs communication protocol support.
• Updates the Windows registry and environment variables. Users must remove any outdated entries.
• Ensures that server and client components are installed to the same root Essbase directory on your Windows workstation, and ensures that the ARBORPATH environment variable points to the same directory.