
CREATING AN ADAPTIVE SERVER

To define the attributes for a new Adaptive Server:

1. Accept the default values provided or modify the default values to
   suit the system needs at your site.
2. Provide values for all required attributes (those marked with an * ).
3. Provide values for additional functionality (optional).
4. Click Build Server! to create the new Adaptive Server.

If you selected more than one server type on the sybsetup main menu:
   a) Click OK to display the attribute screen for the next 
      server type, or
   b) Click Build Servers! on the attribute screen for the 
      last server type to create all the new server types.


ADAPTIVE SERVER ATTRIBUTES

ASE Application Type (Required)
------------------
ASE supports 3 application types: MIXED, OLTP and DSS. 
	OLTP - Online Transaction Processing: It basically requires high rate of smaller / less complex transactions.
	DSS - Decision Support Systems: It will have lesser intert/update activity with large complex queries.
	MIXED: OLT & DSS mix.
The default value is MIXED.

ASE Application Type has an effect on server page size, the default recommended values are:
	4k page size for MIXED and OLTP
	8k page size for  DSS


Master Device Path  (Required)
------------------
The master device stores the master database and other required 
system databases. 

For production systems, place the master device on 
a raw disk partition, rather than on an operating system file.

A warning is displayed regarding the use of an operating system
file. You can ignore this warning, if the Adaptive Server you are
creating is not intended for production use. 


Master Device Size  (Required)
------------------
The default recommended values are:
	30MB  for 2k page size server
	60MB  for 4k page size server
	120MB for 8k page size server
	240MB for 16k page size server.
You can enter a value less than the recommended size. 

The minimum sizes allowed are:
	13MB for 2k page size server
	25MB for 4k page size server
	49MB for 8k page size server
	97MB for 16 page size server.
  
If you entered a disk partition as the Master Device, 
the master device size reflects the size of the disk partition. 
You do not need to change the size.

If you entered an operating system file as the Master Device, 
you can change the size. The master device size is limited by the 
size of the file system.

Master Database Size (Required)
--------------------
The master database, located on the master device, contains required
system tables. The minimum and default sizes are:
	6MB  for 2k page size server
	12MB for 4k page size server
	24MB for 8k page size server
	48MB for 16k page size server.
	
For any additional languages you plan to install on the Adaptive Server,
add 2MB-7MB per language.

Sybsystemprocs Device Path  (Required)
--------------------------
The sybsystemprocs device stores the sybsystemprocs database,
which contains system-provided stored procedures.
 
For production systems, place the sybsystemprocs database  
on its own device rather than on the master device. 

This database usually increases in size from version to version,
so allow space for growth.


Sybsystemprocs Device Size  (Required)
--------------------------
The minimum and default recommended value is 100MB on 32 and 64 bit server.
  
If you entered a disk partition as the Sybsystemprocs Device Path, 
the sybsystemprocs device size reflects the size of the disk partition. 
You do not need to change the size.
 
If you entered an operating system file as the Sybsystemprocs Device Path, 
you can change the size. The size is limited by the 
size of the file system.


Sybsystemprocs Database Size  (Required)
----------------------------
The minimum and default size for the sybsystemprocs database is 100MB on
32 and 64 bit server, the same size as the device on which it is located. 
The database can be any size up to the size of the device.
 

Error Log Path  (Required)
--------------
The error log path points to a default error log file where specific 
server messages (kernel error, fatal error, backtraces) are sent. 

The default location is $SYBASE/install/servername.log.


Additional Command Line Parameters
----------------------------------
The additional command line options are used every time when this instance
of Adaptive Server is executed. It will set parameters that can not
otherwise be configured from this program.

Separate multiple parameters with a space. The parameters you specify
override the default values for your Sybase Adaptive Server.


Additional Command Line Parameters
----------------------------------
The additional command line options are used every time when this instance
of Adaptive Server is executed. It will set parameters that can not
otherwise be configured from this program.

Separate multiple parameters with a space. The parameters you specify
override the default values for your Sybase Adaptive Server.


Interfaces File Entry  (Required)
---------------------
The interfaces file is an "address book" containing
the network location for each server and client application. If the
network location is not in the interfaces file, servers and clients
cannot communicate with each other.

The default location for the interfaces file is $SYBASE/interfaces.
An interfaces file entry contains:

    * Transport type
      The transport type, in conjunction with the port number, tells 
      Adaptive Server where to listen for clients or other servers. 
      It also tells clients where to go to query a particular server.

      The drop-down list contains the network protocols supported by 
      Sybase on this platform. The default is TCP.
        
    * Host name
      The host name is the name of the machine where you installed 
      Adaptive Server.
    
    * Port number 
      If you selected the default protocol for Transport type, the port number 
      displayed is the first available port address.

      If you selected a protocol other than the default, the first available
      port number may or may not be available.

NOTES: 
    - The port number you specify cannot be used for any other purpose 
      on the machine where Adaptive Server is installed. More than one 
      Adaptive Server can have the same port number only if each server 
      is on a different machine.  

    - Add the port number you selected for Adaptive Server to the 
      /etc/services file, and label the entry "Sybase specific services." 
      (You must log in as "root" to modify /etc/services.)
      Making this entry is not required for the operating system to function 
      properly, but it may prevent others from using the port number. 


EDIT ADVANCED ADAPTIVE SERVER ATTRIBUTES

To access the following fields, choose the Edit Advanced Adaptive
Server Attributes button. 


Sybsystemdb Device Path
-----------------------
NOTE: Define this attribute only if you plan to use two-phase commit 
      functionality. Otherwise, you can skip this field.  
 
The sybsystemdb device stores the sybsystemdb database, which contains 
the spt_committab table. This table stores and tracks information for 
each two-phase commit transaction. 

For production systems, place the sybsystemdb device  
on a raw disk partition, rather than on an operating system file.


Sybsystemdb Device Size
-----------------------
The recommended size is 5MB.

If you entered a disk partition as the Sybsystemdb Device Path, 
the sybsystemdb device size reflects the size of the disk partition. 
You do not need to change the size.
  
If you entered an operating system file as the Sybsystemdb Device Path, 
you can change the size. The size is limited by the size of the file system.


Tempdb Device Path
-----------------------
NOTE: Define this attribute only if you plan to increase your tempdb. 
Otherwise, you can skip this field.  
 
The tempdb device provides a storage area for temporary tables and 
other temporary working storage needs. The space in tempdb is shared 
among all users of all databases on the server.

The tempdb is initially created on the master device.  It is recommended 
this database extended on a new device.


Tempdb Device Size
-----------------------
The recommended size is 100MB.

If you entered a raw disk partition as the Tempdb Device Path, 
the tempdb device size reflects the size of the raw disk partition. 
You do not need to change the size.
  
If you entered an operating system file as the Tempdb Device Path, 
you can change the size. The size is limited by the size of the file system.


Tempdb Database Size
----------------------------
The minimum and default size for the tempdb database is 100MB on
32 and 64 bit server, the same size as the device on which it is located. 
The database can be any size up to the size of the device.
 

Shared Memory Directory
-----------------------
Use this option to place shared memory files in a directory other
than the default location in $SYBASE. 


Default Backup Server
---------------------
Provide the name of the Backup Server that the Adaptive Server
will use for dumps and loads.


