15.0
Adaptive Server Enterprise
 Document ID DC35823-01-1500-04
 Contents
 Configuring the Operating System
Configuring new servers with srvbuild
Adaptive Server Default Configuration
 Conversions between server and client
Contents
Configuring the server for multiple network handlers
Starting Adaptive Server Enterprise as IPv6-aware
 125
105
109
Adding Optional Functionality to Adaptive Server 113
 Introduction is an overview of Adaptive Server
About This Book
Media devices
This manual contains the following chapters
 Related documents
Viii
 About This Book
 Adaptive Server Enterprise
 Other sources of information
 Finding the latest information on component certifications
Xii
 Following sections describe conventions used in this manual
Formatted using modified Backus Naur Form BNF notation
Role to your MySybase profile
Product description to download the software
 Xiv
For a command with more options
 Information about these and other terms, see the Glossary
Accessibility features
Examples of output from the computer appear as follows
Select, and select are the same
 If you need help
Xvi
 About Adaptive Server
Introduction
Topic
 System-specific issues
System-specific issues
 Environment variables
System user roles
Introduction
 Sybase
Environment variables
 Master device
Adaptive Server devices and system databases
 Adaptive Server devices and system databases
Sybsystemdb device
Sysprocsdev device
Optional devices and databases
 Introduction
 Dsync option on by default for database device files
 Minimum Device Purpose Size Recommended size
Adaptive Server database devices
 Choosing a raw partition
 Client/server communication
 Changing Adaptive Server configuration
Changing Adaptive Server configuration
 Languages other than U.S. English
Adaptive Server specifications
 Table specifications
Adaptive Server specifications
 Databases 16K
Data row and data page tables
Maximum DOL table Number Column size Limits Columns 16K
Database requirements for varying page sizes
 Data limits for tables according to page size
Databases 16K
Tables 16K
 Overview
A P T E R 2 Starting and Stopping Servers
Requirements for starting servers
 Starting servers
Default start-up parameters are stored under
Starting servers
Server start-up parameters
 Starting and Stopping Servers
Changing start-up parameters
 Starting servers when the operating system restarts
Starting servers when the operating system restarts
Using the startserver command
Using the monserver and backupserver commands
 For IBM RS/6000
For HP-UX
 For Sun Solaris and Linux
 If your script is named sybstart, type the following
Returns
So on. If your script is named sybstart, type the following
 Stopping servers
Starting XP Server after initial installation
Starting XP Server after initial installation
Where servername is the name of the Adaptive Server
 Enter
Stopping Backup Server
 Stopping Monitor Server
Using the kill command
Stopping servers
 UID PID Ppid Stime TTY Time Comd
Shutdown and shared memory files
 Stopping servers
 Setting environment variables
Configuring the Operating System
 System environment variables
Configuring new servers with srvbuild
Variable Sample value Function
 Configuring the Operating System
 Configuring new servers with srvbuild
 Using the stty setting
 Restoring correct permissions
Restoring correct permissions
File descriptors and user connections
For AIX
 Increasing the soft limit
For Linux
For Sun Solaris
Displaying current soft and hard limits
 Increasing the hard limit
Setting up the sample program to increase the hard limit
File descriptors and user connections
 Maxconnections
Sample program
 HP technical support
Enabling asynchronous disk I/O
Enabling asynchronous disk I/O
This step is mandatory for HP users
 Owner of the /dev/async directory
To launch the Kernel Configuration use kcweb -F
Select asyncdsk and change the next boot to static
Issue the command
 Management Interface Tool Smit
Enable asynchronous disk I/O
Select Change/Show Characteristics of Asynchronous I/O
This step is mandatory for IBM users
 To display the current timeout period, enter
Adjusting the client connection timeout period
To display the current timeout value, enter
 Checking for hardware errors
Checking for hardware errors
To display the timeout value, enter
 Monitoring the use of operating system resources
 For Sun Solaris and Linux
 Sample C shell maintenance script
 Sample C shell maintenance script
 Default value
Adaptive Server Default Configuration
Default settings
Defaults for Adaptive Server parameter settings
 Defaults for Backup, Monitor, and XP Servers
Default settings
Server Default value
 A P T E R 5 Setting Up Communications Across the Network
 Type Interfaces file Task or topic See
Where to find interfaces file tasks and topics
 Creating a directory services entry
How a client uses directory services
Setting Up Communications Across the Network
 Supported directory drivers
Contents of an interfaces file
 Heterogeneous and homogeneous environments
 Chico
