Sybase DC35823-01-1500-04 manual

Configurati on Guide Adap tiv e Ser v er ® Enterprise 15.0 [ UNIX ][...]

DOCUMENT ID: DC35823 -01-150 0-04 LAST REVISED: March 2007 Copyright © 19 87-2007 by Sybase, I nc. All righ ts reserved. This publicatio n pertai ns to Sybase sof tware and to any sub sequent relea se until othe rwise indica ted in new e ditions or technic al not es. Information in thi s document is subject to change wi thout noti ce. T he softwar[...]

Content s Configu r ati on Gu ide iii About This B ook ................................................................................................................ .......... vii CHAPTER 1 Introduction ................ ............. ............. ............ .................... ........... 1 About Adaptive Server .............................[...]

Contents iv Adaptive Se rver Enterpri se Stopping Adaptive Server........................................................ 24 Stopping Backup Server.......................................................... 25 Stopping Monitor Server .......................................................... 26 Using the kill command ................................[...]

Conte nts Config uration G uide v 50 How a client uses directory services .............................................. 51 Creating a directory services entry ................................................. 51 Supported directory drivers ............................................................ 52 Contents of an interfaces file ..............[...]

Contents vi Adaptive Se rver Enterpri se Available sort orders ................................................................ 90 Language modules ......................................................................... 93 Installing a new language module ........................................... 93 Message languages ...........................[...]

Configu r ati on Gu ide vii About This Book This manual, the Configuration Guide , pr ovid es instructio ns for performing specific configuration ta sks for Sybase ® Adap tiv e Serve r® Enterpris e on UNIX platforms . The operating sys tem release levels for the UNIX platforms on which Adaptive Server is certified to ex ecute is in the installati[...]

viii Adaptiv e Server Enterprise • Chapter 2, “Starting an d Stopping Server s” descr ibes how t o start an d stop Adaptive Server , Backup Ser ver , Monitor Server , and XP Server . • Chapter 3, “Conf iguring the Ope rating Sy stem” describes h ow to set up your op erating syst em to work with Adaptiv e Server . • Chapter 4, “A dap[...]

About This Book Configu r ati on Gu ide ix • What’ s New in Adaptive S erver Enterprise? – descr ibes the ne w features in Adaptive Server version 15.0, th e system changes added to support those features, and changes that ma y af fect your existing applicatio ns . • ASE Repli cat or User’ s Guide – desc ribes ho w to use t he Ad apt iv[...]

x Adaptiv e Server Enterprise • Locking – describes ho w the various locking schem as can be used for impro ving per f orm a nce in Ada pti ve Serv er . • Optimizer and Ab stract Plans – describes how the optim izer processes queries and how abstract plans can be u sed to change some of the optimizer p lans. • Moni toring and Analyzing ?[...]

About This Book Configu r ati on Gu ide xi • Using Sybase Failo ver in a High A vailability S ystem – provides instruction s for usin g Sybase’ s Failover to configure an Adapti ve Serv er as a companion server in a high availability system. • Unified Agent and Agent Managemen t Console – Describes the Unified Agent, which provides runtim[...]

xii Adaptiv e Server Enterprise • The Sy base Produ ct Manuals W eb site is an online versio n of the SyBooks CD that you can access using a standard W eb browser . In addition to product manuals , you will find links to EBFs/Maintenan ce, T echnical Documents, C ase Management , Solved Cases, newsgroups, an d the Sybas e D evel op er N etw ork .[...]

About This Book Configu r ati on Gu ide xiii Sybase EBFs a nd sof twar e maintenanc e v Finding the l atest informatio n on EBFs and soft ware mainten ance 1 Point yo ur W eb browse r to the Syba se Supp ort Page at http://www.sybase.com/supp ort . 2 Select EBFs/Maintenance. If prompt ed, enter you r MySybase user name and password. 3 Select a prod[...]

xiv Adaptiv e Server Enterprise • Syntax statements (d isplaying the sy ntax and all options for a com mand) appear as follows: sp_dropdevice [ device_name ] For a command with more options: sele ct column_name from t able_name where search_conditions In syntax statements, keywords (co mmands) are in normal font and identifiers are in lowercase. [...]

About This Book Configu r ati on Gu ide xv • Ex ampl es of out p ut fr om t h e computer appear as follows: pub_id pub_name city state ------- --------------------- ---------- - ----- 0736 New Age Books Boston MA 0877 Binnet & Hardley Washington DC 1389 Algodata Infosystems Berkeley CA (3 rows affected) In this manual, most of the exam ples a[...]

xvi Adaptiv e Server Enterprise For information about how Sybase supports acces sib ility , see S ybase Accessibility a t http://w ww .sybase.c om/acces sibility . The Sybase Access ibility site includes links to inf orm atio n on Section 508 and W3C standards. If you need help Each Sybas e installati on that has purchased a su pport contract ha s [...]

Configu r ati on Gu ide 1 CHAPTER 1 Introduction Sybase Adaptive Server Enter prise for UNIX is a full- featured Adaptive Server that runs on t he following platforms: • HP-UX •I B M A I X •S u n S o l a r i s • Lin ux 32 -bit Note The instructions in this book assume that Ad aptive Ser v er is installed and running. Fo r information about [...]

System-specif ic issues 2 Adaptiv e Server Enterprise Adaptive Server also: • Manages multiple databases and m ultiple users • Keeps track of the data’ s locatio n on disks • Maintain s the mapping of log ical data descri ption to phys ical data storage • Maintains data and procedure caches in m emory Adaptive Server uses these auxiliary [...]

CHAPTER 1 Introduction Configu r ati on Gu ide 3 System user roles The Adaptive Server installation and se tup proc ess defines var ious us er rol es . Different user roles have different responsibilities and privileges. These us er roles clarify the way Adaptiv e Ser ver is to be integrated into your syst em: • Operating sys tem adm in istrator [...]

