Use srvbuild to configure a new server with default or user-specified values for key configuration attributes. Use srvbuildres, in non-GUI mode, to configure a new server using a resource file. For more information on srvbuildres, see the Utility Commands Reference chapter in the Utility Guide.
To configure new servers with srvbuild:
Source SYBASE.csh or SYBASE.sh file in $SYBASE to setup the environment variables.
Run $SYBASE/$SYBASE_ASE/bin/srvbuild.
The Select Servers to Build window displays. Choose the servers you want to configure by clicking the boxes on the left. When you select each of the boxes, the server name text field is enabled where you can enter the server name.
The list of “Server type” available
for you to choose depends on what you have installed in $SYBASE.
When you have selected the servers you want to build, click OK. The next screen or screens displays information depending on what you chose to configure.
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 versions 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
When a new server is created using configuration tools, the default configuration that it is configured with 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 then 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.
The Adaptive Server 15.0.3 installer allows you to tune
basic configuration settings during installation, instead of as
a postinstallation task. See the Installation Guide for
more details.
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
To configure Monitor Server, select the following information in the Monitor Server screen:
Maximum number of connections
Error log
Configuration file
Shared memory directory
Transport type
Host name
Port number
In the XP Server type screen, select:
Transport type
Host name
Port number
In the Full-Text Search SDS type screen, select:
Error log
Collection directory
Default database
Language
Character set
Minimum number of sessions
Maximum number of sessions
Transport type
Host name
Port number
To configure Job Scheduler, enter the following information in the Job Scheduler type screen”
Sybmgmtdb device path
Sybmgmtdb device size
Sybmgmtdb database size
Transport type
Host name
Port number
In the “Configure Self Management...” screen, you can enter:
Enable Self Management
Self Management user name
Self Management user password
If you change the Self Management user password after configuring the Self Management, you need to rerun:
sp_addexternlogin loopback, <Self Management user name>, <Self Management user name>, <new Self Management user password>
Click Build Servers! to proceed with the servers configuration. srvbuild displays the configuration status as it builds the servers you selected.After the server configuration completes, click Exit to quit srvbuild.
