Starting the Analytic 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. If this is a first-time installation, DB2 OLAP Server prompts you 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 a client to the server.
    System password
    This password is required whenever you start DB2 OLAP Server. It is also required to gain access to the server from clients 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.

    You are asked to confirm your choices. Type 1 to verify your entries or 2 to retype them. When you enter Y, the information will be saved. At subsequent logins, you will be prompted for the system password only.

  3. If this is not a first-time installation, DB2 OLAP Server prompts you for the system password that you specified when you first ran DB2 OLAP Server.

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

     Waiting for Client Requests. . .

You can now use the Agent window to perform high-level supervisor operations. For a list of available Agent commands, see Using agent commands.

After you start the Agent, all Agent activities are recorded in the log (essbase.log), which is stored in the ARBORPATH directory. After you start individual applications, application and database activities are recorded in an application log ( appname.log), which is stored in the application directory (ARBORPATH\app\appname). For more information, see "Using Analytic Services Logs" in the Database Administrator's Guide.

For more information about starting and stopping Analytic Server, see "Running Analytic Servers, Applications, and Databases" in the Database Administrator's Guide.

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. Find the Windows Start Menu customization controls.

    For example, on Windows 2000, select Start > Settings > Taskbar & Start Menu Advanced tab.

  2. Click Add and specify the location of the Agent program file, essbase.exe.

    If you installed 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 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: