Minimally Configuring Adaptive Server

Use GUI mode to minimally configure Adaptive Server and related products for use.

Prerequisites

The Configure screen shows a list of everything you can minimally configure. By default, all products are selected. Unselect any products you do not want to configure now. If you are configuring in console mode, enter the corresponding number:

1. Configure New Adaptive Server
2. Configure New Backup Server – see the System Administration Guide
3. Configure New XP Server – see the Transact-SQL^® Users Guide
4. Configure Job Scheduler – see the Job Scheduler Users Guide
5. Enable Self Management
7. Configure Sybase Control Center – see Sybase Control Center Installation Guide

When finished, click Next in the GUI wizard, or enter 0 in console mode. You are now ready to begin configuring Adaptive Server.

Task

Set the Configure New Adaptive Server option:

Option	Description
Adaptive Server Name	Default is the machine name.
System Administrator's Password	Enter your password.
Confirm System Administrator's Password	Enter your password.
Port Number	Default is 5000.
Error Log	Name and location of the error log file. Defaults to servername.log.
Application Type	These options are numbered only in console mode: 1. (Default) MIXED – both OLTP and DSS. 2. OLTP – online transaction processing generally consists of smaller, less complex transactions. 3. DSS – decision-support systems generally have less update activity with large complex queries.
Page Size	2KB (Default) 4KB 8KB 16KB The default page size selection changed from 2KB to 4KB in Adaptive Server version 15.5. If you plan to load database dumps from an Adaptive Server with a page size that is not 4KB, enter the page size that matches the database dump.
Language	Default: us-english. In typical installations, only us-english is available.
Default Character Set	Default is roman8.
Default Sort Order	Default is bin_roman8.Default is bin-iso-1.
Optimize Adaptive Server Configuration	Optimize the configuration for your system. Note: If you specify a value that is larger than the available resource for allocation to the server, the optimize configuration may fail, causing the server to not start.
Available Physical Memory for Adaptive Server	Appears when you select Optimize Adaptive Server Configuration. The value is 80 percent of the sum of combined default physical memory and default OS shared memory. The default is no. Note: If you specify a value that is larger than the available resource for allocation to the server, the optimize configuration may fail, causing the server to not start.
Available CPU for Adaptive Server	Appears when you select Optimize Adaptive Server Configuration. The value is 80 percent of the physical CPU, with a default minimum of 1.
Create Sample Databases	Select this option for the installer to install sample databases. The installer automatically calculates any additional space needed for your master device.

After customizing your Adaptive Server configuration, click Next to record the input fields. You see Enter the custom configuration values:

Configuration	Value
Master Device	Name of master device and the path where it should be located
Master Device Size (MB)	The default options are: 2KB page size – 30MB 4KB page size – 60MB 8KB page size – 120MB 16KB page size – 240MB
Master Database Size (MB)	The default options are: 2KB page size – 13MB (Default) 4KB page size – 26MB 8KB page size – 52MB 16KB page size – 104MB
System Procedure Device	The complete file path name.
System Procedure Device Size (MB)	The complete file path name.
System Procedure Database Size (MB)	The default for both is 172MB.
System Device	The complete file path name.
System Device Size (MB)	The default options are: 2KB page size server – 3MB (Default) 4KB page size server – 6MB 8KB page size server – 12MB 16KB page size server – 24MB
System Database Size (MB)	The default options are: 2KB page size server – 3MB (Default) 4KB page size server – 6MB 8KB page size server – 12MB 16KB page size server – 24MB
Tempdb Device	The full path of the device.
Tempdb Device Size (MB)	Default is 100MB for all page sizes.
Tempdb Database Size (MB)	Default is 100MB for all page sizes.
Enable PCI in Adaptive Server	Enable the pluggable component interface. The PCI is a generic interface internal to Adaptive Server that is installed by default when you install or upgrade Adaptive Server. See Java in Adaptive Server Enterprise.
PCI Device	Appears when you select Enable PCI. The default is sybpcidbdev_data.dat in $SYBASE/data.
PCI Device Size (MB)	Appears when you select Enable PCI. 2KB page size server – 24MB (Default) 4KB page size server – 48MB 8KB page size server – 96MB 16KB page size server – 192MB
PCI Database Size (MB)	Appears when you select Enable PCI. The PCI device and PCI database size are the same: 2KB page size server – 24MB (Default) 4KB page size server – 48MB 8KB page size server – 96MB 16KB page size server – 192MB

After customizing your Adaptive Server configuration, click Next to record the input fields.

Set Configure New Backup Server option:

Configuration	Value
Backup Server Name	The default is `machinename`_BS.
Port Number	The port number of the Backup Server. The default is 5001.
Error Log	The full path to the error log file.

Set the Configure New XP Server option:

Configuration	Value
XP Server Name	The XP Server name is set automatically, and is in the form of `machinename`_XP.
Port Number	The port number of the Backup Server. The default is 5002.
Error Log	The full path to the error log file.

Set the Configure Job Scheduler option:
- Job Scheduler Agent name – Default is <ASE Server Name>_JSAGENT.
- Port number – default is 4900.
- Management device – the full path to the device.
- Management device size, in MB – the default is 75.
- Management database size, in MB – the default is 75.
Click Next.
Set the Configure Self Management option to create a scheduled job to run update statistics on any table in any Adaptive Server database:
- Self management user name – default is "sa". Entering a new username creates it in Adaptive Server.
- Self management password.
Set the Sybase Control Center – Configure Self Discovery Service Adaptor option:
- Configure UDP Adaptor
- Configure JINI Adaptor – if you select this option, enter:
  - JINI host name – default is localhost.
  - JINI port number – default is 4160.
  - JINI heartbeat period, in seconds – default is 900.
Note: If you do not select an adapter, you see a message similar to:
```
You must choose at least one adapter to configure.
```
If you installed the Sybase Control Center Management User Interface for Adaptive Server, set the SCC Configure HTTP Ports option.
Accept the default options, or specify other, unused ports, ensuring that the port numbers do not conflict with those used by other applications or services on your system:
- HTTP port – choose an integer between 1025 and 65535.
- HTTPs port – choose an integer between 1025 and 65535.
Set the Sybase Control Center – Configure RMI Port option with a port number (1025 to 65535) that is not used by another application or service on the system. The default is 9999.
Set these passwords in Configure Administration Passwords:
- SCC administrator password – if you installed the Sybase Control Center Management User Interface for Adaptive Server
- SCC agent administrator password – if you installed either the Sybase Control Center Management User Interface for Adaptive Server or the Remote Command and Control Agent for Adaptive Server
Verify that the values that appear in the Configure New Servers Summary window are correct, then click Next. You see the Configure Server Progress window.
You may see the restart window, which reminds you to either log out or restart your machine to complete the installation process.
In the Installation Completed window, click Done in GUI mode. In console mode, press Enter to exit the installation.

Adaptive Server and related products have been successfully installed, and minimally configured for use. See Installing Sample Databases, to begin experimenting with your servers, or see the System Administration Guide for more advanced topics.

If you encounter any errors, see the Troubleshooting Guide.