Configuring the servers

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

Before configuring this installation of Sybase Adaptive Enterprise Server, Sybase recommends that you install a Sybase DBA account and correct product permissions. This post configuration can be performed at any time by running the sybinstall.sh shell script as root (uid=0).

${SYBASE}/install/sybinstall.sh'

StepsConfiguring Adaptive Server

  1. Log in as sybase.

  2. Start the configuration utility:

    $SYBASE/$SYBASE_ASE/bin/srvbuild
    

    The Adaptive Server Setup & Configuration screen is displayed. Select Configure a new server.

  3. The srvbuild screen displays.

    Only the server types that were installed display on the srvbuild screen. For example, if you did not install Full-Text Search, it does not appear on the srvbuild 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.

  5. Provide a name for each server you install.

    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.

  6. Click OK.

    Notesrvbuild 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, and so on.

  7. 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. The maximum size is the size of the file system, up to 2GB, the minimum is 25MB.

    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

  8. 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 release to release.

  9. For the sybsystemprocs device and database sizes, enter 100.

  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.

  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 creates the master.dat and systemprocs.dat files for you.

    srvbuild displays a warning regarding the use of an operating system file for the master and sybsystemprocs device paths. If this Adaptive Server is not intended for production use, you can ignore this warning.

StepsConfiguring Backup Server

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

  1. Provide the related Adaptive Server name, which is the Adaptive Server that will use this Backup Server.

    If the related Adaptive Server is created in the same srvbuild session as Backup Server, this field does not appear. The Adaptive Server you are creating is used as the related Adaptive 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 related Adaptive Server SA password.

    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. Tape backups are not supported. Leave this field blank.

  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”.

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

  1. Provide the related Adaptive Server name, which is the Adaptive Server that will be monitored by this Monitor Server.

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

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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 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.

  8. 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.

  9. Click OK.

StepsConfiguring XP Server

If you installed XP Server, 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.

The Adaptive Server and related products have been successfully installed, and minimally configured for use. See “Installing sample databases”, to begin experimenting with your servers, or see the System Administration Guidehttp://www.sybase.com/support/manuals for more advanced topics.

StepsConfiguring the Full Text Search engine

The following procedure assumes that you have completed the procedure in the section “Pre-installation tasks”. To continue installing FTS, complete the following procedure.

  1. Errorlog: The default is $SYBASE/$SYBASE_FTS/install/servername.log

  2. Collection directory: Accept the default, $SYBASE/SYBASE_FTS/collections

  3. Default Database: text_db

  4. Language: us_english

  5. Character set: iso_1

  6. Minimum number of sessions: 10

  7. Maximum number of sessions: 100

  8. For Directory Services, specify the transport type, host name, and port number. These entities comprise the interfaces file entry. This entry enables FTS 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.

  9. To create the server, click Build Server.

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

See Full-Text Search Specialty Data Store User’s Guide for information on the this feature.

StepsInstalling Sybase Central Java Edition

This section describes how to install and register the Sybase Central Java plug-in.

  1. Start Sybase Central. From the command line, enter:

    $ $SYBASE/sybcent32/scjview
    
  2. From the menu, select Tools | Plug-ins

    This launches the Sybase Central Plug-ins dialog box.

  3. Select Register

  4. Enter the full path to the plug-in, including the plug-in name. For example:

    opt/sybase-12.5/ASEP-1_0/ASEPlugin.jar
    

    where opt/sybase_12-5 is the Sybase installation directory.

  5. Select OK.

  6. Select Close. The Adaptive Server Enterprise icon should now appear in Sybase Central.