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
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
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
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
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
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
So on. If your script is named sybstart, type the following
Returns
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 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
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
File descriptors and user connections
Setting up the sample program to increase the hard limit
Increasing the hard limit
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 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 value
Adaptive Server Default Configuration
Default settings
Defaults for Adaptive Server parameter settings
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
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
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
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
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
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
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
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,
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
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
Keywords Options Description
103
19 Keywords and options for charsets
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
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
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