Running DB2 OLAP Server and DB2 OLAP Integration Server as a Windows service

The server components of DB2 OLAP Server and DB2 OLAP Integration Server can run as Windows services. Running these products as services lets you start and stop them from the Windows Control Panel. When running as automatic services, the Analytic and Integration Servers start in the background when you start Windows.

The Windows Task Manager does not enable you to terminate any process started as a service. If the servers are started as a service, and if it or the server freezes, you must shut down the server computer to stop the service.

Installing the Analytic Server and Integration Server as Windows services

To install the Analytic Server and Integration Server or both as services that start automatically when you start Windows, open a command prompt and type one or both of the following commands:

For DB2 OLAP Server
essbase.exe -service install
For DB2 OLAP Integration Server
olapisvc -i

A message is displayed in the command prompt window that the service is installed. The Agent is now listed as essbase service in the Services dialog box. The Agent is now set to start automatically when you start Windows.

To run the Analytic Server and Integration Server as Windows services, the operating system needs to know where servers is located. Before running the servers as an automatic service, make sure that %ARBORPATH%\BIN has been added to the system-wide path variable.

Verifying that the services are running

To verify that the Analytic Server and Integration Server running as automatic Windows services after you reboot:

  1. Reboot the Windows server.
  2. Select Start --> Settings --> Control Panel.
  3. Open the Services dialog box and make sure that IBM DB2 OLAP Server and IBM DB2 OLAP Integration Server are in the list of services, that the Startup Type is Automatic, and that the Status is Started.

Stopping the services

The servers are listed as IBM DB2 OLAP Server and IBM DB2 OLAP Integration Server in the Windows Services dialog box.

To stop the services, select IBM DB2 OLAP Server, right click, and select stop. Repeat the process with IBM DB2 OLAP Integration Server.

Stopping the services can take some time, depending on how many application servers are running. The time that it takes is the same amount it would take to stop the servers if they were running from the command line or as background processes.

Removing the services

To remove the services:

  1. Stop the services.
  2. From a command prompt, type one or both of the following commands:
    For DB2 OLAP Server
    essbase.exe -service remove
    For DB2 OLAP Integration Server
    olapisvc -u 

A message is displayed in the command prompt window that the services are removed.

Removing a service only removes it from the list of Windows registered services. It does not uninstall DB2 OLAP Server or DB2 OLAP Integration Server.