Creating a New Windows Service

Running Sybase IQ as a Windows service lets you to start your server automatically whenever you restart your computer. Windows services runs in the background as long as Windows is running.

  1. Click Start > Programs > Sybase > Sybase IQ > Sybase IQ Service Manager.
  2. Choose Create a New Service.
  3. Name the new service.
  4. Add the appropriate start-up parameters.

    Include the full path to the database file. The server cannot start without a valid database path name. For an example of start-up parameters, see %ALLUSERSPROFILE%\SybaseIQ\demo\iqdemo.cfg.

  5. Click Apply.
  6. Restart Windows.

    Because Window service manager reads environmental variables only at system startup, you must restart Windows after you configure Sybase IQ as a Windows service.

Note:

  • Copy any input files that you use to load your databases into the directory where the service starts, not where the database files are located. On most systems, the services start-up defaults to the %SYSTEMROOT%\system32 directory.

  • To use Sybase IQ as a Windows service when raw device access is required, you must grant the service Administrator privileges.

  • Use Modify an Existing Service or Delete an Existing Service in the Add Service utility to change or delete Sybase IQ services.

Parent topic: Running Sybase IQ as a Windows Service
Related tasks
Suppressing Windows Event Log Messages
Granting Administrator Privilege to the Sybase IQ Service