15.0
Adaptive Server Enterprise
Document ID DC35823-01-1500-04
Contents
Adaptive Server Default Configuration
Configuring new servers with srvbuild
Configuring the Operating System
Configuring the server for multiple network handlers
Contents
Starting Adaptive Server Enterprise as IPv6-aware
Conversions between server and client
109
105
Adding Optional Functionality to Adaptive Server 113
125
Media devices
About This Book
This manual contains the following chapters
Introduction is an overview of Adaptive Server
Related documents
Viii
About This Book
Adaptive Server Enterprise
Other sources of information
Finding the latest information on component certifications
Xii
Role to your MySybase profile
Formatted using modified Backus Naur Form BNF notation
Product description to download the software
Following sections describe conventions used in this manual
Xiv
For a command with more options
Examples of output from the computer appear as follows
Accessibility features
Select, and select are the same
Information about these and other terms, see the Glossary
If you need help
Xvi
Topic
Introduction
About Adaptive Server
System-specific issues
System-specific issues
Introduction
System user roles
Environment variables
Sybase
Environment variables
Master device
Adaptive Server devices and system databases
Sysprocsdev device
Sybsystemdb device
Optional devices and databases
Adaptive Server devices and system 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
Maximum DOL table Number Column size Limits Columns 16K
Data row and data page tables
Database requirements for varying page sizes
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
Starting servers
Default start-up parameters are stored under
Server start-up parameters
Starting servers
Starting and Stopping Servers
Changing start-up parameters
Using the startserver command
Starting servers when the operating system restarts
Using the monserver and backupserver commands
Starting servers when the operating system restarts
For IBM RS/6000
For HP-UX
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
Starting XP Server after initial installation
Starting XP Server after initial installation
Where servername is the name of the Adaptive Server
Stopping servers
Enter
Stopping Backup Server
Stopping servers
Using the kill command
Stopping Monitor Server
UID PID Ppid Stime TTY Time Comd
Shutdown and shared memory files
Stopping servers
Setting environment variables
Configuring the Operating System
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
File descriptors and user connections
Restoring correct permissions
For AIX
Restoring correct permissions
For Sun Solaris
For Linux
Displaying current soft and hard limits
Increasing the soft limit
File descriptors and user connections
Setting up the sample program to increase the hard limit
Increasing the hard limit
Maxconnections
Sample program
Enabling asynchronous disk I/O
Enabling asynchronous disk I/O
This step is mandatory for HP users
HP technical support
Select asyncdsk and change the next boot to static
To launch the Kernel Configuration use kcweb -F
Issue the command
Owner of the /dev/async directory
Select Change/Show Characteristics of Asynchronous I/O
Enable asynchronous disk I/O
This step is mandatory for IBM users
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
Default settings
Adaptive Server Default Configuration
Defaults for Adaptive Server parameter 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
Type Interfaces file Task or topic See
Where to find interfaces file tasks and topics
Setting Up Communications Across the Network
How a client uses directory services
Creating a directory services entry
Supported directory drivers
Contents of an interfaces file
Heterogeneous and homogeneous environments
Chico
Heterogeneous and homogeneous environments
Understanding the format of the interfaces file
Understanding the format of the interfaces file
Components of an interfaces file entry
TCP style entry looks like
Components of an interfaces file
Setting Up Communications Across the Network
Using a text editor to create a master interfaces file
Using dsedit or dscp to create a master interfaces file
Using a text editor
Creating a master interfaces file
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
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
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
For a list of attributes
Interfaces file versus Ldap directory services
Lists the Sybase Ldap directory entries
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
For example
Ldapurl variables Keyword Description Default
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
Encrypting the password
Encrypting the password
Replace the password with the encrypted string
Performance
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
Lists the simplified Chinese character set
Lists the Baltic character set
Arabic character sets
Character set Unilib required Description
Lists the Cyrillic character set
Lists the traditional Chinese character set
Lists the Eastern European character set
Lists the Greek character set
Lists the Japanese character set
Lists the Hebrew character set
10 lists the Korean 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
Conversions between server and client
Character set conversion
Sort orders
Sort orders
Available sort orders
Your character set definition files
At a later time using the sqlloc utility
Srt file for your language. Sort orders are stored
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
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
100
Sort orders
17 Available sort orders
Language or script Sort orders File name
18 lists the supported character sets and their Sybase name
Character sets
101
18 Sybase character set names
102
Charset utility
Keywords Options Description
103
19 Keywords and options for charsets
104
Adaptive Server error logging
Logging Error Messages and Events
Enabling and disabling error logging
Setting error log paths
Setting the Adaptive Server error log path
Setting error log paths
Managing messages
Logging Error Messages and Events
Logging user-defined 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
111
Managing Adaptive Server Databases
112
Audit system devices and databases
Adding auditing
114
Overview of audit installation
Adding auditing
Installing auditing
Pre-installation tasks for auditing devices
Adding Optional Functionality to Adaptive Server
Auditinit displays the following menu
Creating a device for an audit table
116
117
Creating a device for the audit database transaction log
118
119
Enter y yes
Press Ctrl+A again. auditinit prompts with
Enter the number of the device to delete
Press return
Spsyntax installation scripts
Installing online help for Transact-SQL syntax
Online syntax help spsyntax
121
Installing sybsyntax
Default device for the sybsyntax database
Installing online help for Transact-SQL syntax
122
123
124
Index
Symbols
126
Index
127
HP-UX
128
Ldap
129
130
Smit
131
132
133
134