Filter
Top Products
CHAPTER 2 Running Adaptive Server IQ
47
Permission limitations
The -gd server 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.
Stopping 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