Chapter 3: Default Adaptive Server Configuration

When you install or upgrade Adaptive Server, it includes some default parameter settings and a few of its auxiliary programs.

After installing and testing this “default” Adaptive Server, you can configure it to your system’s needs and install other optional features.

After installation, Adaptive Server default settings are as listed in Table 3-1. You may need to configure these settings to suit your computer and database needs.

Table 3-1: Defaults for Adaptive Server parameter settings

Item

Default value

Name

AdaptiveServername

Network support

Named Pipes, Windows Sockets (TCP/IP)

Pipe name

\pipe\sybase\query

Socket number

5000

Command line options

None

Error log path

%SYBASE%\%SYBASE_ASE%\install/error log

Event logging

Not configured

International Support (Localization):

  • Language

  • Character set

  • Sort order

us_english cp850 Binary ordering

Login security mode

Standard

Table 3-2 lists the default settings for the Backup Server, Monitor Server, and XP Server.

Table 3-2: Defaults for the Backup, Monitor, and XP servers

Server

Item

Default value

Backup Server

Name

AdaptiveServername_BS

Network support

Named Pipes, Windows Sockets (TCP/IP)

Pipe name

\pipe\sybase\backup

Socket number

5001

Error log path

%SYBASE%\%SYBASE_ASE\install\ backup.log

Monitor Server

Name

AdaptiveServername_MS

Network support

Named Pipes, Windows Sockets (TCP/IP)

Pipe name

\pipe\sybase\monitor

Socket number

5002

Error log path

%SYBASE%\%SYBASE_ASE\install\ monitor.log

XP Server

Name

AdaptiveServername_XP

Network support

Named Pipes, Windows Sockets (TCP/IP)

Pipe name

\pipe\sybase\xp

Socket number

5003

Error log path

N/A