Environment variables 4 Adaptiv e Server Enterprise • DSQUER Y – defines the Adapt ive Server name t hat client progr ams attempt to connect to if no Adaptive Server is specified with a command line option. If DSQUER Y is not set, and you do not supply the Adaptive Server name with a co mmand line option, clients attempt to con nect to SYBASE. [...]

CHAPTER 1 Introduction Configu r ati on Gu ide 5 When using the s ource files: SYBASE.csh or SY BAS E. sh , the foll ow in g paths are prep ended to the LI BP A TH e nvir onm ent va ria ble : $SYBASE/$SYBASE_ASE/lib:$SYBASE/$SYBASE_OCS/ lib: $SYBASE/SYBASE_FTS/lib, etc. Adaptive Server devices and system dat ab ases Devices are files or por tions o[...]

Adaptive Server devices and system databases 6 Adaptiv e Server Enterprise • The sa m ple dat ab a se s, pubs2 and pubs 3 , are stored on the master device at installation, but should b e moved to a user -defined device af ter installation. Note For recov ery purpos es, Sybase reco mmends that yo u do not create other syst em or user databases o [...]

CHAPTER 1 Introduction Configu r ati on Gu ide 7 • pubs2 and pubs3 – provided as learning tools for Adaptive Server . pubs 2 is used for most o f the examples in the Adaptive Server d ocumentation; other examples use the pubs3 databa se. Both ar e available in U.S. English ver s i o ns of Ada ptive Serv er . • interpubs – contains French an[...]

Adaptive Server devices and system databases 8 Adaptiv e Server Enterprise All the job, schedule, an d scheduled jo b information, an d data needed by the Job Scheduler task for internal processing is stored in the sybmg mtdb database. Most access to da ta in the sybmgmtdb database is via stored procedu res. The stored pr ocedures make the data av [...]

CHAPTER 1 Introduction Configu r ati on Gu ide 9 Determining the loca tion, type, and siz e of a database device Adaptiv e Serv er requires several dat abase devices. T able 1-1 below shows baseline values for eac h of the devices. See the releas e bulletin for any last minute changes to these values. T able 1- 1: Adaptive Serv er databa se devices[...]

Adaptive Server devices and system databases 10 Adaptiv e Server Enterprise When preparing a raw partition device, follow thes e guidelines: • Do not initialize a database device on the partition that co ntains your Sybase installation softw are. Doing so destroys all existing files on that partition. • A raw partition designated for use by Syb[...]

CHAPTER 1 Introduction Configu r ati on Gu ide 11 Client/s erver commun icati on Adaptive Server commu nicates with ot her Adaptive Servers , Open Server™ applications (such as Back up Server), and client s oftware on your network. Clients can talk to one or more serv ers, and servers can communicate with other servers by remote procedure calls. [...]

Changing Adaptive Server configuration 12 Adaptiv e Server Enterprise Figure 1-1: Communicatin g with a server us ing interfaces file During installat ion, you us e the srvbu ild utility to create and configure a new server . The srvbuild process adds entries to the interfaces file for your new Adaptive Server , Backup Server , Moni t or S erv er, [...]

