OLAP Setup and User's Guide

Starting DB2 OLAP Server on Windows

DB2 OLAP Server is automatically started as a service on your workstation. If you should need to start it manually by using the command line, follow these steps:

1. At the command prompt, enter:

   Essbase
   

   If an error occurs during startup, check your path and environment settings. If your path and environment settings are correct, ensure that the appropriate communications protocol is installed and running on your Windows workstation.

2. The first time you use DB2 OLAP Server, you are prompted to enter the following information:

   Company name

   The company name that you want to use in your server license registration.

   Your name

   The name to use as the DB2 OLAP Server supervisor ID. Use this name for your initial login from the Application Manager.

   System password

   This password is required whenever you start DB2 OLAP Server. It is also required to gain access to the server from the Application Manager when you use the supervisor account.

   Verification of the correctness of the information you entered

   Enter Y to verify the entries, or N to retype your entries.

   When you enter Y, the information will be saved. At subsequent logins, you will be prompted for the system password only.

   DB2 OLAP Server displays this message when the server is started and ready for use:

        Waiting for Client Requests. . .
   

Automating Server Startup

DB2 OLAP Server is started automatically. The following information is provided in case you should ever need to manually setup the server to start automatically. You can automate the server startup by using either the command line, or Windows Services.

To use the command line:

1. Create a DB2 OLAP Server icon on the Windows desktop in the Startup folder. See your Windows documentation for information about creating icons.
2. Define the Command Line option as follows:

   c:\essbase\bin\essbase.exe
   

   where c:\essbase\bin is the directory you used to install DB2 OLAP Server/

   You can also supply the DB2 OLAP Server system password if you do not want to enter it each time you start the server. Specify the password after essbase.exe in the Command Line option of the icon definition. For example:

   c:\essbase\bin\essbase.exe password

3. Type the title of the icon in the Description field.

To use Windows Services:

1. Click Start --> Settings --> Control Panel --> Services
2. On the Services window, select the Essbase server.
3. Click Start.

Automating Application Startup

You can start applications automatically. After DB2 OLAP Server is started, any application or database that is defined with an automatic startup setting is started.

You define startup settings in the Application Manager using the Application Settings window and Database Settings window. See the Application Manager online help for more information.

Stopping DB2 OLAP Server and Starter Kit

To stop the server from any workstation that is connected to it, use one of the following two methods:

• For DB2 OLAP Server and OLAP Starter Kit, you can use Windows Services:
  1. Click Start --> Settings --> Control Panel --> Services
  2. On the Services window, select the Essbase server.
  3. Click Stop.
• For DB2 OLAP Server, you can use the SHUTDOWNSERVER command in ESSCMD. See the Hyperion Essbase Database Administrator's Guide, Volumes 1 and 2, and the ESSCMD online help for more information.