This section tells you how to start SAP Sybase IQ and use the demo database to test your
installation.
Demo Database
Many of the examples throughout the documentation use the demo database (iqdemo.db) as a data source. The demo database is installed as part of the SAP Sybase IQ Server Suite and resides on the server. Client access is provided by tools installed as part of the SAP Sybase IQ Client Suite.
Running SAP Sybase IQ Server
Use the startup utility, start_iq, to start your server. start_iq is a command line utility that runs on all platforms and ensures that all required parameters are set correctly.
Stopping Servers
SERVER OPERATOR system privilege is the default permission level required to stop a server, but you can use the -gk startup option to change the default to ALL or NONE. Setting the permission level to ALL lets all users stop the server; setting the permission level to NONE means that no one can stop the server. In a production environment, only the Server Operator should be allowed to stop the database server.
Running Interactive SQL
Interactive SQL is a utility that ships with SAP Sybase IQ that lets you execute SQL statements, build scripts, and display database data.