129, Ldap | Sybase DC35823-01-1500-04 manual

query port backup configuration 62

query service type			56
retry_attempt component				56
servername component				56
service_type component				56
spaces in	55
tab characters in		55
unique elements in entries				59
used by clients		51
international systems
support for	81
Sybase support for			81
interpubs sample database				7
iostat command
IBM RS/6000		44
Sun Solaris	44
iso-Latin1 character set			83

J

Japanese sample database 7 jpubs sample database 7

K

KEEPALIVE option, TCP/IP 41 kill command 26, 28

Korean character sets 87

L

language Modules		82
language modules		93
default	47
installing new		93
localization files		82
memory requirements for				98
languages
changing	97
error reporting in specific				95
selecting message			93
translation support			81
Latin character sets		86

Index

LD_LIBRARY_PATH environment variable 4

LDAP

access restrictions				70
adding a server				76
defined	69
directory definitions					71
directory schema				73
enabling		74
multiple directory services						77
sample entry			72
specifying in libtcl.cfg					73
versus the interfaces file						70
LDAP libraries
environment variables					75
location of			75
LDAP server
using dsedit to add and modify							76
ldapurl
defined	74
example		74
keywords		75
letter case in sort orders					91
LIBPATH environment variable							4
libtcl*.cfg file			73
format of		74
location of			74
purpose of			73
libtcl*cfg
password		78
limits for file descriptors					35
listener service			52
loc files	95

local date, time, and currency formatting 95

locales directory			94
locales.dat file			95
localization		81
changing the configuration 97
common, information				95
localization support 47
loghost in interfaces files				59
login
root	3
sa	3
superuser		3
sybase		3
.login file		29

Configuration Guide

129

Image 145

Sybase DC35823-01-1500-04 manual 129, Ldap

Contents

15.0 Adaptive Server Enterprise Document ID DC35823-01-1500-04 Contents Configuring the Operating System Configuring new servers with srvbuildAdaptive Server Default Configuration Configuring the server for multiple network handlers ContentsStarting Adaptive Server Enterprise as IPv6-aware Conversions between server and client 109 105Adding Optional Functionality to Adaptive Server 113 125 Media devices About This BookThis 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 notationProduct 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 featuresSelect, and select are the same Information about these and other terms, see the Glossary If you need help Xvi About Adaptive Server IntroductionTopic System-specific issues System-specific issues Environment variables System user rolesIntroduction Sybase Environment variables Master device Adaptive Server devices and system databases Sysprocsdev device Sybsystemdb deviceOptional 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 tablesDatabase requirements for varying page sizes Databases 16K Data limits for tables according to page size Databases 16KTables 16K Overview A P T E R 2 Starting and Stopping ServersRequirements for starting servers Starting servers Default start-up parameters are stored underServer start-up parameters Starting servers Starting and Stopping Servers Changing start-up parameters Using the startserver command Starting servers when the operating system restartsUsing the monserver and backupserver commands Starting servers when the operating system restarts For IBM RS/6000 For HP-UX For Sun Solaris and Linux If your script is named sybstart, type the following ReturnsSo on. If your script is named sybstart, type the following Starting XP Server after initial installation Starting XP Server after initial installationWhere servername is the name of the Adaptive Server Stopping servers Enter Stopping Backup Server Stopping Monitor Server Using the kill commandStopping 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 srvbuildVariable Sample value Function Configuring the Operating System Configuring new servers with srvbuild Using the stty setting File descriptors and user connections Restoring correct permissionsFor AIX Restoring correct permissions For Sun Solaris For LinuxDisplaying current soft and hard limits Increasing the soft limit Increasing the hard limit Setting up the sample program to increase the hard limitFile descriptors and user connections Maxconnections Sample program Enabling asynchronous disk I/O Enabling asynchronous disk I/OThis 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 -FIssue the command Owner of the /dev/async directory Select Change/Show Characteristics of Asynchronous I/O Enable asynchronous disk I/OThis step is mandatory for IBM users Management Interface Tool Smit To display the current timeout period, enter Adjusting the client connection timeout periodTo display the current timeout value, enter Checking for hardware errors Checking for hardware errorsTo 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 settings Adaptive Server Default ConfigurationDefaults for Adaptive Server parameter settings Default value Defaults for Backup, Monitor, and XP Servers Default settingsServer 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 servicesSetting 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 Understanding the format of the interfaces file Components of an interfaces file entryTCP 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 fileUsing 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 Understanding IPv6 IPv6 supportAdaptive Server supports IPv6 technology IPv6 support IPv6 infrastructureIPv6 support Starting Adaptive Server Enterprise as IPv6-aware Troubleshooting TroubleshootingServer 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 For a list of attributes Interfaces file versus Ldap directory servicesLists the Sybase Ldap directory entries Sybase Ldap directory definitions Libtcl*.cfg file on Libtcl*.cfg file Enabling Ldap directory services Enabling Ldap directory servicesWhere 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 servicesAdding a server entry to the directory service using dsedit Multiple directory services Encrypting the password Encrypting the passwordReplace 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 setArabic character sets Character set Unilib required Description Lists the Cyrillic character set Lists the traditional Chinese character setLists the Eastern European character set Lists the Greek character set Lists the Japanese character set Lists the Hebrew character set10 lists the Korean character set 11 lists the Thai character set 14 lists the Vietnamese character set 13 lists the Unicode character set15 lists the Western European character set Conversions between server and client Character set conversion Available sort orders Sort ordersSort orders Your character set definition files At a later time using the sqlloc utilitySrt file for your language. Sort orders are stored 16 Sort orders available in Adaptive Server For utf8, see , Configuring Character Sets, Sort Orders, Language modules Installing a new language moduleMessage languages Localization directories LocalizationLocalization About the charsets directory About the directoryAbout 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 100 Sort orders17 Available sort orders Language or script Sort orders File name 18 lists the supported character sets and their Sybase name Character sets101 18 Sybase character set names 102 Charset utility 19 Keywords and options for charsets 103Keywords Options Description 104 Adaptive Server error logging Logging Error Messages and Events Enabling and disabling error logging Setting error log pathsSetting the Adaptive Server error log path Setting error log paths Managing messages Logging Error Messages and EventsLogging user-defined messages 107 Managing messages Logging auditing events108 Managing database devices Managing Adaptive Server DatabasesDevice requirements Managing database devices Creating files for database devices110 111 Managing Adaptive Server Databases 112 Audit system devices and databases Adding auditing Adding auditing Overview of audit installation114 Installing auditing Pre-installation tasks for auditing devicesAdding 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 withEnter the number of the device to delete Press return Spsyntax installation scripts Installing online help for Transact-SQL syntaxOnline syntax help spsyntax 121 Installing sybsyntax Default device for the sybsyntax databaseInstalling 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