Contents | Sybase DC35823-01-1500-04 specs

Contents

About This Book	..........................................................................................................................	vii
CHAPTER 1	Introduction	1
	About Adaptive Server	1
	System-specific issues	2
	System user roles	3
	Environment variables	3
	Adaptive Server devices and system databases	5
	The master device	5
	The sybsystemdb device	6
	The sysprocsdev device	6
	Optional devices and databases	6
	dsync option on by default for database device files	8
	Determining the location, type, and size of a database device . 9
	Client/server communication	11
	Changing Adaptive Server configuration	12
	Languages other than U.S. English	13
	Adaptive Server specifications	13
CHAPTER 2	Starting and Stopping Servers	17
	Overview	17
	Requirements for starting servers	17
	Starting servers	18
	Server start-up parameters	18
	Using a RUN_server_name file	19
	Using the startserver command	20
	Using the monserver and backupserver commands	20
	Starting servers when the operating system restarts	20
	For HP-UX	21
	For IBM RS/6000	21
	For Sun Solaris and Linux	22
	Starting XP Server after initial installation	24
	Stopping servers	24

Configuration Guide

iii

Image 3

Sybase DC35823-01-1500-04 manual Contents

Contents

15.0 Adaptive Server Enterprise Document ID DC35823-01-1500-04 Contents Configuring new servers with srvbuild Configuring the Operating SystemAdaptive Server Default Configuration Conversions between server and client ContentsConfiguring the server for multiple network handlers Starting Adaptive Server Enterprise as IPv6-aware 125 105109 Adding Optional Functionality to Adaptive Server 113 Introduction is an overview of Adaptive Server About This BookMedia 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 notationRole 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 featuresExamples of output from the computer appear as follows Select, and select are the same If you need help Xvi Introduction About Adaptive ServerTopic System-specific issues System-specific issues System user roles Environment variablesIntroduction Sybase Environment variables Master device Adaptive Server devices and system databases Adaptive Server devices and system databases Sybsystemdb deviceSysprocsdev 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 tablesMaximum DOL table Number Column size Limits Columns 16K Database requirements for varying page sizes Databases 16K Data limits for tables according to page sizeTables 16K A P T E R 2 Starting and Stopping Servers OverviewRequirements for starting servers Starting servers Default start-up parameters are stored underStarting 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 restartsUsing the startserver command Using the monserver and backupserver commands For IBM RS/6000 For HP-UX For Sun Solaris and Linux Returns If your script is named sybstart, type the followingSo on. If your script is named sybstart, type the following Stopping servers Starting XP Server after initial installationStarting XP Server after initial installation Where servername is the name of the Adaptive Server Enter Stopping Backup Server Using the kill command Stopping Monitor ServerStopping servers UID PID Ppid Stime TTY Time Comd Shutdown and shared memory files Stopping servers Setting environment variables Configuring the Operating System Configuring new servers with srvbuild System environment variablesVariable Sample value Function Configuring the Operating System Configuring new servers with srvbuild Using the stty setting Restoring correct permissions Restoring correct permissionsFile descriptors and user connections For AIX Increasing the soft limit For LinuxFor Sun Solaris Displaying current soft and hard limits Setting up the sample program to increase the hard limit Increasing the hard limitFile descriptors and user connections Maxconnections Sample program HP technical support Enabling asynchronous disk I/OEnabling asynchronous disk I/O This step is mandatory for HP users Owner of the /dev/async directory To launch the Kernel Configuration use kcweb -FSelect asyncdsk and change the next boot to static Issue the command Management Interface Tool Smit Enable asynchronous disk I/OSelect Change/Show Characteristics of Asynchronous I/O This step is mandatory for IBM users Adjusting the client connection timeout period To display the current timeout period, enterTo 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 value Adaptive Server Default ConfigurationDefault settings Defaults for Adaptive Server parameter settings Default settings Defaults for Backup, Monitor, and XP ServersServer 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 How a client uses directory services Creating a directory services entrySetting 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 Components of an interfaces file Components of an interfaces file entryUnderstanding 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 fileUsing 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 IPv6 support Understanding IPv6Adaptive Server supports IPv6 technology IPv6 infrastructure IPv6 supportIPv6 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 Sybase Ldap directory definitions Interfaces file versus Ldap directory servicesFor a list of attributes Lists the Sybase Ldap directory entries 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 Performance Encrypting the passwordEncrypting 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 setLists the simplified Chinese character set Arabic character sets Lists the Greek character set Lists the traditional Chinese character setLists the Cyrillic character set Lists the Eastern European character set 11 lists the Thai character set Lists the Hebrew character setLists the Japanese character set 10 lists the Korean character set 13 lists the Unicode character set 14 lists the Vietnamese character set15 lists the Western European character set Conversions between server and client Character set conversion Sort orders Available sort ordersSort orders 16 Sort orders available in Adaptive Server At a later time using the sqlloc utilityYour character set definition files Srt file for your language. Sort orders are stored For utf8, see , Configuring Character Sets, Sort Orders, Installing a new language module Language modulesMessage languages Localization Localization directoriesLocalization About the directory About the charsets 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 Language or script Sort orders File name Sort orders100 17 Available sort orders 18 Sybase character set names Character sets18 lists the supported character sets and their Sybase name 101 102 Charset utility 103 19 Keywords and options for charsetsKeywords Options Description 104 Adaptive Server error logging Logging Error Messages and Events Setting error log paths Setting error log pathsEnabling and disabling error logging Setting the Adaptive Server error log path 107 Logging Error Messages and EventsManaging messages Logging user-defined messages Logging auditing events Managing messages108 Managing Adaptive Server Databases Managing database devicesDevice requirements Creating files for database devices Managing database devices110 111 Managing Adaptive Server Databases 112 Audit system devices and databases Adding auditing Overview of audit installation Adding auditing114 Auditinit displays the following menu Pre-installation tasks for auditing devicesInstalling 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 withEnter y yes Enter the number of the device to delete 121 Installing online help for Transact-SQL syntaxSpsyntax installation scripts Online syntax help spsyntax 122 Default device for the sybsyntax databaseInstalling 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