DB2 OLAP Server Installation 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

On Windows, you can place the OLAP server component in a startup folder so it will start automatically when Windows boots. You can also specify the server password, to avoid having to type it each time the OLAP Server starts.

To automate the OLAP server startup on Windows platforms:

1. To automate the OLAP Server startup on Windows platforms:
   • On Windows NT, select Start > Settings > Taskbar Start Menu Programs tab.
   • On Windows 2000, select Start > Settings > Taskbar & Start Menu Advanced tab.
2. Click Add and specify the location of the Essbase Agent program file, essbase.exe.

   If you installed Essbase to the default directory, this is c:\ibm\db2olap\bin\essbase.exe. If you want the DB2 OLAP Server system password to be automatically entered each time DB2 OLAP Server starts, type the password after essbase.exe on the command line. For example:

   c:\ibm\db2olap\bin\essbase.exe password
   

   where password is your DB2 OLAP Server system password.

3. Click Next, and then double-click the StartUp or Startup folder.
4. Type Essbase, or your server name, and click Finish.

Automating application startup

You can automatically start up an application or database. When the OLAP server is started, DB2 OLAP Server starts any application or database that is defined with an automatic startup setting. You define startup settings in Essbase Application Manager (Application Settings dialog box and Database Settings dialog box) or in Essbase Administration Services (Application Properties window and Database Properties window).

Stopping DB2 OLAP Server

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

• For DB2 OLAP Server, 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 Database Administrator's Guide, and the ESSCMD online help for more information.