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