Configuring New Servers with srvbuild

Use srvbuild to configure a new server with default or user-specified values for key configuration attributes.

Note: Use srvbuildres in non-GUI mode, to configure a new server using a resource file. See Utility Commands Reference in the Utility Guide.
  1. Source SYBASE.csh or SYBASE.sh file in $SYBASE to set up the environment variables.
  2. Run $SYBASE/$SYBASE_ASE/bin/srvbuild.
  3. Click the server types to configure. When you select each type, the server name is enabled where you can enter the server name. Click OK.

    The available server types depend on what you have installed in $SYBASE.

    The screen you see next depends on the server types you selected.
  4. On the SAP ASE type screen, select the:
    • SAP ASE Application type – based on how you plan to use the new server, choose:
      • MIXED – for both OLTP and DSS.
      • OLTP – for online transaction processing. This is generally used for a high rate of smaller, less complex transactions.
      • DSS – for decision-support systems. Generally, these systems have less update activity with large complex queries.
    • Server page size – depending on the SAP ASE application type, select:
      • 4K– for MIXED and OLTP
      • 8K– for DSS
    • Master device path
    • Master device size
    • Master database size
    • Sybsystemprocs device path
    • Sybsystemprocs device size
    • Sybsystemprocs database size
    • Error log
    • Transport type
    • Host name
    • Port number

    In the Edit Advance SAP ASE Attributes tab, enter:

    • SAP ASE configuration file
    • sybsystemdb device path
    • sybsystemdb device size
    • sybsystemdb database size
    • Share memory file directory
    • Default Backup Server
    • tempdb information – SAP ASE 15.0.3 ESD #1 and later create tempdb on a specified separate device. The default tempdb device and database size is 100MB. Specify these attributes for tempdb:
      • tempdb device path
      • tempdb device size
      • tempdb database size
    • Enable PCI in SAP ASE
      If you enable PCI in SAP ASE, also set:
      • sybpcidb device path
      • sybpcidb device size
      • sybpcidb database size
    • Optimize SAP ASE configuration values. After configuring a server, srvbuild prompts you for these values:
      • Available physical memory for SAP ASE
      • Available CPU for SAP ASE

      The default configuration may not optimally use all the resources available on the system. Input new values based on the system resource usage. If the value specified is larger than the available resource for allocation to the server, the optimization may fail, causing the server to not start. The current default input values for available physical memory and available CPU are 80% of the physical memory and CPU number.

    Note: The SAP ASE 15.0.3 and later installerThe installer from versions 15.0.3 and later allows you to tune basic configuration settings during installation, instead of as a postinstallation task. See the Installation Guide.
  5. To configure Backup Server, in the Backup Server configuration screen, select the:
    • Error log
    • Tape configuration file
    • Language
    • Character set
    • Maximum number of network connections
    • Maximum number of server connections
    • Transport type
    • Host name
    • Port number
  6. In the XP Server type screen, select:
    • Transport type
    • Host name
    • Port number
  7. To configure Job Scheduler specify:
    • sybmgmtdb device path
    • sybmgmtdb device size
    • sybmgmtdb database size
    • Transport type
    • Host name
    • Port number
  8. In Configure Self Management, enter:
    • Enable Self Management
    • Self Management user name
    • Self Management user password

    If you change the Self Management user password after configuring Self Management, execute:

    sp_addexternlogin loopback, <Self Management user name>, <Self Management user name>, <new Self Management user password>
  9. Click Build Servers! to proceed with configuration. srvbuild displays the configuration status as it builds the servers you selected. After the server configuration completes, click Exit to quit srvbuild.