Databases 16K, Tables 16K | Sybase DC35823-01-1500-04 specification

Adaptive Server specifications

Databases	2K page	4K page	8K page	16K page
model database	3MB	6MB	12MB	24MB

tempdb database	4MB	6MB	12MB	24MB

sybsystemdb database	3MB	6MB	12MB	24MB

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
Tables		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		1958		4006		8102		16294
DOL table

User-visible row length		1960		4008		8104		16296
APL table

16	Adaptive Server Enterprise

Image 32

Sybase DC35823-01-1500-04 manual Databases 16K, Data limits for tables according to page size, Tables 16K

Contents

Adaptive Server Enterprise 15.0 Document ID DC35823-01-1500-04 Contents Adaptive Server Default Configuration Configuring new servers with srvbuildConfiguring the Operating System Contents Configuring the server for multiple network handlersStarting Adaptive Server Enterprise as IPv6-aware Conversions between server and client 105 109Adding Optional Functionality to Adaptive Server 113 125 About This Book Media devicesThis manual contains the following chapters Introduction is an overview of Adaptive Server Viii Related documents About This Book Adaptive Server Enterprise Other sources of information Xii Finding the latest information on component certifications Formatted using modified Backus Naur Form BNF notation Role to your MySybase profileProduct description to download the software Following sections describe conventions used in this manual For a command with more options Xiv Accessibility features Examples of output from the computer appear as followsSelect, and select are the same Information about these and other terms, see the Glossary Xvi If you need help Topic IntroductionAbout Adaptive Server System-specific issues System-specific issues Introduction System user rolesEnvironment variables Environment variables Sybase Adaptive Server devices and system databases Master device Sybsystemdb device Sysprocsdev deviceOptional devices and databases Adaptive Server devices and system databases Introduction Dsync option on by default for database device files Adaptive Server database devices Minimum Device Purpose Size Recommended size Choosing a raw partition Client/server communication Changing Adaptive Server configuration Changing Adaptive Server configuration Adaptive Server specifications Languages other than U.S. English Adaptive Server specifications Table specifications Data row and data page tables Maximum DOL table Number Column size Limits Columns 16KDatabase requirements for varying page sizes Databases 16K Tables 16K Databases 16KData limits for tables according to page size Requirements for starting servers A P T E R 2 Starting and Stopping ServersOverview Default start-up parameters are stored under Starting serversServer start-up parameters Starting servers Changing start-up parameters Starting and Stopping Servers Starting servers when the operating system restarts Using the startserver commandUsing the monserver and backupserver commands Starting servers when the operating system restarts For HP-UX For IBM RS/6000 For Sun Solaris and Linux So on. If your script is named sybstart, type the following ReturnsIf 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 Stopping Backup Server Enter Stopping servers Using the kill commandStopping Monitor Server Shutdown and shared memory files UID PID Ppid Stime TTY Time Comd Stopping servers Configuring the Operating System Setting environment variables Variable Sample value Function Configuring new servers with srvbuildSystem environment variables Configuring the Operating System Configuring new servers with srvbuild Using the stty setting Restoring correct permissions File descriptors and user connectionsFor AIX Restoring correct permissions For Linux For Sun SolarisDisplaying current soft and hard limits Increasing the soft limit File descriptors and user connections Setting up the sample program to increase the hard limitIncreasing the hard limit Sample program Maxconnections Enabling asynchronous disk I/O Enabling asynchronous disk I/OThis step is mandatory for HP users HP technical support To launch the Kernel Configuration use kcweb -F Select asyncdsk and change the next boot to staticIssue the command Owner of the /dev/async directory Enable asynchronous disk I/O Select Change/Show Characteristics of Asynchronous I/OThis step is mandatory for IBM users Management Interface Tool Smit To display the current timeout value, enter Adjusting the client connection timeout periodTo display the current timeout period, enter To display the timeout value, enter Checking for hardware errorsChecking for hardware errors Monitoring the use of operating system resources For Sun Solaris and Linux Sample C shell maintenance script Sample C shell maintenance script Adaptive Server Default Configuration Default settingsDefaults for Adaptive Server parameter settings Default value Server Default value Default settingsDefaults for Backup, Monitor, and XP Servers A P T E R 5 Setting Up Communications Across the Network Where to find interfaces file tasks and topics Type Interfaces file Task or topic See Setting Up Communications Across the Network How a client uses directory servicesCreating a directory services entry Contents of an interfaces file Supported directory drivers Heterogeneous and homogeneous environments Heterogeneous and homogeneous environments Chico Understanding the format of the interfaces file Components of an interfaces file entry Understanding the format of the interfaces fileTCP style entry looks like Components of an interfaces file Setting Up Communications Across the Network Using dsedit or dscp to create a master interfaces file Using a text editor to create a master interfaces fileUsing a text editor Creating a master interfaces file Configuring interfaces files for multiple networks Configuring the server for multiple network handlers Configuring the client connections Configuring interfaces files for multiple networks Using one network-independent Dsquery name Configuring for query port backup Adaptive Server supports IPv6 technology IPv6 supportUnderstanding IPv6 IPv6 support IPv6 infrastructureIPv6 support Starting Adaptive Server Enterprise as IPv6-aware Server fails to start TroubleshootingTroubleshooting Error when executing an ESP Investigating the port assignment 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 Interfaces file versus Ldap directory services For a list of attributesLists the Sybase Ldap directory entries Sybase Ldap directory definitions Libtcl*.cfg file on Libtcl*.cfg file Where the ldapurl is defined as Enabling Ldap directory servicesEnabling Ldap directory services Ldapurl variables Keyword Description Default For example Adding a server entry to the directory service using dsedit Adding a server to the directory servicesAdding a server to the directory services 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 Customizing Localization for Adaptive Server Overview of localization support Language modules Overview of localization support Default character sets for servers Customizing Localization for Adaptive Server Changing the default character set for servers Supported character sets Lists the Baltic character set Lists the simplified Chinese character setArabic character sets Character set Unilib required Description Lists the traditional Chinese character set Lists the Cyrillic character setLists the Eastern European character set Lists the Greek character set Lists the Hebrew character set Lists the Japanese character set10 lists the Korean character set 11 lists the Thai character set 15 lists the Western European character set 13 lists the Unicode character set14 lists the Vietnamese character set Character set conversion Conversions between server and client Sort orders Sort ordersAvailable sort orders At a later time using the sqlloc utility Your character set definition filesSrt file for your language. Sort orders are stored 16 Sort orders available in Adaptive Server For utf8, see , Configuring Character Sets, Sort Orders, Message languages Installing a new language moduleLanguage modules Localization LocalizationLocalization directories About the locales.dat file About the directoryAbout the charsets directory How client applications use locales.dat Changing the localization configuration Editing the locales.dat file Changing the localization configuration Adaptive Server localization Backup Server localization Configuring Adaptive Server for other character sets Sort orders 10017 Available sort orders Language or script Sort orders File name Character sets 18 lists the supported character sets and their Sybase name101 18 Sybase character set names Charset utility 102 Keywords Options Description 10319 Keywords and options for charsets 104 Logging Error Messages and Events Adaptive Server error logging Setting error log paths Enabling and disabling error loggingSetting the Adaptive Server error log path Setting error log paths Logging Error Messages and Events Managing messagesLogging user-defined messages 107 108 Logging auditing eventsManaging messages Device requirements Managing Adaptive Server DatabasesManaging database devices 110 Creating files for database devicesManaging database devices Managing Adaptive Server Databases 111 112 Adding auditing Audit system devices and databases 114 Overview of audit installationAdding auditing Pre-installation tasks for auditing devices Installing auditingAdding Optional Functionality to Adaptive Server Auditinit displays the following menu 116 Creating a device for an audit table 117 118 Creating a device for the audit database transaction log 119 Press Ctrl+A again. auditinit prompts with Enter y yesEnter the number of the device to delete Press return Installing online help for Transact-SQL syntax Spsyntax installation scriptsOnline syntax help spsyntax 121 Default device for the sybsyntax database Installing sybsyntaxInstalling online help for Transact-SQL syntax 122 123 124 Symbols Index Index 126 127 128 HP-UX 129 Ldap 130 131 Smit 132 133 134