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.
In the Adaptive Server type screen, select the:
Adaptive Server Application type – the choices are:
MIXED – both OLTP and DSS.
OLTP – online transaction processing is generally used for a high rate of smaller, less complex transactions.
DSS – decision support systems generally have less update activity with large complex queries.
Server page size
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 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 current default input values for available physical
memory and available CPU are 80% of the physical memory
and CPU number. Input the value 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.
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.
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.
