Sybase DC35823-01-1500-04 Manual do Utilizador

Configuration GuideAdaptive Server® Enterprise15.0[ UNIX ]

x Adaptive Server Enterprise• Locking – describes how the various locking schemas can be used for improving performance in Adaptive Server.• Optimiz

Overview of localization support 84 Adaptive Server EnterpriseBy default, when Adaptive Server and Backup Server are installed on HP systems, the in

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 85• Hebrew – see Table 7-8 on page 87.• Japanese – see Table 7-9 on page

Overview of localization support 86 Adaptive Server EnterpriseTable 7-3: Simplified Chinese character setsTable 7-4 lists the traditional Chinese ch

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 87Table 7-7: Greek character setsTable 7-8 lists the Hebrew character set

Overview of localization support 88 Adaptive Server EnterpriseTable 7-12: Turkish character setsTable 7-13 lists the Unicode character set:Table 7-1

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 89Character set conversionBackup Server passes messages to Adaptive Serve

Sort orders 90 Adaptive Server EnterpriseWhen a localized client application connects to Adaptive Server, the server checks to see if it supports th

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 91Sort orders are located in sort order definition files (.srt files) tha

Sort orders 92 Adaptive Server EnterpriseTo see the sort orders that are available, use sqlloc to display the sort orders for the character sets you

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 93Language modulesIf you want Adaptive Server error messages to be displa

About This BookConfiguration Guide xi• Using Sybase Failover in a High Availability System – provides instructions for using Sybase’s Failover to

Localization 94 Adaptive Server EnterpriseFor example, if your client’s language is Latin, the Spanish language module is installed, and Spanish is

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 95About the directoryThe $SYBASE/locales directory contains a subdirector

Localization 96 Adaptive Server Enterprise• platform_locale is the platform-specific keyword for a locale. For acceptable values, see your operating

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 97Editing the locales.dat fileBefore beginning the edit, make a copy of t

Changing the localization configuration 98 Adaptive Server EnterpriseDuring the installation process and through reconfiguration, you can specify a

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 99Backup Server localization You can change the Backup server language an

Changing the localization configuration 100 Adaptive Server Enterprise6 Use your normal process on your UNIX system to reboot the server, usually by

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 101Character setsTable 7-18 lists the supported character sets and their