CHAPTER 1 Introduction Configu r ati on Gu ide 13 Language s other th an U. S. En glish If you are r unning srvbuild in a language o ther than U.S. Engli sh, verify that any input you provide uses a character set that is s upported by the us_engli sh character set. Note The us_english character set do es not support accent mark s, such as tildes (~[...]

Adaptive Server specifications 14 Adaptiv e Server Enterprise Maximum nu mber of users per da tabase 214648 4223 Maximu m num ber of grou ps pe r databa se 103219 3 T able specification s User ob je cts per da ta ba s e 2 31 – 25 5 Index es per tab le 250 (o ne clus te red ind ex) Rows per t a bl e Limit ed by ava il a ble storage Maximu m 2 32 C[...]

CHAPTER 1 Introduction Configu r ati on Gu ide 15 Adaptive Server extended-limit cap abi lities vary by type of table and the database logical page size. T ab le 1 - 2 lists the column and row lim its f or allpages-locked ( APL) tables. T able 1-2: A llpages-locked (APL) tables T able 1- 3 lists the colum n and row limits for data- only-locked (DOL[...]

Adaptive Server specifications 16 Adaptiv e Server Enterprise Larg er logical page sizes can contain mo re data. T abl e 1- 5 lists the maximum data for each lo gical page size. T able 1-5: Data limit s for tables acco rding to pa ge size model databa se 3MB 6 MB 12MB 24M B tempdb d ataba se 4MB 6MB 12MB 2 4MB sybs yst emdb database 3MB 6 MB 12MB 2[...]

Configu r ati on Gu ide 17 CHAPTER 2 S t arting and Stopping Servers This chapter de scribes how to start and s top Adaptive Server , Backup Server , Monitor Server , and XP Server . Overvi ew The methods described in th is ch apter are used to start Adap tive Server , Backup Server , and Monitor Serv er after a shutdown fo r database maintenance, [...]

Starting servers 18 Adaptiv e Server Enterprise • The s ys tem env ironment v a riabl es di s cus sed i n Chapter 1, “Introduction” • Access to SySAM licenses. For more information, see the Sybase So ftwar e Asset Management Us er ’ s Guide . The installation pr ogram creates the interfaces file an d system environm ent variable s when yo[...]

CHAPTER 2 Starting and Stopping Servers Configu r ati on Gu ide 19 Changing st art- up p arameters Y ou cannot chang e any of these default start-up parameters unless you directly edit the $SYBASE/$SYBASE_ASE/install/RUN _ server_na me file. Y ou can also specify additional star t-up parameters within th e $SYBASE/$SYBAS E_ASE/install/RUN_ server_n[...]

Starting servers when the operating system restarts 20 Adaptiv e Server Enterprise Using the startserver com mand T o start a server from the co mmand line, enter: $SYBASE/$SYBASE_ASE/install/starts erver [ -f RUN_server_name file ] where $SYBASE/$SYBASE_ASE/insta ll/startserver is the full path name of the startserver utility , and RUN_server_name[...]

CHAPTER 2 Starting and Stopping Servers Configu r ati on Gu ide 21 For HP-UX In HP-UX ver sions 10.0 and later , you cannot edi t commands in the /etc/r c file, so the System A dminist rator mu st cre a te a script that executes when the operati ng sy stem star ts or shut s down . For more i nformation ab out rc (1M) , see the HP-UX manual page. Y [...]

Starting servers when the operating system restarts 22 Adaptiv e Server Enterprise sleep seconds_of_rest Note T o enable res tart of a Backup Server when the operating system starts, add a Backu p Server start-up comm and to /etc/initta b . Use the p ath of the Backup Server RUN_ server_name file in this command. For Sun Solaris and Linux Before y [...]

CHAPTER 2 Starting and Stopping Servers Configu r ati on Gu ide 23 ln /etc/init.d/ script_name /etc/rc#.d/S# # script_name For Lin ux: Use ln -s to create symbolic links from th e script name to the app rop riate run c ont rol ( rc ) directory , rc # where # is the run level. Use syntax like the following: ln -s /etc/init.d/script_name /etc/rc#.d /[...]

Starting XP S erver after initial in stallation 24 Adaptiv e Server Enterprise S t arting XP Server af ter initial inst allation If you install Adaptiv e Server and XP Server in the same build session, srvbuild automatically adds inf ormation about th e XP Server to th e sysservers table of Adaptive Server . If you install XP Server in a different [...]

CHAPTER 2 Starting and Stopping Servers Configu r ati on Gu ide 25 2E n t e r : 1> shutdown 2> go The default for shutdown uses the with wait o p tion , which allows Ad apt ive Server to finish executing SQL statemen ts or procedures, perf orm a checkpoint in each database, d isable new logins, and perform other s hutdown tasks. Issuing t he [...]

Stopping servers 26 Adaptiv e Server Enterprise This is no rmal behavior . I f a message indicates that Adaptive Server o r Backup Server is waiting fo r processes to complete, and you must stop Adap tive Server or Backup Server immediately , use shutdown with n owait , which neither waits for currently executing s tatem ents to finish, nor perform[...]

CHAPTER 2 Starting and Stopping Servers Configu r ati on Gu ide 27 kill pid where pid is the process identification of an y dataserver or backupserv er process, as de termined by the showserve r command. Killin g one engine for a particular Adaptive Server k ill s all engines for that server . I f m o r e t h a n o n e A d a p t i v e S e r v e r i[...]

Stopping servers 28 Adaptiv e Server Enterprise If Adaptive Server is config ured with a memory size that is gr eater than the MAXSHMSEGSIZE parameter in t he oper ating system then Adaptive Server may create additional shar ed memory segm ents and for every additional shared memory s egment that it creat es, an additional file with SERV ER_NAME.sr[...]

Configu r ati on Gu ide 29 CHAPTER 3 Configuring the Operating System This chapter discusses the operating system configuratio n se ttin gs that you can adjust after inst alling or up grading Adaptive Serv er . Unles s stated otherwise, the information pertains to all s upp orted UNI X plat forms. Setting environment variab les Note As part of the [...]

Configuring new servers with srvbuild 30 Adaptiv e Server Enterprise Y ou may want to verif y that the Adap tive Server environmen t variables in T able 3-1 are set correctly . T o check the current value of env iro nment variables, enter the fo llowing command at t he operating sys tem prompt: env T ab le 3-1 describes the system environment varia[...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 31 5 In the Adaptive Server type screen, select the: • Server page size • Master device path • Master device size • Master datab ase size • Sybsyst empro cs devi ce pat h • Sybsystemproc s device size • Syb system procs data base si ze •E r r o r l o g • T ransport[...]

Configuring new servers with srvbuild 32 Adaptiv e Server Enterprise • Por t number 7 T o configure Monitor Server , select the following info rmati on in the Monitor Server screen: • Maximum numb er of connections •E r r o r l o g • Confi guration fil e • Shared mem ory directo ry • T ransport type • Hos t name • Por t number 8 In [...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 33 • Sybmgmtdb dat abas e size • T ransport type • Host name •P o r t n u m b e r 1 1 In the “Config ure Self Management...” screen , you can enter: • Enable Self Management • Self Manage ment user name • Self Managem ent user pass word If yo u cha nge t he Se lf M[...]

Restoring correct permissions 34 Adaptiv e Server Enterprise Restoring correct p ermissions Sybase software files and directories are installed with the co rrect access permis sions. If y ou notice th at the permissions are no longer correct, you can restore the co rrect permissions with the s cript setperm _all , located in the $SYBASE/$SYBASE_ AS[...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 35 For Linux The numb er of fi le de sc ript ors per p roce ss i s li mit ed t o 10, 000 . Y ou can set the number of f ile descr iptors usi ng ulimit . For Sun Solaris For Sun Solaris, you can set both soft and hard limits f o r file descriptors. The soft limit can be increased up [...]

File descriptors and user connections 36 Adaptiv e Server Enterprise ulimit -Sn new_value where n is the current value for the soft limit, and new_ valu e is the val ue to which you want to increase the soft limit. Note Y ou can use the preceding commands in your RUN_s erver_n ame file to increase the hard an d soft limits. The RUN_server_name file[...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 37 where pr ogram_name is the n ame of the compiled pro gram, and master_device_name is the full path of Adaptive Server ’ s master device. Instead of typ ing the command at the operating system prompt, yo u can add pr ogram_name p receding the dataserver comman d line in the Adap[...]

Enabling asynchronous disk I/O 38 Adaptiv e Server Enterprise setuid(uid); /* run the program indicated as arguments to this program */ execv(*++argv, argv); } For additional information on user connections , see the System Adminis tration Guide . Enabling asynch ronous d isk I/O For HP-UX This step i s mandator y for HP users. T o improve I/O perf[...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 39 4 At the UNIX prompt, execute the following s tatements as “root”. The user ID of the u ser who is starting Adaptiv e Server and B ackup Server m ust be the ow ne r of th e /dev/async directory . HP-UX 1 1.23 This step is manda tory for H P users. T o improve I/O perfor mance[...]

Enabling asynchronous disk I/O 40 Adaptiv e Server Enterprise # ls /dev/asyn* idev/async /dev/asyncdsk For I BM AI X Enable asyn chronous disk I/O. This step i s mandatory fo r IBM users. Enable asynchro nous I/O by adjusting the kernel parameters, using the System Management Interf ace T ool (SMIT): 1 Enter “smit” at the UNIX prom pt. 2 From t[...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 41 Adjusting th e client connection time out period Adaptive Server uses the KEEP ALIVE option of th e TCP/IP pr otocol to detect clients that are no longer active. When a co nnection to a client is inactive for a per iod of tim e (the timeout pe rio d ), th e ope ra ting system sen[...]

Checking for hardware errors 42 Adaptiv e Server Enterprise For Sun Solaris T o display the timeout value, enter: /usr/sbin/ndd -get /dev/tcp tcp_kee palive_interval T o reduce the timeout per iod to 15 minutes (900, 000 ms.), ent er: /usr/sbin/ndd -set /dev/tcp tcp_ke epalive_interval 900000 For Linux T o display the timeout value, enter: /sbin/sy[...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 43 For IBM RS/6000 The errpt command includes s everal options for limitin g the report to events that match certain criteria. Use the errpt command on a regular bas is. If errors appear , use the diagnostic tool dia g to check your memory and dis ks. Or use the System Management In[...]

Monitoring the use of operating syste m resources 44 Adaptiv e Server Enterprise •T h e ps command pr ovides a snapshot of accumulated CPU time and usage for in dividual pro cesses. •T h e time command can be useful i n determin ing the vario us user , system, and real-t ime resources used ov er a complete run. For details about these too ls, s[...]

CHAPTER 3 Configuring the Operating System Configu r ati on Gu ide 45 •T h e ps command gives you an accurate snapshot o f accumulated CPU time and usage f or individual processes. This can be very helpful in determining the dataserver -, engine-, and process -specific loading. •T h e time command can be useful in determining the various user ,[...]

A sample C shell maintenance s cript 46 Adaptiv e Server Enterprise Next, the script in vokes an isql backup script for each database for which no 2500-level er rors occurred and adds the “Backing up database_ name ” li ne to dbcc_mail.out . Fo r example, the script master .backup backs up the master datab ase: use master go dump database maste[...]

Configu r ati on Gu ide 47 CHAPTER 4 Adaptive Server Default Configuration When you install or up grade Adaptive Server , it includes some default parameter settings and a few of its aux iliary programs. After installing and testing this “default” Adaptive Ser ver, you can configure it to you r system’ s needs and install other optional featu[...]

Default settings 48 Adaptiv e Server Enterprise T ab le 4-2 lists the default s ett i ngs fo r the Backup Ser ver , Monitor Ser ver , and XP Server . For more inf ormation about these servers, see “Introduction” on page 1. T able 4-2: Defaults for Back up, Monitor , and XP Serve rs • Chara cter set HP – Roman 8 IBM – ISO 8859-1 Sun – I [...]

Configu r ati on Gu ide 49 CHAPTER 5 Setting Up Communications Across the Network Adaptive Server can co mmunicate wi th other Adaptive Servers, Op en Server applications, and client software across a network. Clients can communicate with one or more servers , and servers can communicate with other servers via remote procedure calls. Director y ser[...]

How Adaptive Server determines which directory service entry to use 50 Adaptiv e Server Enterprise Servers also need n etwork infor mation. W h en a server starts up, it looks in its interfaces file to determin e where to listen for client connection req uests. In addition, Adaptive Server can take on a client role when it makes remote procedure ca[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 51 3 Looks in directo ry services for an entry whose name match es the name found in the s teps above. 4 It uses th e network infor mation provi ded by the di rectory se rvices entry it has found to listen fo r client connections. How a client uses directory services Whe[...]

Supported directory drivers 52 Adaptiv e Server Enterprise Supported directory dri vers There are three sup ported drivers: • interfaces driv er • Lightweight Directory Services driver . • Cell D irectory Servi ce (CDS) provided by Distribu ted Computi ng Enviro nmen t (DCE) This remainder of this chapter describ es the interfaces file an d p[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 53 A client’ s interfaces file do es not need a master line. It functions corr ect ly with only a query line. If your si te has multiple inst allati ons If you have more than one Adaptive Server installation, each server’ s interfaces file should contain inf orm atio[...]

Heterogeneous and homogeneous environments 54 Adaptiv e Server Enterprise Figure 5-1: Establishing network conn ections in a heterogeneous envir onm ent If both a client a nd a server are run ning under UNIX, the s ame interfaces file is valid for both. Fig u re 5-2 illustrates how clients and Adaptive Servers running in a hom ogeneous enviro nment[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 55 Figure 5-2: Est ablishing ne twork connec tions in a ho mogeneous environm ent Underst anding the format o f the interfac es file The following rules app ly to the fo rmat of interfaces file entries: • Each Adaptive Server has only one entr y , although there may be[...]

Understanding the format of the interfaces file 56 Adaptiv e Server Enterprise servername retry_attempts delay_in terval <newline> <tab> service_type api protocol de vice address filter <newline> <tab>ha_failover servername <newli ne> A TCP style entry looks like: servername retry_attempts delay_in terval <newline&g[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 57 machine Netw ork n ame or addres s of serve r ’ s ho st mach i ne. Y ou can use e ither the host name or Intern et a ddress. Maxi mum si ze of en try is 32 bytes. T o determine the host nam e of a mach ine, log in to that mach ine and enter: /bin/h ostnam e device T[...]

Creating a master interfaces file 58 Adaptiv e Server Enterprise Creating a master in terfaces file A master int erfac es f ile contains entr ies for all Sybase s ervers on the network. It can be used with every server an d client connected to the network. By distributing copies of a master interfaces file, you can ens ure that all Sybase product s[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 59 1 Concatenate the individual interfaces fi les. 2 Make a copy of the file. 3 Use an ASCII text editor to modify the copy of the concaten ated file. Note When you manually edit an interfaces file, be sure that, for each entry , each line following the firs t lin e begi[...]

Configuring interfaces files for multiple networks 60 Adaptiv e Server Enterprise 2 In your interfaces file, use a text ed itor to add copies of the “master” line for your Adap tive Server; one for each addi tional interface you want the server to listen on. 3 Include a unique host name on each line to configure a network hand ler for each netw[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 61 Using one network-independent DSQUER Y name If uniform client DSQUER Y naming is important, you can make the necessary changes in the network addressi ng of the clients in the interfaces file. Y ou can install separate Sybase ins tallation dir ectories and distinct in[...]

Configuring interfaces files for multiple networks 62 Adaptiv e Server Enterprise Y ou can concatenate the original serv er name and the network na me. For example, if your serv er is named PRODUCTION, you could choose the names PRODUCTION_network1 and PRODUC TION_netwo r k2. 2 Do one of the follo wing: • For PC client s, use sqledit to create mu[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 63 The followi ng example sh ows how to configure a back up network that will be used only if the normal connection fails. Th e primary network is “corporate network ” and backup is “eng ineering network.” # PRODUCTION server with two network listen ers PRODUCTIO[...]

IPv6 support 64 Adaptiv e Server Enterprise • IPv6-enabled – an ap plication th at, in addition to being IPv6-aware, take s advantage of some IPv6 features. • IPv 6-required – an applicat ion that re q uires some IPv6 features and cannot operate over IPv4. IPv6 Inf ras t ru ctur e: IPv6 infrastructure Dual S tack infrastructure implemen ts [...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 65 • RPC mechanisms • Job Sched uler T ask / Agent sess ion connect ion • Ne t work Ho st AP I • UDP Message s upport for sybsendmsg • Component Integration Ser v ices connectivity • Host / name res olving • XML URL conn ection handler • Auditing for clie[...]

Troubleshooting 66 Adaptiv e Server Enterprise Before star ting Adaptive Server for IP v6 -aware operations, make sure that your infrastructure is correctly set up. Once your operating sy stem is correctly configured , an IPv6 connect ion hand ler can be configu red and enabled. Configur ing and enabl ing the IPv6 conne ction han dler requires addi[...]

CHAPTER 5 Setting Up Communications Across the Network Configu r ati on Gu ide 67 2 00:00000:00002:2003/09/22 12:37:23.68 server Unable to initialize network 0 00:00000:00002:2003/09/22 12:37:23.68 kernel ninit: All master network listeners have failed. Shutting down. 00:00000:00002:2003/09/22 12:37:23.68 kernel ueshutdown: exiting 00:00000:00016:2[...]

Troubleshooting 68 Adaptiv e Server Enterprise information on how to bring XP Ser ver up. XP Server cannot start b ecause the port number may be in use by anoth er process. Use the nets tat com mand des cri bed i n the prev io us sec tio n to determine if the p ort number specified for XP Server is in us e. If you find no pr oc e sse s usin g th e [...]

Configu r ati on Gu ide 69 CHAPTER 6 Using the Lightw eight Directory Access Protocol as a Directory Service Adaptive Server us es directory serv ices to establish client and RPC connections over the Internet. This chapter provides information abo ut using LDAP directory services to estab lish connections. Overview Lightweight Direct ory Access Pro[...]

LDAP directory services versus the Sybase interfaces file 70 Adaptiv e Server Enterprise The LDAP server stor es and retrieves information abou t: • Adapt ive Server , such as IP add ress, port number , and network prot ocol • Security mech anisms and filters • High availability companion server n a me The LDAP server can be configured with t[...]

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service Configu r ati on Gu ide 71 • A network-based alternative to th e traditional Sybase interf aces file • A single, hierarchical view of information, including us ers, software, resources, net work s, fil es, and so on T able 6-1 highlights the dif ferences betw een t[...]

LDAP directory services versus the Sybase interfaces file 72 Adaptiv e Server Enterprise The traditional interfaces f ile with TCP connection and a failover machine looks like: master tcp ether huey 5000 query tcp ether huey 5000 hafailover secondary An example of an LDAP entry with TCP and a failover machine looks like: dn: sybaseServername=foobar[...]

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service Configu r ati on Gu ide 73 In the example abo ve, the entry des cri bes an Adaptive Serv er named “fo obar” listening on a TCP connecti on with a port number of 5000. This entity also specifies a retry coun t of 12 (times) and a retry delay of 3 0 (seconds). Once a[...]

Enabling LDAP directory services 74 Adaptiv e Server Enterprise Y o u should edit both the libtcl.cfg and the libtcl64.cf g files to ensure compatibility between 32- and 64-b it applicati ons. The defaul t libtcl.cfg file is lo cated in $SYBASE/$S YBASE_OCS/config . If LDAP is specified in the libtcl.cfg file, the interfaces file is not used. Note [...]

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service Configu r ati on Gu ide 75 • Add the LDA P URL under the [D IRECTOR Y] entry . See T able 6-3 for supp orted LDAP UR L values. W arning! The LDAP URL must be on a single line. libtcl.cfg ldap+libsydblad.so ldap://host:port/ditbase? ?scope??bindname=username password [...]

Adding a server to the directory services 76 Adaptiv e Server Enterprise Adding a server to the directory services Wa r n i n g ! Mo st L DAP serv ers h ave an ldapadd utili ty fo r adding director y entries. Sybase recommends you use dsedit instead since it has bui lt- in semant ic c heck s tha t ge ner ic too ls do not p rov ide. Each server entr[...]

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service Configu r ati on Gu ide 77 For example: ldap://huey:11389/dc=sybase,dc=com??one Note Microsoft Internet Explorer d oes not recognize LDAP URLs. For more i nformation ab out dscp , see the Open C lient/Server C onfiguration Guide , in the 1 1.1.x Generic Co llection at [...]

Encrypting the password 78 Adaptiv e Server Enterprise Encrypting the p asswo rd Entries in th e libtcl.cfg file are in human-r eadable format. Sybase pro vides a pwdcrypt util ity for basic password encr yption. pwdcrypt is a simple algorith m that, wh en applied to keybo ard input, ge nerates an encrypted value that can be substituted for t he pa[...]

CHAPTER 6 Using the Lightweight Directory Access Protocol as a Directory Service Configu r ati on Gu ide 79 Migr ating f rom the interfaces file t o L DAP There is no di rect method to upgrade an existin g server using t he interfaces file to one that uses lightweight directory services. T o upgrad e a previous release of Adaptive Server to Adaptiv[...]

Migrating from the interfaces file to LDAP 80 Adaptiv e Server Enterprise[...]

Configu r ati on Gu ide 81 CHAPTER 7 Customizing Localization for Adaptive Server This chapt er provides informati on about Sy base localizati on support for international installati ons, in cluding configuring lan guag es, character sets, and s ort ord er . For more information, see the Sys tem Adminis tra tion Guide . Overview o f localization su[...]

Overview of localization support 82 Adaptiv e Server Enterprise • Latin America •A s i a • T ransla ted system messages – Adaptive Server includes langu age modules for : • Brazilian Portugu ese • Chines e (Simplif ied) •F r e n c h •G e r m a n • Japanese • Korean • Polish •S p a n i s h •T h a i • T ransla ted document[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 83 Default character se t s for servers The default character set is the character set in which data is encoded and stored on the Adaptive Server databases. Changing the de fault lan guage and character set W arning! Make all changes to the character set and so rt or de[...]

Overview of localization support 84 Adaptiv e Server Enterprise By default, when Adap tive Server and Backup Server ar e installed on HP systems, the installati on installs the character set files f or ROMAN8, which suppor ts the W estern Eur opean languages . Changing the default character set for servers Y ou can select any character set as the d[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 85 • Hebrew – se e T able 7-8 on page 87. • Japanese – see T able 7-9 on page 87. • Korean – s ee T able 7-10 on page 87. • Thai – see T able 7-11 on page 87. • T urkish – see T able 7-12 on page 88. • Unicod e (which su pports over 650 lang uages)[...]

Overview of localization support 86 Adaptiv e Server Enterprise T able 7-3: Simplified C hinese cha racter sets T able 7-4 lis ts the tradition al Chinese character set: T able 7-4: Tra ditional Chines e character set T able 7-5 lis ts the Cyrillic character set: T able 7-5: Cyrillic charac ter sets T able 7-6 lis ts the Eastern European char acter[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 87 T able 7- 7: Greek ch aracter se ts T able 7- 8 lists the Hebrew character s et: T able 7- 8: Hebrew cha racter set s T able 7- 9 lists the Japanes e character set: T able 7- 9: Japanese character se ts T able 7- 10 lists the Korean character set: T able 7- 10: Korea[...]

Overview of localization support 88 Adaptiv e Server Enterprise T able 7-12 : Tur kish charac ter sets T able 7-13 lis ts the Unicode character set: T able 7-13 : Unicode cha racter set T able 7-14 lis ts the V ietnamese character s et: T able 7-14 : V ietnamese characte r set T able 7-15 lis ts the W estern European character set: T able 7-15 : We[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 89 Character set conversion Backup Server passes messages to Adaptive Server in the client’ s language and in the Adaptive Server ch aracter set. Adaptive Server then co nverts the messages and issues them in the client’ s language and character set. Keep the follow[...]

Sort orders 90 Adaptiv e Server Enterprise When a localized client application c onnects to Adaptive Serv er , the server checks to see if it s upports the client’ s language and character set. • If Adaptive Server supports the language, it automa tically perf orm s all character set conversions and displays its messages in the client’ s lang[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 91 Sort orders are located in sort ord er definition files ( .srt files) that accompany your character set def inition files. Note A vailable sort orders vary accord ing to the character set ins talled on Adaptive Server . Y ou can see the available sort orders for you [...]

Sort orders 92 Adaptiv e Server Enterprise T o see the sort orders that are available, use sqlloc to display the sort ord ers for the character s ets you plan to us e. For more infor mation on unicode so rt orders for utf_8 , see Chapter 7, “Configuring Ch aracter Sets, Sort Orders, and Languages ” in the Syst em Administratio n Guide . Dictio [...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 93 Language module s If you w ant Adaptive Server error messag es to be di splayed in a language ot her than U.S. English ( us_english), you must install the ap propriate la nguage module. When you i nstall a new l ang uage m odu le, install at ion au to mati cal ly l o[...]

Localization 94 Adaptiv e Server Enterprise For example, if your client’ s language is Latin, the Sp anish lang uage module is installed, an d Spanish is sp ecified as the Adap tiv e Server default language, the client receives messages in Spanish. Localization By default, the Adaptive Server and B ackup Server configurations use the English loca[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 95 About the directory The $SYBASE/locales directory contains a subd irectory for each available language. Each lang uage subdirector y co ntains a subdirectory fo r each character set available with that languag e. •T h e .loc files in these su b directories en able [...]

Localization 96 Adaptiv e Server Enterprise • platf orm_locale is the platform-specific keyw ord for a locale. For acceptable values, see y our operating system docum entation. When the locale being defined as the default for the site, platf orm_local e is “default.” • syb_ language i s the name o f the language directory to be used from w [...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 97 Editing t he locales.da t file Before beginning th e edit, make a copy of the original file, in case you h ave problems with the result ing edited version. T o edit the locales.dat file: 1 Open the locales.dat file co py in a text editor . 2 Find the section enclosed[...]

Changing the localizati on configuration 98 Adaptiv e Server Enterprise During the inst allation process and thr oug h reco nfiguration, yo u can specify a diff erent language, char acter set, and sort or der . Adaptive Server localiza tion Each language us es about 2MB o f database space per modu le. If necessary , u s e the alter database command[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 99 Backup Server loca lization Y ou can ch ange the Backup server languag e and character s et by modifying the RUN_<backup_server_n ame> file. See the Utility Guide for more i nformation on the backupserver command ar guments. Configuring Adapti ve Se rver for ot[...]

Changing the localizati on configuration 100 Adaptiv e Server Enterprise 6 Use yo ur normal pro cess on your UNIX syst em to reboot the server , usual ly by invoki ng one of th e RUN_xxx scripts from $SYBASE/$SYBASE_ ASE/install . 7 The server s t arts, rebuild s all the system indexes, then shuts down. Restart a second time to bring the server up [...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 101 Character sets T able 7- 18 lists the supported c haracter sets and their Syb ase name. T able 7- 18: Sybase c haracter set n ames Scandi navian These sort ord ers work only with CP 850. Dictionary ord er , case sen si tive, acce nt sensiti v e s candi ct.srt 47 Dic[...]

Changing the localizati on configuration 102 Adaptiv e Server Enterprise charset utility Use the charset utility to load character sets and sort orders into Adapti ve Server . If you are using charset to load the defau lt character set and sort or der , this should be done only at the tim e of installatio n. T o change the default character set and[...]

CHAPTER 7 Customizing Localization for Adaptiv e Server Configu r ati on Gu ide 103 Syntax charset [ -U username ] [ -P password ] [ -S server ] [ -I interfaces ] [ -v version ] sort_order [ charset ] T able 7- 19: Keywords and options f or charsets Keywords and options Description -U If you are not al read y logged in to your opera tin g syste m a[...]

Changing the localizati on configuration 104 Adaptiv e Server Enterprise[...]

Configu r ati on Gu ide 105 CHAPTER 8 Logging Error Messages and Event s This chapter d escribes how to use the er ror logging fe atures of Adaptive Server . Adaptive Se rver error logging Each time Adaptive Server starts, it writ es inform ation to a local error log file, called the Adaptive Server error log: $SYBASE/$SYBASE_ASE/install/server _na[...]

Setting error log paths 106 Adaptiv e Server Enterprise Enabling and disabling er ror logging Logging to the Adaptive Server erro r lo g is always enabled. However , when you create or modify a spe cific user -defined message, y ou can set it to be omitte d from the log. See “Logging user-defined messages” on pa ge 107. Setting error log p aths[...]

CHAPTER 8 Logging Error Messages and Events Configu r ati on Gu ide 107 Managing message s When event logging is enab led, you can manage its func tions in the f ollowing ways: •U s e sp_addmessa ge or sp_a ltermessa ge to control whether a specific user -defined message is log ged in the Adaptive Server error log . For the complete syntax for sp[...]

Managing messages 108 Adaptiv e Server Enterprise Logging auditing events By default, Adaptive Serv er does not log aud iting events. However , you can use sp_c onfigure parameters to specify whether Ad aptive Server is to log auditing events, such as logins, to the Adaptive Server error log. Possible parameters and values are: • log audit logo n[...]

Configu r ati on Gu ide 109 CHAPTER 9 Managing Adaptive Server Dat abases The administration of Adaptive Server databa se s i ncl ud es b oth r outin e tasks and perf ormance and tuning co nsiderations. •T h e System Adminis tration Gui de dis cusses m ost of the administrative tasks in detail. •T h e Performance and T uning Guide provides in- [...]

Managing database devices 11 0 Adaptive Server Ente rprise • The mini mum device size for a 16K page server is 4MB • The max imum number of database devi ces is 2,14 7,483,647. H owever , Adaptive Server m ust retain a descrip tion of each device in memory , so in practice this num ber is limited by y our s ys t em’ s memory . Y our operating[...]

CHAPTER 9 Managing Adaptive Server Databases Configu r ati on Gu ide 111 In this example, "size = 2048" tells th e command to allocate 2048 “virtual” pages to the device. A vir tual page is 2048 by tes, so this command creates a 4MB device. The example command does not specify a device number , instead letting the server c hoose one. [...]

Managing database devices 11 2 Adaptive Server Ente rprise[...]

Configu r ati on Gu ide 11 3 CHAPTER 10 Adding Optional Functional ity to Adaptive Server This chapter provides instructions for adding optional fu ncti onality to Adaptive Server: After you have installed the Sybase p roducts on your system, s ee the product documentation for configu ration and admi nistration i ssues. Addi ng au diting Audi t ing[...]

Adding auditing 11 4 Adaptive Server Ente rprise • The audit trail, which consists of several audit devices and tables that you determine at configuration time • The syslogs trans action log device, wh ich stores transaction logs The sybs ecu rity devic e and dat abase The sybsecurity device stores the sybsecurity database. The sy bsecurity dat[...]

CHAPTER 10 Adding Optional Functional ity to Adaptive Server Configu r ati on Gu ide 11 5 Pre-installation t asks for auditing devi ces Determine the location of th e raw devices for the sybsecurity , syslogs , and sysaudits table devices. Y ou will need to provide thi s in form ation later . Sybase reco mmends that you: • Configure your s ystem [...]

Adding auditing 11 6 Adaptive Server Ente rprise 1. Release directory: /usr/u/sybase 2. Configure a Server product 3 Select Configure a Ser ver Product. 4 Select Adaptive Server . 5 Select Configure an Existing Sy base Server . 6 Select the server to config ure. 7 Provide the SA pas sword for the server you selected. 8 From the Sybase Se rver Confi[...]

CHAPTER 10 Adding Optional Functional ity to Adaptive Server Configu r ati on Gu ide 11 7 2 Select Sybsecurity Physical Device Name. T o create a device for an audit table: 1 Enter the full p ath of the physical dev ice (raw partition) that you located in “Pre-installation tasks for auditing de vices” on page 115. Enter the physical name of the[...]

Adding auditing 11 8 Adaptive Server Ente rprise List of devices for the audit table s: Logical name Physical name Seg ment name Table name Size 6.Audit_01' secret1/sybase_dr/insta ll/aud1.dat’ sysaudits_01 5 5 T o add multiple audit devices, repeat step s 1– 6. Y ou can add as many as eight devi ces. Sybas e recommends adding three or mor[...]

CHAPTER 10 Adding Optional Functional ity to Adaptive Server Configu r ati on Gu ide 11 9 where path_to_part ition is the path to the raw partitio n for the de vice. 3 Enter the fu ll path name of a physical device. If you en ter an operating system file name, th e following warning appears: WARNING: '/secret1/sybase_dr/install/audlog' is[...]

Adding auditing 120 Adaptiv e Server Enterprise Logical name Physical name Segment name Table name Size 6. Audit_01' /secret1/sybase_ dr/install/aud1.dat’ sysaudits_01 5 7. Audit_02' /secret1/sybase_ dr/install/aud2.dat' sysaudits_02 5 8. auditlog /secret1/.../auditlog.dat logsegment syslogs 2 7 When you are ready to execute the au[...]

CHAPTER 10 Adding Optional Functional ity to Adaptive Server Configu r ati on Gu ide 121 3. size of the new device (Meg): 5 4. Device size for auditing:5 3 Select each remaining entry you want to change. 4 Press Ct rl+A to save th e new entries. Inst alling onlin e help for T ransact-SQL syn t ax This section provides ins tr ucti ons fo r installin[...]

Installing online hel p for Transact-SQL syntax 122 Adaptiv e Server Enterprise Y ou can install any o f these script s, depend ing on the need for Sybase information o n your server . The first script you execute creates the sybsyntax database and the needed table s and indexes . Any scri pts that you execu te after the first one add to the existi[...]

CHAPTER 10 Adding Optional Functional ity to Adaptive Server Configu r ati on Gu ide 123 3 Use a text editor to edit the scr ipt, if necessary , to change the d efault device from the master devi ce to the device created in step 1. For infor mation on the default device, s ee “Defaul t device for the sybs ynt ax dat aba se” on page 122. • Com[...]

Installing online hel p for Transact-SQL syntax 124 Adaptiv e Server Enterprise If you h ave set the DSQ UER Y environment var iable to the servername , you can rep lace the server name with $DSQUER Y . 5 T o ensure that you have i nstalled the sybsyntax database and that it is working cor rectly , use isql to log in to the server on which you inst[...]

Config uration G uide 125 Symbol s ::= (BNF notation ) in SQL statem ents xiv , (comma) in SQL statem ents xiv {} (c urly br aces) in SQL statem ents xiv () (parentheses) in SQL statem ents xiv [ ] (square brackets) in SQL statem ents xiv A accented letters 13, 91 Adap tiv e Ser ver character set , changi ng 83 character set s 89 client com municat[...]

Index 126 Adaptiv e Server Enterpri se C C shell 29 case sensitiv ity in SQL xv changin g character sets 83, 97 langu ages 97 sort orde r 97 character devi ces improv ing I/ O pe rfor mance o n 38, 39 character sets 89 accented letters in 13 cha nging 83, 84 , 97 client selection of 84 code conv ersi ons a nd 89 config urin g 99 converting betwee n[...]

Index Config uration G uide 127 sybs ystemd b 5 sysprocsdev 5, 6 databases 9 0 dbccdb 7 devices 10 9 master 5, 6 model 5 sample 6, 7 sizes of 13 specific ations 13 sybsecurity 7 sybsystem procs 6, 13 temp db 5 dataserv er utility 27 dbcc che c ks tor age, d ataba se for 7 dbcc error messages 45 dbccdb dat ab ase 7 debug s ervic e ty pe 56 Dec-Kanji[...]

Index 128 Adaptiv e Server Enterpri se devi ce fi les 109 locales.d at 95 localiz ation 82 localized error mes sages (.loc) 95 runserver 19 shared memory 27 sort order definitio n (.srt) files 90 forma tting for loc al date, time, and c urrency 95 French sa mple d ataba se 7 G Germ a n sa mple da ta ba s e 7 global i zation support , Sybase 47, 81,[...]

Index Config uration G uide 129 query port back up c onfig uration 62 query serv ice type 56 retry_at te mpt compo nent 56 servernam e com pon ent 56 service_typ e componen t 56 spaces in 55 tab characters in 55 unique elemen ts in entr ies 59 used by clien ts 51 internat ional systems supp ort fo r 81 Sybas e sup port f or 81 interpubs samp le dat[...]

Index 130 Adaptiv e Server Enterpri se M machine compo nent in interface s files 57 master interfaces file 51, 58 service type 56 master da ta bas e 5 master devi ce 5, 9 maxfiles kernel parameters 34 maxfile s_lim kernel parameters 34 mbuf po ols 44 messages hardware errors 4 2 messages, sel ec ting l a ng uage for 93 mode l da taba s e 5 Monitor [...]

Index Config uration G uide 131 paths, err or lo g 106 per missi ons 34 required in en vironmen t variable s 2 9 restori ng of 34 PID. See pro cess identification platform s, supp orted v ii platform-specific locale names 95 port comp onent in interfac es files 5 7 port numbers and interface s files 59 PPID. See parent process iden tifica tio n pri[...]

Index 132 Adaptiv e Server Enterpri se sort orde rs 90 binary 91 changin g 97 character sets and 90 databases and 90 definitio n files 90 diction ary 91 spaces in in terfaces files 55 Span ish dictio nary so rt orders 92 SPX n etwork protoc ol 11, 56 square brac kets [ ] in SQL stateme nts xiv srt files 90 srvbuild u tility 12 starting servers from[...]

Index Config uration G uide 133 user-defined mess age 107 utilitie s slloc 91 V vmstat comma nd HP-UX 43 IBM RS/ 6 000 44 Sun Sol aris 44 W Wind ow s Soc k ets default socket 47, 48 X XP Server default conf iguratio n 48 XP Se rver, starting 17 xp_cmdsh ell co mma nd 17[...]

Index 134 Adaptiv e Server Enterpri se[...]