Running Sybase IQ as a Windows service automatically starts the server whenever the machine is restarted and run in the background as long as Windows is running.
Click Start | Programs | Sybase | Sybase IQ 15.2 | Sybase IQ Service Manager.
Choose Create a New Service.
Name 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.
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.
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.
Suppressing Windows event log messages
If you run the database server as a Windows service, you can set the Software\Sybase\Adaptive Server Anywhere\11.0.1 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 bitmask 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.
Granting Administrator privilege to the Sybase IQservice
You must assign Administrator privileges to a Sybase IQ service when raw device access is required.
Click Start | Settings | 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 enter and confirm the user’s password.
Click OK to close the Property sheet.
Click Close to close the Services console.