Heterogeneous and homogeneous environments
 Understanding the format of the interfaces file
 Components of an interfaces file
Components of an interfaces file entry
Understanding the format of the interfaces file
TCP style entry looks like
 Setting Up Communications Across the Network
 Creating a master interfaces file
Using dsedit or dscp to create a master interfaces file
Using a text editor to create a master interfaces file
Using a text editor
 Configuring the server for multiple network handlers
Configuring interfaces files for multiple networks
 Configuring interfaces files for multiple networks
Configuring the client connections
 Using one network-independent Dsquery name
 Configuring for query port backup
 Understanding IPv6
IPv6 support
Adaptive Server supports IPv6 technology
 IPv6 support
IPv6 infrastructure
IPv6 support
 Starting Adaptive Server Enterprise as IPv6-aware
 Troubleshooting
Troubleshooting
Server fails to start
 Investigating the port assignment
Error when executing an ESP
 Information on how to bring XP Server up
 Overview
 Ldap directory services versus the Sybase interfaces file
Ldap directory services versus the Sybase interfaces file
 Sybase Ldap directory definitions
Interfaces file versus Ldap directory services
For a list of attributes
Lists the Sybase Ldap directory entries
 Libtcl*.cfg file on
 Libtcl*.cfg file
 Enabling Ldap directory services
Enabling Ldap directory services
Where the ldapurl is defined as
 For example
Ldapurl variables Keyword Description Default
 Adding a server to the directory services
Adding a server to the directory services
Adding a server entry to the directory service using dsedit
 Multiple directory services
 Performance
Encrypting the password
Encrypting the password
Replace the password with the encrypted string
 Migrating from the interfaces file to Ldap
 Migrating from the interfaces file to Ldap
 Overview of localization support
Customizing Localization for Adaptive Server
 Overview of localization support
Language modules
 Customizing Localization for Adaptive Server
Default character sets for servers
 Supported character sets
Changing the default character set for servers
 Character set Unilib required Description
Lists the Baltic character set
Lists the simplified Chinese character set
Arabic character sets
 Lists the Greek character set
Lists the traditional Chinese character set
Lists the Cyrillic character set
Lists the Eastern European character set
 11 lists the Thai character set
Lists the Hebrew character set
Lists the Japanese character set
10 lists the Korean character set
 14 lists the Vietnamese character set
13 lists the Unicode character set
15 lists the Western European character set
 Conversions between server and client
Character set conversion
 Available sort orders
Sort orders
Sort orders
 16 Sort orders available in Adaptive Server
At a later time using the sqlloc utility
Your character set definition files
Srt file for your language. Sort orders are stored
 For utf8, see , Configuring Character Sets, Sort Orders,
 Language modules
Installing a new language module
Message languages
 Localization directories
Localization
Localization
 About the charsets directory
About the directory
About the locales.dat file
 How client applications use locales.dat
 Editing the locales.dat file
Changing the localization configuration
 Adaptive Server localization
Changing the localization configuration
 Configuring Adaptive Server for other character sets
Backup Server localization
 Language or script Sort orders File name
Sort orders
100
17 Available sort orders
 18 Sybase character set names
Character sets
18 lists the supported character sets and their Sybase name
101
 102
Charset utility
 19 Keywords and options for charsets
103
Keywords Options Description
 104
 Adaptive Server error logging
Logging Error Messages and Events
 Setting error log paths
Setting error log paths
Enabling and disabling error logging
Setting the Adaptive Server error log path
 107
Logging Error Messages and Events
Managing messages
Logging user-defined messages
 Managing messages
Logging auditing events
108
 Managing database devices
Managing Adaptive Server Databases
Device requirements
 Managing database devices
Creating files for database devices
110
 111
Managing Adaptive Server Databases
 112
 Audit system devices and databases
Adding auditing
 Adding auditing
Overview of audit installation
114
 Auditinit displays the following menu
Pre-installation tasks for auditing devices
Installing auditing
Adding Optional Functionality to Adaptive Server
 Creating a device for an audit table
116
 117
 Creating a device for the audit database transaction log
118
 119
 Press return
Press Ctrl+A again. auditinit prompts with
Enter y yes
Enter the number of the device to delete
 121
Installing online help for Transact-SQL syntax
Spsyntax installation scripts
Online syntax help spsyntax
 122
Default device for the sybsyntax database
Installing sybsyntax
Installing online help for Transact-SQL syntax
 123
 124
 Index
Symbols
 126
Index
 127
 HP-UX
128
 Ldap
129
 130
 Smit
131
 132
 133
 134