Starts an Adaptive Server or a Backup Server. startserver is located in $SYBASE/ASE-12_5/bin.
This utility is not available for Windows NT.
startserver [[-f runserverfile] [-m]] ...
specifies the relative path name of a runserver file, which is used as a reference each time you start an Adaptive Server or Backup Server. By default, the runserver file is in the current directory and is named RUN_servername. If you start a second Adaptive Server on the same machine, startserver creates a new runserver file named RUN_servername.
starts Adaptive Server in single-user mode, allowing only one System Administrator to log in, and turns the allow updates to system tables configuration parameter on. Use this mode to restore the master database. The System Administrator can use the dbo use only parameter of sp_dboption for system administration activities that require more than one process, such as bulk copying or using the data dictionary. startserver normally starts up only one server per node.
The -m parameter creates an m_RUNSERVER file and overwrites any existing m_RUNSERVER file.
Starts an Adaptive Server named SYBASE from the runserver file named RUN_servername in the current directory:
startserver
Starts an Adaptive Server named MYSERVER and a Backup Server named SYB_BACKUP:
startserver -f RUN_MYSERVER -f RUN_SYB_BACKUP
Starts only the Backup Server SYB_BACKUP:
startserver -f RUN_SYB_BACKUP
startserver uses the information in the runserver file to start an Adaptive Server or Backup Server. The master device must be writable by the user who starts Adaptive Server.
The startserver command creates the Adaptive Server error log file (named errorlog) in the directory where the server is started, and adds this information as part of the -e parameter in the Adaptive Server executable line in the runserver file. If a second Adaptive Server is started on the same machine, a new error log named errorlog_servername is created; this information is added to that server’s runserver file. The user must have execute permission on the specified runserver file.
You can start multiple servers by specifying more than one runserver file, as shown in example 2. You can specify -m after each -f runserverfile.
Adaptive Server derives its running environment from values in the config file. Run sp_configure or edit the config file to see or change configuration parameters.
To ensure the integrity of your Adaptive Server, it is important that you apply appropriate operating-system protections to the startserver executable and the runserver file.
The runserver file, which is created by srvbuild during installation, contains the dataserver command to start Adaptive Server or the backupserver command to start Backup Server. By default, the runserver file is in the current directory and is named RUN_servername. You can edit the runserver file to correct the options and parameters for the commands. The following example shows two sample runserver files.
Runserver file for server MYSERVER:
#!/bin/sh # # Adaptive Server Information: # name: /MYSERVER # master device: /remote/Masters/myserver_dat # master device size: 10752 # errorlog: /remote/serverdev/install/errorlog # interfaces: /remote/serverdev/interfaces # # /remote/serverdev/bin/dataserver -d/remote/Masters/myserver_dat \ -sMYSERVER -e/remote/serverdev/install/MYSERVER_errorlog \ -i/remote/serverdev &
Runserver file for backup server SYB_BACKUP:
#!/bin/sh # # Backup Server Information: # name: SYB_BACKUP # errorlog: /remote/serverdev/install/backup.log # interfaces: /remote/serverdev/interfaces # location of multibuf: /remote/serverdev/bin/sybmultbuf # language: us_english # character set: iso_1 # tape configuration file: /remote/serverdev/backup_tape.cfg # # /remote/serverdev/bin/backupserver -SSYB_BACKUP \ -e/remote/serverdev/install/backup.log \ -I/remote/serverdev/interfaces \ -M/remote/serverdev/bin/sybmultbuf -Lus_english -Jiso_1 \ -c/remote/serverdev/backup_tape.cfg
Commands – disk mirror, disk remirror, disk unmirror
Utilities – backupserver, dataserver
