Home

	Expand Search

Configuring Adaptive Server Enterprise for Digital Alpha NT

Chapter 2: Beginning Adaptive Server Configuration

Chapter 2

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.

Topics covered are:

• Adaptive Server Default Configuration
• Starting Server Config for Adaptive Server
• Configuring Adaptive Server
• Configuring Backup Server
• Configuring Monitor Server

For information about configuring languages, character sets, and sort orders, as well as optional features, see "How to Use This Book".

Adaptive Server Default Configuration

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

Table 2-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	d:\sybase\install\errorlog
Event logging	Not configured
International Support (Localization) - Language - Character set - Sort order	us_english cp850 Binary ordering
Login security mode	Standard

Table 2-2 lists the default settings for the Backup Server, Monitor Server, and XP Server. For more information about these servers, see "About Adaptive Server".

Table 2-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	d:\sybase\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	d:\sybase\install\ms.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

Starting Server Config for Adaptive Server

To change configuration settings for Adaptive Server, use the Server Config utility. You can run this program in one of two ways:

• The Server Config utility from within Windows NT

  To run this utility from the Windows NT command prompt, run syconfig.exe.

• The sp_configure procedure from within isql

  Use the sp_configure procedure, which appears in several places in this manual, to quickly and easily change single parameters and values. For more information, see sp_configure in the Adaptive Server Reference Manual.

This manual walks you through Adaptive Server configuration through the Server Config utility.

To start Server Config:

1. Select Programs from the Start menu.

2. Choose your Sybase program group.

3. Choose Server Config.

   The Configure Sybase Servers dialog box appears:

   

4. Continue configuration for the server that you want to configure:
   • Adaptive Server
   • Backup Server
   • Monitor Server
5. When you have completed the necessary configuration changes, click Exit to quit Server Config.

Configuring Adaptive Server

To change the Adaptive Server configuration, including its auxiliary programs and options:

1. Start Server Config.

   For instructions on starting this utility, see "Starting Server Config for Adaptive Server".

2. Click the Adaptive Server icon, and click Configure Adaptive Server from the Configure Sybase Servers dialog box.

   The server names appear in the Existing Servers dialog box:

   

3. Select the name of the server to configure, and click Continue.

   The Enter System Administrator Password dialog box appears.

4. Type the login name and password of an Adaptive Server user with System Administrator privileges, and click Continue.

5. Click Yes if the Adaptive Server is not running, and Server Config asks you if you want to start it.

   The Configuring Adaptive Server Enterprise dialog box appears.

   

6. Select the option to be configured from the Change Options set of buttons:
   • Command Line -
   • Default Backup Server -
   • Default XP Server -
   • Two Phase Commit - For information about this option, see Installing Adaptive Server for Digital Alpha Windows NT.
   • Error Log Path -
   • Event Logging -
   • Language -
   • Login Security -

Setting Adaptive Server Parameters

When you start Adaptive Server, you can configure the server to use certain configuration parameters that are not accessible through isql.

To set these configuration parameters:

1. Click Command Line from the Change Options box on the Configuring Adaptive Server Enterprise dialog box.

   The Command Line Parameters dialog box appears.

   

2. Type in parameters and values that you want to set for Adaptive Server.

   Type these parameters as you would at the command line. However, be sure to omit the command itself and any parameters that might vary.

3. Click OK to return to the Configure Adaptive Server Enterprise dialog box.

4. When you have completed the necessary configuration changes, click Exit to quit Server Config.

Changing the Default Backup Server

During backup or recovery, the dump or load command uses the Backup Server named in the configuration for the selected Adaptive Server. You can name a different default Backup Server through the Adaptive Server configuration.

To name a different Backup Server to use as the default:

1. Click Default Backup Server from the Change Options buttons.

   The Set Default Backup Server Name dialog box appears.

   

2. Type the name of the Backup Server as the default, and click OK.

   For information about naming and configuring Backup Server, see "Configuring Backup Server".

3. Click Save to return to the Configuring Adaptive Server Enterprise dialog box.

4. When you have completed the necessary configuration changes, click Exit to quit Server Config.

Changing the Default XP Server

XP Server provides the extended stored procedures available through Adaptive Server.

When you install Adaptive Server, the program defines XP Server using the Adaptive Server name as a basis for the filename. For example, XP Server for an Adaptive Server named PIANO is named PIANO_XP.

You can change the configuration for the default XP Server for a particular Adaptive Server. See "Sybmail and Extended Stored Procedures".

Configuring Backup Server

Backup Server performs all Adaptive Server backup and recovery operations (dump and load).

When you install Adaptive Server, the program defines Backup Server using the Adaptive Server name as a basis for the filename. For example, Backup Server for an Adaptive Server named PIANO is named PIANO_BS.

To change the configuration for a Backup Server:.

1. Start Server Config.

   For instructions on starting this utility, see "Starting Server Config for Adaptive Server".

2. Click the Backup Server icon, and click Configure Backup Server from the Configure Sybase Servers dialog box.

   

3. Select the name of the server to configure from the Existing Servers dialog box, and click Continue.

   The Configure Backup Server dialog box appears.

   

4. Change the path indicated in the Error Log Path area, if necessary.

   For more information about the error log, see Chapter 6, "Logging Error Messages and Events".

5. Change the language indicated in the Language area that Backup Server will use for its messages, if necessary.

   For more information about languages, see "Language Modules".

6. Change the server's character set in the Character Set area, if necessary.

   For more information about character sets, see "Character Sets".

7. Click Save to return to the Configure Sybase Servers dialog box.

8. When you have completed the necessary configuration changes, click Exit to quit Server Config.

Configuring Monitor Server

Monitor Server is an Open Server(TM) application that obtains statistics on Adaptive Server performance by monitoring its shared memory. You can view these statistics from the Monitor Viewer in Sybase Central(TM).

Database administrators can use Monitor Server to examine server statistics using a graphical client/server tool. Statistics are available for:

• Memory allocation
• Network traffic
• CPU use
• Locking status by process
• Data and procedure cache use
• Disk I/O volume and average completion time by device
• Transaction rates

To change the configuration for Monitor Server:

1. Start Server Config.

   For instructions on starting Server Config, see "Starting Server Config for Adaptive Server".

   

2. Click the Monitor Server icon, and click Configure Monitor Server from the Configure Sybase Servers dialog box.

   The Existing Servers dialog box appears.

3. Click the name of the Monitor Server you want to configure, and click Continue.

   The Configure Monitor Server dialog box appears.

   

4. Change the error log path, if necessary.

5. Change the Adaptive Server Name entry to the Adaptive Server name to be monitored. The Monitor Server name changes automatically.

6. Click on the Command Line Parameters button to change the default parameters.

   For more information on default command line parameters, see "Setting Adaptive Server Parameters".

7. Click Save to return to the Configure Sybase Servers dialog box.

8. When you have completed the necessary configuration changes, click Exit to quit Server Config.

For more information about configuring Monitor Server, see the Adaptive Server Enterprise Monitor Server User's Guide.

Supporting Access to Large Memory

To support access to 2GB of memory, use isql to set the starting virtual memory address with sp_configure, for example:

sp_configure "shared memory starting address", 23662592

Be sure to reboot your computer to put the new value into effect.

Note: Do not set Monitor Server to use most of the available virtual address space. This access may limit Monitor Server functionality.

For instructions on displaying the latest information about large memory and Windows NT, see "Support for High-Availability Products".

For more information about shared memory, see Installing Adaptive Server for Digital Alpha Windows NT.