Installing DB2 OLAP Server

Make sure you consider the following issues about how DB2 OLAP Server is installed in version 8.2.

Upgrading from version 8.1 to version 8.2 on the same Windows computer
If you have V8.1 of DB2 OLAP Server on your Windows computer, and you want to install V8.2 on that computer, it is recommended that you make a copy of your existing OLAP directory. Then install V8.2 (in a directory whose name does not contain blanks, underscores, dashes, or other special characters) and import your application files and data into the new version.

You can install V8.2 on top of V8.1, and your existing OLAP applications will be available to the new or upgraded version. But when you install a new version to the same directory, you should take the following steps as a precaution:

Make sure you aware of all migration issues before starting the installation. See Upgrading and migrating from earlier versions.

Upgrading from version 7.1 to version 8.2 on the same Windows computer
If you want to install V8.2 and you currently have V7.1 installed, you must first migrate to V8.1 before installing and migrating to V8.2. For instructions, see the V8.1 edition of the DB2 OLAP Server Installation Guide, available from our Web site:
http://www.ibm.com/software/data/db2/db2olap/library.html
Do not install in a directory whose name includes blanks
If you install in a directory whose name contains blanks, some functions might fail. Additionally, other functions might produce unpredictable results if the name of the installation directory contains underscores, dashes, or other special characters.
If you have already installed DB2 OLAP Server Administration Services V8.2
If you have installed DB2 OLAP Server Administration Services V8.2, make sure you reboot your computer before starting the installation of DB2 OLAP Server or DB2 OLAP Integration Server.
Do not reinstall V8.1 on top of V8.2
After you install V8.2, if for any reason you want to reinstall V8.1 on the same machine, do not install it in the same directory. For example, if you installed V8.2 in c:\ibm\db2olap, you must install 8.1 in another directory.

Shut down Windows services and applications before installation

Before installing on Windows, if you have Windows services set up for a previous installation of DB2 OLAP Server and DB2 OLAP Integration Server, stop them and disable them from starting again the next time the system is rebooted.

For example, on Windows 2000, to stop and disable the Windows services:

  1. Select Start > Programs > Administrative Tools > Services.
  2. In the Services window, double click IBM DB2 OLAP Server to display the Properties window.
  3. From the Startup type list, select Disabled.
  4. Click Stop.
  5. Click OK.
  6. Repeat this process for IBM DB2 OLAP Integration Server if it is installed.

Additionally, shut down all Windows applications before starting the installation.

Installation steps

To install and set up DB2 OLAP Server on Windows:

  1. Stop the Windows services for DB2 OLAP Server and DB2 OLAP Integration Server, if they are running.
  2. Stop all other Windows programs, if any are running.
  3. Insert the DB2 OLAP Server CD into the CD-ROM drive to start the installation program. If the program does not start automatically, you can run setup.exe from the root directory.
  4. Click Next on the Setup window. To cancel installation at any time, click Cancel. To display Help at any time, press F1.
  5. Press Accept to accept the Software License Agreement.
  6. On the Select Installation Options window, click either Server or Client or both, and click Next.
  7. On the Select Locale screen, select the language you want and click Next.
  8. When prompted, select the edition of DB2 OLAP Server that you purchased (Standard, Personal, or Developer), and click Next.
  9. On the Select Options Purchased screen, select the optional components that you purchased. This panel might be filled in if you are migrating from a previous OLAP Server release and the previous license information can be read. If you purchased the Standard Edition or Developer's Edition, you are prompted to enter the number of concurrent licenses you purchased. Then click Next.
  10. In the Choose Destination Location panel, enter the drive and directory where you would like to install DB2 OLAP Server, and click Next. IBM strongly recommends that you install DB2 OLAP Server and its features into a new separate directory; do not install into directory in which a product other than DB2 OLAP Server and its features has been installed. Additionally, do not install in a directory whose name includes blanks.
  11. Select the type of installation that you want: Typical or Custom.
  12. If you selected a Custom installation, the Select Components window displays. Check the components you want and click Next.
  13. Enter a name for the folder into which DB2 OLAP Server is installed, or accept the default. Click Next.
  14. Click Next to start copying the files to your computer. When the installation program has finished, restart your computer.

Security

The essbase.sec file stores information about users, passwords for native security, groups, privileges, and applications. Each time that you successfully start the server component, essbase.exe, DB2 OLAP Server makes a backup copy of the security file (essbase.bak). If you attempt to start the Agent and a password prompt is not displayed or your password is rejected, no backup file is created. You can restore from the last successful startup by copying essbase.bak to essbase.sec. Both files are in the bin directory where you installed the server component.