Running Sybase IQ as a Windows service lets you start a server automatically whenever the machine is booted and run in the background as long as Windows is running.
Click Start, point to Programs | Sybase | Sybase IQ 15.0 | Sybase IQ Service Manager.
Choose Create a New Service.
Assign a name to the new service.
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.
Click Apply.
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.
If you run the database server as a Windows service, you can set the Software\Sybase\Adaptive Server Anywhere\11.0 registry entry to suppress event log entries.
To control event log entries, set the EventLogMask key, which is of type REG_DWORD. The value is a bit mask containing the internal bit values for the different types of event messages:
errors EVENTLOG_ERROR_TYPE 0x0001 warnings EVENTLOG_WARNING_TYPE 0x0002 information EVENTLOG_INFORMATION_TYPE 0x0004
If the EventLogMask, for example, is set to zero, no messages appear at all. Setting EventLogMask to 1 surpresses informational and warning messages, but logs all errors messages. The default setting (no entry present) logs all message types to appear.
You must assign Administrator privileges to a Sybase IQ service when raw device access is required.
Granting Administrator privilege to the Sybase
IQ service
Click Start, point to Settings, choose Control Panel | Administrative Tools | Services.
Right-click the Sybase IQ service, choose Properties.
On the Properties sheet, choose Automatic as the Startup Type.
Click the Log On tab, then click This account.
Assign the account to a user with Administrative privileges. In the account box, type the administrator’s user ID, then type and confirm the user’s password in the appropriate text boxes.
Click OK to close the Property sheet.
Click Close to close the Services console.
