Document Outline

• Configuration Guide
  • About This Book
  • CHAPTER 1 Introduction
    • About Adaptive Server
    • System-specific issues
    • System user roles
    • Environment variables
    • Adaptive Server devices and system databases
      • The master device
      • The sybsystemdb device
      • The sysprocsdev device
      • Optional devices and databases
      • 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
    • Client/server communication
    • Changing Adaptive Server configuration
    • Languages other than U.S. English
    • Adaptive Server specifications
  • CHAPTER 2 Starting and Stopping Servers
    • 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
      • For HP-UX
      • For IBM RS/6000
      • For Sun Solaris and Linux
    • 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
  • CHAPTER 3 Configuring the Operating System
    • Setting environment variables
    • Configuring new servers with srvbuild
    • Using the stty setting
    • Restoring correct permissions
    • File descriptors and user connections
      • For HP-UX
      • For AIX
      • For Linux
      • For Sun Solaris
      • Displaying current soft and hard limits
      • Increasing the soft limit
      • Increasing the hard limit
      • Sample program
    • Enabling asynchronous disk I/O
    • Adjusting the client connection timeout period
      • For HP-UX
      • For IBM RS/6000
      • For Sun Solaris
      • For Linux
    • Checking for hardware errors
      • For HP-UX
      • For IBM RS/6000
      • For Sun Solaris
      • For Linux
    • Monitoring the use of operating system resources
      • For HP-UX
      • For IBM RS/6000
      • For Sun Solaris and Linux
    • A sample C shell maintenance script
  • CHAPTER 4 Adaptive Server Default Configuration
    • Default settings
  • CHAPTER 5 Setting Up Communications 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
    • Understanding the format of the interfaces file
      • Components of an interfaces file entry
    • 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
  • CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service
    • Overview
    • LDAP directory services versus the Sybase interfaces file
    • The libtcl*.cfg file
    • Enabling LDAP directory services
    • Adding a server to the directory services
    • Multiple directory services
    • Encrypting the password
    • Performance
    • Migrating from the interfaces file to LDAP
  • CHAPTER 7 Customizing Localization for 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
    • Character set conversion
      • Conversions between server and client
    • Sort orders
      • Available sort orders
    • 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
      • Sort orders
      • Character sets
      • charset utility
  • CHAPTER 8 Logging Error Messages and 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
  • CHAPTER 9 Managing Adaptive Server Databases
    • Managing database devices
      • Device requirements
      • Creating files for database devices
  • CHAPTER 10 Adding Optional Functionality to Adaptive Server
    • Adding auditing
      • Audit system devices and databases
      • Overview of audit installation
      • Pre-installation tasks for auditing devices
      • Installing auditing
    • Installing online help for Transact-SQL syntax
      • Online syntax help: sp_syntax
      • Default device for the sybsyntax database
      • Installing sybsyntax
  • Index