Sybase Adaptive Server Anywhere - Page 52

The database server
34
If you attempt to modify the database, for example with an INSERT or
DELETE statement, a SQLSTATE_READ_ONLY_DATABASE error is
returned.
Databases that require recovery cannot be started in read-only mode. For
example, database files created using an online backup cannot be started in
read-only mode if there were any open transactions when the backup was
started, since these transactions would require recovery when the backup
copy is started.
To open two databases in read-only mode
dbeng7 -r database1.db database2.db
To open only the first of two databases in read-only mode.
dbeng7 database1.db -r database2.db
–s command-line option
Set the user ID for syslog messages.
[ dbsrv7 | dbeng7 ] -s { none | user | login-id ...}
UNIX
Sets the system user ID used in messages to the
syslog facility. The default
is user, which uses the user ID for the database server process. A value of
none prevents any syslog messages from being logged.
–sb command-line option
Specify how the server reacts to broadcasts.
[ dbsrv7 | dbeng7 ] -sb { 0 | 1}
TCP/IP
-sb 0 causes the server not to start up any TCP/UDP broadcast listeners. In
addition to forcing clients to use the DoBroadcast=NONE and HOST=
options to connect to the server, this option causes the server to be unlisted
when using dblocate.
-sb 1 causes the server to not respond to broadcasts from dblocate, while
leaving connection logic unaffected. You can connect to the server by
specifying LINKS=tcpip and ENG=<name>.
Example
Function
Syntax
Applies to
Description
Function
Syntax
Applies to
Description