Sybase 12.4.2 Starting the asiqdemo database, From a command line, type the following command

CHAPTER 2 Running Adaptive Server IQ

Permission limitations

Stopping a database

The -gdserver command-line option determines the permission level required to start databases. By default, this option is set to DBA, so that only users with database administrator privileges can start IQ databases. However, you can also set this option to ALL or NONE. ALL means that all users can start a database. NONE means that no users, including the DBA, can start a database.

You can stop a database in the following ways:

•Disconnect from a database started by a connection string. The database stops automatically when the last user disconnects from it, unless you explicitly set the AUTOSTOP connection parameter to NO.

•From DBISQL or Embedded SQL, use the STOP DATABASE statement. For information, see the Adaptive Server IQ Reference Manual.

Starting the asiqdemo database

You can start the server and the asiqdemo database easily, using the configuration file that Adaptive Server IQ provides. This configuration file, called asiqdemo.cfg, contains all the parameters necessary to start the sample database.

❖To start the server and asiqdemo database on UNIX operating systems:

• From a command line, type the following command:

%cd $ASDIR/demo

%start_asiq @asiqdemo.cfg asiqdemo

These commands use the configuration file asiqdemo.cfg that is created automatically at installation. You can edit this file to change the parameters you use to start the sample database. For example, the server name in this file is hostname_asiqdemo. You can rename the server to a unique name of your choice, like janed_server.

❖To start the server and asiqdemo database on a Windows NT system:

•Click Start on the Taskbar, and select Programs →Adaptive Server IQ 12.0→ Sample Database.

Behind the scenes The command that executes when you perform these steps is:

path\win32\asiqsrv12 @demo\asiqdemo.cfg demo\asiqdemo.db

47