Sybase DC35823-01-1500-04 Index

Configuration Guide 125

Symbols

::= (BNF notation)

in SQL statements xiv

, (comma)

in SQL statements xiv

{} (curly braces)

in SQL statements xiv

() (parentheses)

in SQL statements xiv

[ ] (square brackets)

in SQL statements xiv

A

accented letters 13, 91

Adaptive Server

character set, changing 83

character sets 89

client communications with 49

conversions between, and clients 89

customizing features 47

database device requirements 9

default character set 83

default configuration 47, 48

default sort order 83

error log path 106

language, changing 83

naming in interfaces file 56

shutting down 24

sort order 83

starting from UNIX command line 18

starting with operating system 20

start-up script 22

adding a server, LDAP 76

address component in interfaces files

TCP protocol entry 57

administrator

operating system 3

Sybase system 3

API component in interfaces file

described 56

Arabic character sets 85

asynchronous I/O (AIO)

enabling 38, 39, 40

HP driver 38, 39

audit system 113

audit trail

overview 113

system audit tables 114

auditing

database for 114

device for 114

global options 114

installing using the auditinit utility 114

installing using the installsecurity script 114

process 114

recommended database device size 9

tables for tracking 114

auditinit utility 7

B

Backup Server

character sets 89, 99

configuring 94, 97

default configuration 48

starting from UNIX command line 18

starting with operating system 20

Backup Server, default, for Adaptive Server 48

Backus Naur Form (BNF) notation xiii, xiv

binary sort order 91

BNF notation in SQL statements xiii, xiv

Bourne shell 29

brackets. See square brackets [ ]

buffer specifications 15

Index

Contents

Main Page Contents CHAPTER 2 Starting and Stopping Servers .................................................... 17 iv CHAPTER 3 Configuring the Operating System........... ................................... 29 CHAPTER 4 Adaptive Server Default Configuration........................................ 47 CHAPTER 5 Setting Up Communications Across the Network...................... 49 CHAPTER 7 Customizing Localization for Adaptive Server........................... 81 vi CHAPTER 8 Logging Error Messages and Events ........................................ 105 CHAPTER 9 Managing Adaptive Server Databases....................................... 109 CHAPTER 10 Adding Optional Functionality to Adaptive Server................... 113 About This Book Page Page Page Page Page Page xiv Syntax statements (displaying the syntax and all options for a command) appear as follows: For a command with more options: Page Page About Adaptive Server System-specific issues System user roles Environment variables Page Adaptive Server devices and system databases The master device The sybsystemdb device The sysprocsdev device Optional devices and databases Page dsync option on by default for database device files Determining the location, type, and size of a database device For Solaris, HP-UX, IBM AIX, and Linux For All Platforms Page Client/server communication Changing Adaptive Server configuration Languages other than U.S. English Adaptive Server specifications Adaptive Server specifications 14 CHAPTER 1 Introduction Table 1-3 lists the column and row limits for data-only-locked (DOL) tables. Adaptive Server specifications 16 Overview Requirements for starting servers Starting servers Server start-up parameters Changing start-up parameters Using a RUN_server_name file Using the startserver command Using the monserver and backupserver commands Starting servers when the operating system restarts Page For Sun Solaris and Linux Page Starting XP Server after initial installation Stopping servers Stopping Adaptive Server Stopping Backup Server Stopping Monitor Server Using the kill command Shutdown and shared memory files Page System Setting environment variables Configuring new servers with srvbuild Page Page Using the stty setting Restoring correct permissions File descriptors and user connections For AIX Displaying current soft and hard limits Increasing the soft limit Increasing the hard limit Sample program Enabling asynchronous disk I/O Page Page Adjusting the client connection timeout period Checking for hardware errors Monitoring the use of operating system resources For IBM RS/6000 For Sun Solaris and Linux A sample C shell maintenance script Page Configuration Default settings Default settings 48 Across the Network How Adaptive Server determines which directory service entry to use How a client uses directory services Creating a directory services entry Supported directory drivers Contents of an interfaces file Heterogeneous and homogeneous environments 54 Understanding the format of the interfaces file Understanding the format of the interfaces file 56 A TCP style entry looks like: Components of an interfaces file entry Table 5-2 describes the components of an interfaces file entry. CHAPTER 5 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 Configuring interfaces files for multiple networks Configuring the server for multiple network handlers Sample interfaces files for multiple network handlers Configuring the client connections Using one network-independent DSQUERY name Using different DSQUERY names Configuring for query port backup IPv6 support Understanding IPv6 IPv6 infrastructure Starting Adaptive Server Enterprise as IPv6-aware Troubleshooting Server fails to start Error when executing an ESP Page Access Protocol as a Directory Service Overview LDAP directory services versus the Sybase interfaces file Page libtcl*.cfg file on page 73 The libtcl*.cfg file Enabling LDAP directory services Page Adding a server to the directory services Multiple directory services Encrypting the password Performance Migrating from the interfaces file to LDAP Page Adaptive Server Overview of localization support Language modules Default character sets for servers Changing the default language and character set Changing the default character set for servers Supported character sets Page Overview of localization support 86 Table 7-4 lists the traditional Chinese character set: Table 7-7 lists the Greek character set: Table 7-5 lists the Cyrillic character set: Table 7-6 lists the Eastern European character set: Page Overview of localization support 88 Table 7-13 lists the Unicode character set: Table 7-14 lists the Vietnamese character set: Table 7-15 lists the Western European character set: Character set conversion Conversions between server and client Sort orders Available sort orders Page Sort orders 92 Language modules Installing a new language module Message languages Localization Localization directories About the directory About the charsets directory About the locales.dat file Format of locales.dat file entries How client applications use locales.dat Editing the locales.dat file Changing the localization configuration Adaptive Server localization Backup Server localization Configuring Adaptive Server for other character sets Changing the localization configuration 100 Sort orders CHAPTER 7 Customizing Localization for Adaptive Server Character sets Table 7-18 lists the supported character sets and their Sybase name. Changing the localization configuration 102 charset utility CHAPTER 7 Customizing Localization for Adaptive Server Page Events Adaptive Server error logging Enabling and disabling error logging Setting error log paths Setting the Adaptive Server error log path Managing messages Logging user-defined messages New messages Existing messages Logging auditing events Databases Managing database devices Device requirements Creating files for database devices Page Page Adaptive Server Adding auditing Audit system devices and databases Overview of audit installation Pre-installation tasks for auditing devices Installing auditing Page Page Page Page Page Installing online help for Transact-SQL syntax Online syntax help: sp_syntax Default device for the sybsyntax database Installing sybsyntax Page Page Index Symbols A B 126 C D E F 128 G H I J K L 130 M N O P Q R S 132 T U