Sybase DC35823-01-1500-04 16

Adaptive Server specifications

16 Adaptive Server Enterprise

Larger logical page sizes can contain more data. Table 1-5 lists the maximum data for each logical page size.

Table 1-5: Data limits for tables according to page size

model database 3MB 6MB 12MB 24MB

tempdb database 4MB 6MB 12MB 24MB

sybsystemdb database 3MB 6MB 12MB 24MB

Databases 2K page 4K page 8K page 16K page

Tables 2K page 4K page 8K page 16K page

Bytes per index key 600 1250 2600 5300

User-visible row length

DOL table 1958 4006 8102 16294

User-visible row length

APL table 1960 4008 8104 16296

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