Sybase SQL Anywhere server management
Upon startup, the Sybase SQL Anywhere server uses the SQL Anywhere service to set the server parameters in the server.conf file. Then, the service starts the databases that are indicated in the databases.conf file.
To start and stop the Sybase SQL Anywhere daemon on UNIX, use one of the following methods:
Select NB_dbsrv in the Activity Monitor in the NetBackup Administration Console.
From the command line:
/usr/openv/netbackup/bin/bp.kill_all | bp.start_all
The Sybase SQL Anywhere daemon is included in the stop command or the start command, which starts and stops all NetBackup daemons.
/usr/openv/db/bin/nbdbms_start_server ndbms_start_server starts the SQL Anywhere server if no option is specified.
/usr/openv/db/bin/nbdbms_start_server -stop -f
Stops the server; -f forces a shutdown with active connections.
/usr/openv/db/bin/nbdbms_start_server -stat
The -stat option tells whether the server is up or down:
SQL Anywhere Server Ping Utility Version 11.0.1.2044 Ping server successful.
/usr/openv/db/bin/nbdbms_start_server -h
Use -h to display usage information about the nbdbms_start_server.
Individual databases can be started or stopped, while the SQL Anywhere service continues. To do so, use the NetBackup Database Administration utility or the following commands:
nbdb_admin [-start | -stop]
Starts or stops NBDB without shutting down the SQL Anywhere server.
To see whether the database is up, enter nbdb_ping.
nbdb_admin [-start | -stop BMRDB]
Starts or stops BMRDB without shutting down the SQL Anywhere server.
To see whether the BMRDB database is up, enter nbdb_ping -dbn BMRDB.