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: 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
  1. Set the Configure New SAP ASE option:
    OptionDescription
    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 roman8.

    Default Sort Order

    Default is bin_roman8.

    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.
  2. After customizing your SAP ASE configuration, click Next to record the input fields. You see Enter the custom configuration values:
    ConfigurationValue
    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.

  3. Set the Configure New Backup Server option:
    ConfigurationValue
    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.
  4. Set the Configure New XP Server option:
    ConfigurationValue
    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.
  5. Set the Configure Job Scheduler option:
    ConfigurationValue
    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.

  6. 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.
  7. 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.
  8. 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.
  9. 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.
  10. 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
  11. Set the Repository Password – enter the password for the repository.
  12. 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.
  13. In the Installation Completed window:
    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.

Related concepts
SAP ASE Upgrades
Managing SAP ASE with SAP Control Center
Related tasks
Installing SAP ASE in GUI Mode
Related reference
Installing Sample Databases