Configuring New Servers with srvbuild

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

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 Adaptive Server type screen, select the:
   • Adaptive Server 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 Adaptive Server 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 Adaptive Server Attributes tab, enter:

   • Adaptive Server configuration file
   • sybsystemdb device path
   • sybsystemdb device size
   • sybsystemdb database size
   • Share memory file directory
   • Default Backup Server
   • tempdb information – Adaptive Server 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 Adaptive Server
     If you enable PCI in Adaptive Server, also set:

     • sybpcidb device path
     • sybpcidb device size
     • sybpcidb database size
   • Optimize Adaptive Server configuration values. After configuring a server, srvbuild prompts you for these values:
     • Available physical memory for Adaptive Server
     • Available CPU for Adaptive Server

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