Minimally Configuring an SAP ASE Server

Use GUI mode to minimally configure an SAP ASE 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 SAP ASE
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
6. Configure SAP Control Center – see SAP 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 the SAP ASE server.

Task

Set the Configure New SAP ASE option:

Option	Description
SAP ASE 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 SAP ASE version 15.5. If you plan to load database dumps from an SAP ASE 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 iso_1.
Default Sort Order	Default is bin_iso_1.
Optimize SAP ASE Server Configuration	Specify Yes if you want to optimize the configuration for your system. The default is No.
Available Physical Memory for SAP ASE Server	Appears when you select Yes for Optimize SAP ASE Configuration, and is the numeric value is 80 percent of the sum of combined default physical memory and default OS shared memory. 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 SAP ASE	Appears when you select Yes for Optimize SAP ASE 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.

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

Configuration	Value
Master Device	Name, including location, of the master device.
Master Device Size (MB)	The minimum sizes are: 2KB page size – 29MB 4KB page size – 45MB 8KB page size – 89MB 16KB page size – 177MB The default sizes are: 2KB page size – 36MB 4KB page size – 52MB 8KB page size – 104MB 16KB page size – 208MB
`master` Database Size (MB)	The minimum and default sizes are: 2KB page size – 18MB 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) and System Procedure Database Size (MB)	The default for both is 196MB.
System Device	The complete file path name.
System Device Size (MB) and System Database Size (MB)	The default options for both 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) and Tempdb Database Size (MB)	The default for both is 100MB for all page sizes.
Enable PCI in SAP ASE	Enable the pluggable component interface. The PCI is a generic interface internal to SAP ASE that is installed by default when you install or upgrade SAP ASE. 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) and PCI Database Size (MB)	Appears when you select Enable PCI. The PCI device and PCI database size are the same: 2KB page size server – 48MB (Default) 4KB page size server – 96MB 8KB page size server – 192MB 16KB page size server – 384MB

After customizing your SAP ASE configuration, click Next to record the input fields.

Set the 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.
Allow Hosts	Comma-separated lists of hosts that are allowed to connect to this Backup Server. When null, only the dataserver running on the same host as the Backup Server can access this Backup Server. The default value is null.

Set the Configure New XP Server option:

Configuration	Value
XP Server Name	The XP Server name is set automatically, 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:

Configuration	Value
Job Scheduler Agent name	The default is <`ASE Server Name`>_JSAGENT.
Port number	The 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 SAP ASE database:
- Self-management user name – default is "sa". Entering a new user name creates it in SAP ASE.
- Self-management password.
Set the SAP Control Center – Configure Self Discovery Service Adapter option:
- Configure UDP Adapter
- Configure JINI Adapter – 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 SAP Control Center Management User Interface for SAP ASE, 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 SAP 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 the user names and passwords in Configure Administration Passwords. If you installed:

Option	Description
If you installed the SAP Control Center Management User Interface for SAP ASE:	Enter: SCC administrator user SCC administrator password Confirm SCC administrator password
If you installed either the SAP Control Center Management User Interface for SAP ASE or the Remote Command and Control Agent for SAP ASE:	Enter: SCC agent administrator user SCC agent administrator password Confirm SCC agent administrator password

Set the Repository Password – enter the password for the repository.
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.
In the Installation Completed window:

Option Description

GUI mode Click Done

Console mode press Enter to exit the installation

Option	Description
GUI mode	Click Done
Console mode	press Enter to exit the installation

SAP ASE 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.