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:

Configure new Adaptive Server
- Configure new Backup Server – see the System Administration Guide
- Configure a new XP Server – see the Transact-SQL® Users Guide
- Configure Job Scheduler – see the Job Scheduler Users Guide
  - Enable Self Management
- Configure Web Services – see Web Services Users Guide
Configure Unified Agent – see Unified Agent and Agent Management Console

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.
Port number	Default is 5000.
Error log	Name and location of the error log file. Defaults to servername.log.
Application type	(Default) MIXED – both OLTP and DSS. OLTP – online transaction processing generally consists of smaller, less complex transactions. 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 to 4KB in Adaptive Server version 15.5. The default in earlier versions was 2KB. 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.
Character set	Default is iso-1.
Sort order	Default is bin-iso-1.
Optimize Adaptive Server configuration. If you select this option, you must also provide this information	Available physical memory for Adaptive Server – on 32-bit Windows, this value is either 1792MB or 80 percent of available RAM, whichever is smaller. On 64-bit Windows, this value is either 2816MB or 80 percent of available RAM, whichever is smaller. The default is no. Available CPU for Adaptive Server – the value is 80 percent of the physical CPU, with a default minimum of 1. The default is yes. Note: If the value specified is larger than the available resource for allocation to the server, the optimize configuration may fail, causing the server to not start.
Create sample databases	Create or install sample databases. Make sure you calculate the additional space 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	The default options are: 2KB page size – 30MB 4KB page size – 60MB 8KB page size – 120MB 16KB page size – 240MB
Master database size	The default options are: 2KB page size – 13MB (Default) 4KB page size – 26MB 8KB page size – 52MB 16KB page size – 104MB
System procedure device path	File path name.
System procedure device and database size	The default for both is 172MB.
System device path	File path name.
System device size	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	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
Temporary database device	Name of device.
Temporary database device size	Default is 100MB for all page sizes.
Temporary database size	Default is 100MB for all page sizes.
Enable PCI in Adaptive Server	If you select this option, provide this additional information: PCI device – default is sybpcidbdev_data.dat in %SYBASE%\data. PCI device size – default is 48. PCI database size – 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.

Note: The following steps are not necessary to complete an installation in console mode.

Set the Configure new Backup Server option:
- Backup Server name
- Port number – default is 5001
- Error log
Click Next.
Set the Configure new XP Server option:
- Port number – default is 5002
- Error log
Click Next.
Set the Configure Job Scheduler option:
- Job Scheduler name – the server name of the Job Scheduler. Default is js_server_name.
- Agent name – Default is <ASE Server Name>_JSAGENT.
- Port number – default is 4900.
- Management device.
- Management device size – the default is 75MB.
- Management database size – the default is 75MB.
Click Next.
Set the Configure self management option:
- Self management user name – default is "sa".
- Self management password – prompted only if you change the default user name.
Set the Configure Web Service option:
- Producer HTTP Port Number – default is 8181
- Producer HTTPS Port Number – default is 8182
- Producer Host Name
- Certificate Password
- Confirm Certificate Password
- Keystore Password
- Confirm Keystore Password
- Producer Log File
- Consumer Port Number – default is 8184
- Consumer Log File
(Optional) Set the Configure Unified Agent option:
Unified Agent is a Self-Discovery Service Adapter. If you choose to configure Unified Agent, you see:
- Do you want to configure UDP Adapter?
- Do you want to configure JINI Adapter? If you select this, enter:
  - JINI host name
  - JINI port number – default is 4160
  - JINI heart beat period – default is 900
  Note: If you choose No to both, you see a message similar to:
```
You must choose at least one adapter to configure.
```
Security Login Modules – choose the security login modules for the Unified Agent, then click Enable:
- Simple Login Module – default user name is Sybase. To change the user name and password, choose Modify Simple Login Module Properties.
- ASE Login Module – enabled by default.
- NT Proxy Login Module – not enabled by default. Select to enable the module.
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.