Filter
Top Products
Using command-line switches
36
When a database server is running with multiple databases, the checkpoint time
specified by the first database started will be used unless overridden by this
switch. If a value of 0 is entered, the default value of 60 minutes is used.
Recovery time
The -gr parameter lets you set the maximum number of minutes that the
database server will take to recover from system failure. When a database
server is running with multiple databases, the recovery time specified by the
first database started will be used unless overridden by this switch.
Other performance-related switches
Several switches help you tune network performance. They include -gb
(database process priority on Windows NT), and -p (maximum packet size).
Controlling permissions from the command line
Some command-line options control the permissions required to carry out
certain global operations.
Starting and stopping
databases
The -gd option allows you to limit the users who can start a database on a
running server to those with a certain level of permission in the database to
which they are already connected:
•
DBA (the default) —Only the DBA can start an extra database.
•
ALL—Any user can start and stop databases.
•
NONE—No one can start or stop a database on a running server.
Sybase recommends that only the DBA be allowed to start and stop production
databases.
Note If you do not set -gd ALL when you start the server, only the DBA can
start additional databases on that server. This means that users cannot connect
to databases that are not already started, either at the same time as the server,
or since then by the DBA.
Creating and deleting
databases
The -gu option allows you to limit the users who can stop the server to users
with a certain level of permission in the database to which they are connected.
•
DBA—Only the DBA can create and drop databases.
•
ALL (default)—Any user can create and drop databases.
•
NONE—No user can create or drop a database.