Changing the localization configuration 102 Adaptive Server Enterprisecharset utilityUse the charset utility to load character sets and sort orders

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 103Syntax charset[ -U username ][ -P password ][ -S server ][ -I interfac

xii Adaptive Server Enterprise• The Sybase Product Manuals Web site is an online version of the SyBooks CD that you can access using a standard Web

Changing the localization configuration 104 Adaptive Server Enterprise

Configuration Guide 105CHAPTER 8Logging Error Messages and EventsThis chapter describes how to use the error logging features of Adaptive Server.Adapt

Setting error log paths 106 Adaptive Server EnterpriseEnabling and disabling error loggingLogging to the Adaptive Server error log is always enabled

CHAPTER 8 Logging Error Messages and EventsConfiguration Guide 107Managing messagesWhen event logging is enabled, you can manage its functions in t

Managing messages 108 Adaptive Server EnterpriseLogging auditing eventsBy default, Adaptive Server does not log auditing events. However, you can us

Configuration Guide 109CHAPTER 9Managing Adaptive Server DatabasesThe administration of Adaptive Server databases includes both routine tasks and perf

Managing database devices 110 Adaptive Server Enterprise• The minimum device size for a 16K page server is 4MB• The maximum number of database devic

CHAPTER 9 Managing Adaptive Server DatabasesConfiguration Guide 111In this example, "size = 2048" tells the command to allocate 2048 “vir

Managing database devices 112 Adaptive Server Enterprise

Configuration Guide 113CHAPTER 10Adding Optional Functionality to Adaptive ServerThis chapter provides instructions for adding optional functionality

About This BookConfiguration Guide xiiiSybase EBFs and software maintenancev Finding the latest information on EBFs and software maintenance1 Poi

Adding auditing 114 Adaptive Server Enterprise• The audit trail, which consists of several audit devices and tables that you determine at configurat

CHAPTER 10 Adding Optional Functionality to Adaptive ServerConfiguration Guide 115Pre-installation tasks for auditing devicesDetermine the location

Adding auditing 116 Adaptive Server Enterprise1. Release directory: /usr/u/sybase 2. Configure a Server product3 Select Configure a Server Product.4

CHAPTER 10 Adding Optional Functionality to Adaptive ServerConfiguration Guide 1172 Select Sybsecurity Physical Device Name.To create a device for

Adding auditing 118 Adaptive Server EnterpriseList of devices for the audit tables:Logical name Physical name Segment name Table name Size6.Audit_01

CHAPTER 10 Adding Optional Functionality to Adaptive ServerConfiguration Guide 119where path_to_partition is the path to the raw partition for the

Adding auditing 120 Adaptive Server EnterpriseLogical name Physical name Segment name Tablename Size 6. Audit_01' /secret1/sybase_ dr/install/a

CHAPTER 10 Adding Optional Functionality to Adaptive ServerConfiguration Guide 1213. size of the new device (Meg): 54. Device size for auditing:53

Installing online help for Transact-SQL syntax 122 Adaptive Server EnterpriseYou can install any of these scripts, depending on the need for Sybase

CHAPTER 10 Adding Optional Functionality to Adaptive ServerConfiguration Guide 1233 Use a text editor to edit the script, if necessary, to change t

xiv Adaptive Server Enterprise• Syntax statements (displaying the syntax and all options for a command) appear as follows:sp_dropdevice [device_name

Installing online help for Transact-SQL syntax 124 Adaptive Server EnterpriseIf you have set the DSQUERY environment variable to the servername, you

Configuration Guide 125Symbols::= (BNF notation)in SQL statements xiv, (comma)in SQL statements xiv{} (curly braces)in SQL statements xiv() (parent

Index126 Adaptive Server EnterpriseCC shell 29case sensitivityin SQL xvchangingcharacter sets 83, 97languages 97sort order 97character devicesimpr

IndexConfiguration Guide 127sybsystemdb 5sysprocsdev 5, 6databases 90dbccdb 7devices 109master 5, 6model 5sample 6, 7sizes of 13specifications 13sybs

Index128 Adaptive Server Enterprisedevice files 109locales.dat 95localization 82localized error messages (.loc) 95runserver 19shared memory 27sort

IndexConfiguration Guide 129query port backup configuration 62query service type 56retry_attempt component 56servername component 56service_type c

Index130 Adaptive Server EnterpriseMmachine component in interfaces files 57masterinterfaces file 51, 58service type 56master database 5master dev

IndexConfiguration Guide 131paths, error log 106permissions 34required in environment variables 29restoring of 34PID. See process identificationpla

Index132 Adaptive Server Enterprisesort orders 90binary 91changing 97character sets and 90databases and 90definition files 90dictionary 91spaces i

IndexConfiguration Guide 133user-defined message 107utilitiesslloc 91Vvmstat commandHP-UX 43IBM RS/6000 44Sun Solaris 44WWindows Socketsdefault soc

About This BookConfiguration Guide xv• Examples of output from the computer appear as follows:pub_id pub_name city state ------- ----------------

Index134 Adaptive Server Enterprise

xvi Adaptive Server EnterpriseFor information about how Sybase supports accessibility, see Sybase Accessibility at http://www.sybase.com/accessibili

Configuration Guide 1CHAPTER 1IntroductionSybase Adaptive Server Enterprise for UNIX is a full-featured Adaptive Server that runs on the following pla

System-specific issues 2 Adaptive Server EnterpriseAdaptive Server also:• Manages multiple databases and multiple users• Keeps track of the data’s l

CHAPTER 1 IntroductionConfiguration Guide 3System user roles The Adaptive Server installation and setup process defines various user roles. Differe

DOCUMENT ID: DC35823-01-1500-04LAST REVISED: March 2007Copyright © 1987-2007 by Sybase, Inc. All rights reserved.This publication pertains to Sybase s

Environment variables 4 Adaptive Server Enterprise• DSQUERY – defines the Adaptive Server name that client programs attempt to connect to if no Adap

CHAPTER 1 IntroductionConfiguration Guide 5When using the source files: SYBASE.csh or SYBASE.sh, the following paths are prepended to the LIBPATH e

Adaptive Server devices and system databases 6 Adaptive Server Enterprise• The sample databases, pubs2 and pubs 3, are stored on the master device a

CHAPTER 1 IntroductionConfiguration Guide 7•pubs2 and pubs3 – provided as learning tools for Adaptive Server. pubs2 is used for most of the example

Adaptive Server devices and system databases 8 Adaptive Server EnterpriseAll the job, schedule, and scheduled job information, and data needed by th

CHAPTER 1 IntroductionConfiguration Guide 9Determining the location, type, and size of a database deviceAdaptive Server requires several database d

Adaptive Server devices and system databases 10 Adaptive Server EnterpriseWhen preparing a raw partition device, follow these guidelines: • Do not i

CHAPTER 1 IntroductionConfiguration Guide 11Client/server communicationAdaptive Server communicates with other Adaptive Servers, Open Server™ appli

Changing Adaptive Server configuration 12 Adaptive Server EnterpriseFigure 1-1: Communicating with a server using interfaces fileDuring installation

CHAPTER 1 IntroductionConfiguration Guide 13Languages other than U.S. EnglishIf you are running srvbuild in a language other than U.S. English, ver

ContentsConfiguration Guide iiiAbout This Book ...

Adaptive Server specifications 14 Adaptive Server EnterpriseMaximum number of users per database2146484223Maximum number of groups per database10321

CHAPTER 1 IntroductionConfiguration Guide 15Adaptive Server extended-limit capabilities vary by type of table and the database logical page size. T

Adaptive Server specifications 16 Adaptive Server EnterpriseLarger logical page sizes can contain more data. Table 1-5 lists the maximum data for ea

Configuration Guide 17CHAPTER 2Starting and Stopping ServersThis chapter describes how to start and stop Adaptive Server, Backup Server, Monitor Serve

Starting servers 18 Adaptive Server Enterprise• The system environment variables discussed in Chapter 1, “Introduction”• Access to SySAM licenses. F

CHAPTER 2 Starting and Stopping ServersConfiguration Guide 19Changing start-up parametersYou cannot change any of these default start-up parameters

Starting servers when the operating system restarts 20 Adaptive Server EnterpriseUsing the startserver command To start a server from the command li

CHAPTER 2 Starting and Stopping ServersConfiguration Guide 21For HP-UXIn HP-UX versions 10.0 and later, you cannot edit commands in the /etc/rc fil

Starting servers when the operating system restarts 22 Adaptive Server Enterprisesleep seconds_of_restNote To enable restart of a Backup Server whe

CHAPTER 2 Starting and Stopping ServersConfiguration Guide 23ln /etc/init.d/script_name /etc/rc#.d/S##script_nameFor Linux:Use ln -s to create

ContentsivAdaptive Server EnterpriseStopping Adaptive Server... 24Stopping Backup Server...

Starting XP Server after initial installation 24 Adaptive Server EnterpriseStarting XP Server after initial installationIf you install Adaptive Serv

CHAPTER 2 Starting and Stopping ServersConfiguration Guide 252Enter: 1> shutdown 2> goThe default for shutdown uses the with wait option, whi

Stopping servers 26 Adaptive Server EnterpriseThis is normal behavior. If a message indicates that Adaptive Server or Backup Server is waiting for p

CHAPTER 2 Starting and Stopping ServersConfiguration Guide 27kill pidwhere pid is the process identification of any dataserver or backupserver proc

Stopping servers 28 Adaptive Server EnterpriseIf Adaptive Server is configured with a memory size that is greater than the MAXSHMSEGSIZE parameter i

Configuration Guide 29CHAPTER 3Configuring the Operating System This chapter discusses the operating system configuration settings that you can adjust

Configuring new servers with srvbuild 30 Adaptive Server EnterpriseYou may want to verify that the Adaptive Server environment variables in Table 3-

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 315 In the Adaptive Server type screen, select the:• Server page size• Master device

Configuring new servers with srvbuild 32 Adaptive Server Enterprise• Port number7 To configure Monitor Server, select the following information in t

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 33• Sybmgmtdb database size• Transport type• Host name•Port number11 In the “Configur

ContentsConfiguration Guide v50How a client uses directory services ... 51Creating a directory services ent

Restoring correct permissions 34 Adaptive Server EnterpriseRestoring correct permissionsSybase software files and directories are installed with the

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 35For LinuxThe number of file descriptors per process is limited to 10,000. You can s

File descriptors and user connections 36 Adaptive Server Enterpriseulimit -Sn new_valuewhere n is the current value for the soft limit, and new_valu

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 37where program_name is the name of the compiled program, and master_device_name is t

Enabling asynchronous disk I/O 38 Adaptive Server Enterprise setuid(uid);/* run the program indicated as arguments to this program */ execv(*++argv,

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 394 At the UNIX prompt, execute the following statements as “root”. The user ID of th

Enabling asynchronous disk I/O 40 Adaptive Server Enterprise# ls /dev/asyn*idev/async /dev/asyncdskFor IBM AIXEnable asynchronous disk I/O.This step

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 41Adjusting the client connection timeout periodAdaptive Server uses the KEEPALIVE op

Checking for hardware errors 42 Adaptive Server EnterpriseFor Sun SolarisTo display the timeout value, enter: /usr/sbin/ndd -get /dev/tcp tcp_keepal

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 43For IBM RS/6000The errpt command includes several options for limiting the report t

ContentsviAdaptive Server EnterpriseAvailable sort orders... 90Language modules...

Monitoring the use of operating system resources 44 Adaptive Server Enterprise•The ps command provides a snapshot of accumulated CPU time and usage

CHAPTER 3 Configuring the Operating SystemConfiguration Guide 45•The ps command gives you an accurate snapshot of accumulated CPU time and usage fo

A sample C shell maintenance script 46 Adaptive Server EnterpriseNext, the script invokes an isql backup script for each database for which no 2500-

Configuration Guide 47CHAPTER 4Adaptive Server Default ConfigurationWhen you install or upgrade Adaptive Server, it includes some default parameter se

Default settings 48 Adaptive Server EnterpriseTable 4-2 lists the default settings for the Backup Server, Monitor Server, and XP Server. For more in

Configuration Guide 49CHAPTER 5Setting Up Communications Across the NetworkAdaptive Server can communicate with other Adaptive Servers, Open Server ap

How Adaptive Server determines which directory service entry to use 50 Adaptive Server EnterpriseServers also need network information. When a serve

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 513 Looks in directory services for an entry whose name matches the name

Supported directory drivers 52 Adaptive Server EnterpriseSupported directory driversThere are three supported drivers:• interfaces driver • Lightwei

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 53A client’s interfaces file does not need a master line. It functions co

Configuration Guide viiAbout This BookThis manual, the Configuration Guide, provides instructions for performing specific configuration tasks for Syba

Heterogeneous and homogeneous environments 54 Adaptive Server EnterpriseFigure 5-1: Establishing network connections in a heterogeneous environmentI

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 55Figure 5-2: Establishing network connections in a homogeneous environme

Understanding the format of the interfaces file 56 Adaptive Server Enterpriseservername retry_attempts delay_interval<newline> <tab>serv

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 57machine Network name or address of server’s host machine. You can use e

Creating a master interfaces file 58 Adaptive Server EnterpriseCreating a master interfaces fileA master interfaces file contains entries for all Sy

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 591 Concatenate the individual interfaces files.2 Make a copy of the file

Configuring interfaces files for multiple networks 60 Adaptive Server Enterprise2 In your interfaces file, use a text editor to add copies of the “m

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 61Using one network-independent DSQUERY nameIf uniform client DSQUERY nam

Configuring interfaces files for multiple networks 62 Adaptive Server EnterpriseYou can concatenate the original server name and the network name. F

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 63The following example shows how to configure a backup network that will

viii Adaptive Server Enterprise• Chapter 2, “Starting and Stopping Servers” describes how to start and stop Adaptive Server, Backup Server, Monitor

IPv6 support 64 Adaptive Server Enterprise• IPv6-enabled – an application that, in addition to being IPv6-aware, takes advantage of some IPv6 featur

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 65• RPC mechanisms• Job Scheduler Task / Agent session connection• Networ

Troubleshooting 66 Adaptive Server EnterpriseBefore starting Adaptive Server for IPv6-aware operations, make sure that your infrastructure is correc

CHAPTER 5 Setting Up Communications Across the NetworkConfiguration Guide 67200:00000:00002:2003/09/22 12:37:23.68 server Unable to initialize net

Troubleshooting 68 Adaptive Server Enterpriseinformation on how to bring XP Server up.XP Server cannot start because the port number may be in use b

Configuration Guide 69CHAPTER 6Using the Lightweight Directory Access Protocol as a Directory ServiceAdaptive Server uses directory services to establ

LDAP directory services versus the Sybase interfaces file 70 Adaptive Server EnterpriseThe LDAP server stores and retrieves information about:• Adap

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory ServiceConfiguration Guide 71• A network-based alternative to the traditio

LDAP directory services versus the Sybase interfaces file 72 Adaptive Server EnterpriseThe traditional interfaces file with TCP connection and a fai

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory ServiceConfiguration Guide 73In the example above, the entry describes an

About This BookConfiguration Guide ix• What’s New in Adaptive Server Enterprise? – describes the new features in Adaptive Server version 15.0, th

Enabling LDAP directory services 74 Adaptive Server EnterpriseYou should edit both the libtcl.cfg and the libtcl64.cfg files to ensure compatibility

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory ServiceConfiguration Guide 75• Add the LDAP URL under the [DIRECTORY] entr

Adding a server to the directory services 76 Adaptive Server EnterpriseAdding a server to the directory services Warning! Most LDAP servers have an

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory ServiceConfiguration Guide 77For example:ldap://huey:11389/dc=sybase,dc=co

Encrypting the password 78 Adaptive Server EnterpriseEncrypting the passwordEntries in the libtcl.cfg file are in human-readable format. Sybase prov

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory ServiceConfiguration Guide 79Migrating from the interfaces file to LDAPThe

Migrating from the interfaces file to LDAP 80 Adaptive Server Enterprise

Configuration Guide 81CHAPTER 7Customizing Localization for Adaptive Server This chapter provides information about Sybase localization support for in

Overview of localization support 82 Adaptive Server Enterprise• Latin America•Asia• Translated system messages – Adaptive Server includes language m

CHAPTER 7 Customizing Localization for Adaptive ServerConfiguration Guide 83Default character sets for serversThe default character set is the char