Configuring the servers

This section describes how to configure a basic Adaptive, Backup, Monitor, XP Server. For information on advanced configuration topics, localization, and enabling additional functionality, see Configuring Adaptive Server Enterprise.

The Studio Installer sets all the necessary environment variables to perform the configuration of Sybase servers. If your environment gets corrupted, the Studio Installer generates script files that you can run to correct the environment after the installation. If you need to correct the environment, run the following scripts as the “root” user.

When you log in as “sybase” for the first time after installation, verify that the SYBASE environment variable is correctly set and that $SYBASE/$SYBASE_ASE/bin and $SYBASE/$SYBASE_OCS/bin are in your search path.

StepsConfiguring Adaptive Server

  1. The Studio Installer automatically begins the configuration process.

  2. Enter the Sybase directory for this configuration. By default the installation directory displays.

    Click Next.

  3. The Build or Upgrade Adaptive Server, Backup Server, and Monitor Server screen is displayed. From the drop-down list, select Build new servers.

    The srvbuild screen displays.

    Only the server types that were installed display on the srvbuild screen. For example, if you did not install Monitor Server, it does not appear on the srvbuild screen.

    Figure 4-1: Server selection screen

  4. Select, at a minimum, Adaptive Server. Click the check box to the left of the server name.

    You can choose all server types at once or any combination of server types.

    srvbuild consecutively displays the attributes screen for each server you choose, in the order listed on the screen. For example, if you chose Adaptive Server, Backup Server, and XP Server, but did not select Monitor Server, the attribute screen for Adaptive Server appears first. When you finish choosing the attributes for Adaptive Server, and click OK, the Backup Server attribute screen appears. When you are finished with that screen, the XP Server attribute screen appears. The Monitor Server attribute screen does not appear because you did not check the box for installing that product.

  5. Click OK.

  6. Provide a name for each server you install.

    NoteDo not change the name of your Backup Server.

    srvbuild provides a default server name using the name of the machine you are installing on. You can change the default name.

    Server naming conventions are as follows:

    All server names are stored in the interfaces file by srvbuild and are used by clients and other servers to establish communication.

  7. Click OK.

  8. From the drop-down list at the top of the Adaptive Server attribute screen, select the logical page size for this installation of Adaptive Server. All pages in this installation will have the logical page size you specify here. If this installation of Adaptive Server has a logical page size of 2K, and you decide that you want a logical page size of, for example, 8K, you must create a separate installation of Adaptive Server with the 8K page size.

    The size of the master database is automatically allocated to accommodate the logical page size. You can increase the master database size if you want.

    If you are adding additional server languages for localization, you need an additional 2–7MB of space, per language in the master database. See Chapter 2, “Installation Requirements” for language module sizes.

    For production systems, Sybase recommends that you use a disk partition instead of an operating system file, for the master device. This example specifies a raw partition:

    /dev/rdsk/disk_partition
    

    If you entered a disk partition as the master device, only the master device can occupy the disk partition. Set the size of the partition to the recommended 30MB.

    If you entered an operating system file for the location of the master database, you can provide a size that is less than the default size, but the minimum allowable size is 25MB. The maximum size is the size of the file system, up to 2GB.

  9. Provide an operating system file for the master and sybsystemprocs device paths:

    /op_system_dir/master.dat
    /op_system_dir/sybsystemprocs.dat 
    

    where op_system_dir is the name of the operating system directory you are going to use.

    Notesysprocsdev is the default system name for this device. However, it is frequently referred to as the sybsystemprocs device, as in the Adaptive Server attribute screen, since it stores the sybsystemprocs database.

    Sybase recommends that the sybsystemprocs device be located on a device separate from the master device. The sybsystemprocs database usually increases in size from version to version.

  10. Provide an error log path name.

    The default is:

    $SYBASE/$SYBASE_ASE/install/errorlog

  11. For Directory Services, specify the transport type, host name, and port number.

    These entities define how servers and clients find and communicate with each other on the network. srvbuild adds this entry to the interfaces file during the installation process.

    NoteIf you want to use lightweight directory services for server connections instead of the interfaces file, see Configuring Adaptive Server Enterprise for your platform.

  12. Click Edit Advanced Adaptive Server Attributes if you want to:

  13. To create the server, click Build Server. To continue configuring other Sybase servers, select OK.

    srvbuild displays a Status Output screen that shows the status of the various installation tasks as they execute.

StepsConfiguring Backup Server

