OLAP Setup and User's Guide

Starting DB2 OLAP Server for AIX, Solaris Operating Environment, and HP-UX

Before you can access DB2 OLAP Server:

• Log off from the DB2 OLAP Server account that is pointed to be the environment variables, so that the updates to the environment variables take effect. Then log back on to that account or another account that has at least read/write/execute access to the DB2 OLAP Server directories.
• Ensure that the proper communications protocol is installed and running on your workstation.

You can start DB2 OLAP Server in the foreground or in the background.

Starting DB2 OLAP Server in the Foreground

To start DB2 OLAP Server in the foreground:

1. From the command prompt, type:

   $ARBORPATH/bin/ESSBASE
   

   Or, if your path already includes $ARBORPATH/bin, type:

   ESSBASE
   

   Tip: If you encounter any errors during startup, check your path and environment settings. If you still encounter problems after verifying your settings, ensure that the appropriate communications protocol is installed and running on your server.

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

   Company name

   The company name that will be added to 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

   Answer Y to verify the entries or N to retype your entries.

   After you verify the information, it will be saved. From then on, you will only be prompted for the system password.

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

        Waiting for Client Requests. . .
   

Starting DB2 OLAP Server in the Background

To start DB2 OLAP Server in the background, type:

ESSBASE password -b &

If you use Korn shell (ksh), and want to detach the server process (which lets the server continue to run after you log off), prefix the ESSBASE command with the nohup command. See your operating system documentation for more information.

It is recommended that you run DB2 OLAP Server in the foreground until your installation is running smoothly. This lets you see any error messages displayed by the server.

Stopping DB2 OLAP Server and OLAP Starter Kit

To stop DB2 OLAP Server when it is running in the foreground, either:

• Type EXIT.
• Use the SHUTDOWN SERVER command in ESSCMD.

To Stop DB2 OLAP Server when it is running in the background, use the SHUTDOWN SERVER command in ESSCMD.

To stop OLAP Starter Kit when it is running in the foreground, type EXIT.

To stop OLAP Starter Kit when it is running in the background, use the KILL command from another process.