This procedure assumes that you have completed the “Pre-installation tasks”.

  1. The related Backup Server name is provided by default. It is the same name as the Adaptive Server with the extension “_back”. This is the name of the Adaptive Server that will use this Backup Server.

  2. Provide the Sybase System Administrator (SA) user name for the related Adaptive Server, or accept the default value.

    If the related Adaptive Server is created in the same srvbuild session as Backup Server, this field does not appear.

  3. Provide the Adaptive Server SA password. This is the password for the related Adaptive Server.

    If the related Adaptive Server is created in the same srvbuild session as Backup Server, this field does not appear.

  4. Provide an error log path for Backup Server.

  5. Provide a location for the tape configuration file.

    Backup Server reads this file when a dump command is issued, to determine the device type and characteristics of the dump device specified in the dump command. Having access to this information speeds up the dump (recovery) process.

  6. Specify the language you want Backup Server to use for its error messages. The default language is U.S. English.

    The language available depends on which language modules were installed on your system. By default, all character sets are copied from the CD when performing a standard or full install.

  7. Specify the character set you want Backup Server to use.

    The default character set is iso_1.

    Other options are:

  8. Specify the maximum number of network connections.

    This option specifies the total number of network connections available if you are backing up or restoring a database over the network to a remote Backup Server.

    This option is not necessary if you are backing up to the default Backup Server, which is local. Set to 0.

  9. Specify the maximum number of server connections. You can accept the default or change it.

    This option specifies the number of server connections to Backup Server. Backup Server requires at least:

    Allow a maximum of three times the number of expected concurrent dump and load sessions.

  10. For the Directory Services, specify the transport type, host name, and port number.

    These entities comprise the interfaces file entry. This entry defines how Backup Server and Adaptive Server find and communicate with each other on the network. srvbuild adds this entry to the interfaces file during the installation process.

  11. Click OK.

StepsConfiguring Monitor Server

This procedure assumes that you have completed the “Pre-installation tasks”.

  1. If you selected Monitor Server to be installed, the Monitor Server attribute screen displays.

  2. Provide the related Adaptive Server name. This field does not appear if the related Adaptive Server is created in the same srvbuild session as Monitor Server.

    This is the name of the Adaptive Server that Monitor Server will be monitoring.

  3. Specify the Sybase System Administrator (SA) user name. This field does not appear if the related Adaptive Server is created in the same srvbuild session as Monitor Server.

    This option is required unless the USER environment variable is set.

    This name specifies the Monitor Server superuser. It must be a valid login account for the Adaptive Server to be monitored. For production systems, Sybase recommends that you use the “sa” or “sybase” user account as the Monitor Server superuser.

    Monitor Server uses the superuser account to connect to Adaptive Server to run special stored procedures and to verify shutdown requests that can be performed only by the superuser.

  4. Provide the Adaptive Server SA password. This is the password of the Monitor Server superuser. This field does not appear if the related Adaptive Server is created in the same srvbuild session as Monitor Server.

    If you omit the password, Monitor Server prompts for a password during start-up.

  5. Determine the maximum number of connections allowed to Monitor Server. Valid values are 1–20.

    A connection to Monitor Server can be any of:

    For example, if a user starts a Historical Server recording session, and another user opens the Performance Summary Monitor in Sybase Central, two connections to Monitor Server are used. If Monitor Server is configured for five connections, there are only three more connections available.

  6. Specify the error log path.

    This is the path name of the Monitor Server log file, where informational and error messages are logged.

    The default location is the directory from which Monitor Server is started and the error log name is servername_mon.log, where servername is the name of the server.

  7. Specify the path of the configuration file.

    This is the path name of the Monitor Server configuration file. A default configuration file is not provided. This file is optional, but if specified, the values in the configuration file override the default runtime parameters that are otherwise used by Monitor Server.

  8. Specify the shared memory directory, where the servername.krg shared memory file is located and servername is the name of the Adaptive Server.

    If you omit this parameter, Monitor Server looks for the shared memory in the $SYBASE/$SYBASE_ASE directory.

    If you did not change the default location while configuring the Adaptive Server, the default value is correct. Otherwise, use the value you specified for the server.

  9. For the Directory Services, specify the transport type, host name, and port number. These entities comprise the interfaces file entry. This entry enables Monitor Server and Adaptive Server to find and communicate with each other on the network. srvbuild adds this entry to the interfaces file during the installation process.

  10. Click OK.

StepsConfiguring XP Server

If you selected XP Server to be installed, the XP Server Attribute Editor screen displays.

  1. Provide the related Adaptive Server name, which is the name of the Adaptive Server that will be using XP Server. If the related Adaptive Server is created in the same srvbuild session as XP Server, this field does not appear.

    NoteThe XP server name must be in all capital letters, and must follow the format ASE-NAME_XP.

  2. Provide the Sybase System Administrator (SA) user name for the related Adaptive Server, or accept the default value.

    If the related Adaptive Server is created in the same srvbuild session as XP Server, this field does not appear.

  3. Provide the related Adaptive Server SA password.

    If the related Adaptive Server is created in the same srvbuild session as XP Server, this field does not appear.

  4. For the Directory Services, accept the default values provided.

  5. Click Build Servers.

    srvbuild displays a Status Output screen that shows the status of the various installation tasks as they execute.

  6. When the installation is complete, the Status Output screen displays “Done”. Click Exit to return to the main window. Click Exit, again.