Sybase DC35823-01-1500-04 manual

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150

Go to page of

A good user manual

The rules should oblige the seller to give the purchaser an operating instrucion of Sybase DC35823-01-1500-04, along with an item. The lack of an instruction or false information given to customer shall constitute grounds to apply for a complaint because of nonconformity of goods with the contract. In accordance with the law, a customer can receive an instruction in non-paper form; lately graphic and electronic forms of the manuals, as well as instructional videos have been majorly used. A necessary precondition for this is the unmistakable, legible character of an instruction.

What is an instruction?

The term originates from the Latin word „instructio”, which means organizing. Therefore, in an instruction of Sybase DC35823-01-1500-04 one could find a process description. An instruction's purpose is to teach, to ease the start-up and an item's use or performance of certain activities. An instruction is a compilation of information about an item/a service, it is a clue.

Unfortunately, only a few customers devote their time to read an instruction of Sybase DC35823-01-1500-04. A good user manual introduces us to a number of additional functionalities of the purchased item, and also helps us to avoid the formation of most of the defects.

What should a perfect user manual contain?

First and foremost, an user manual of Sybase DC35823-01-1500-04 should contain:
- informations concerning technical data of Sybase DC35823-01-1500-04
- name of the manufacturer and a year of construction of the Sybase DC35823-01-1500-04 item
- rules of operation, control and maintenance of the Sybase DC35823-01-1500-04 item
- safety signs and mark certificates which confirm compatibility with appropriate standards

Why don't we read the manuals?

Usually it results from the lack of time and certainty about functionalities of purchased items. Unfortunately, networking and start-up of Sybase DC35823-01-1500-04 alone are not enough. An instruction contains a number of clues concerning respective functionalities, safety rules, maintenance methods (what means should be used), eventual defects of Sybase DC35823-01-1500-04, and methods of problem resolution. Eventually, when one still can't find the answer to his problems, he will be directed to the Sybase service. Lately animated manuals and instructional videos are quite popular among customers. These kinds of user manuals are effective; they assure that a customer will familiarize himself with the whole material, and won't skip complicated, technical information of Sybase DC35823-01-1500-04.

Why one should read the manuals?

It is mostly in the manuals where we will find the details concerning construction and possibility of the Sybase DC35823-01-1500-04 item, and its use of respective accessory, as well as information concerning all the functions and facilities.

After a successful purchase of an item one should find a moment and get to know with every part of an instruction. Currently the manuals are carefully prearranged and translated, so they could be fully understood by its users. The manuals will serve as an informational aid.

Table of contents for the manual

  • Page 1

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

  • Page 2

    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[...]

  • Page 3

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

  • Page 4

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

  • Page 5

    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 ..............[...]

  • Page 6

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

  • Page 7

    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[...]

  • Page 8

    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[...]

  • Page 9

    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[...]

  • Page 10

    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 ?[...]

  • Page 11

    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[...]

  • Page 12

    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 .[...]

  • Page 13

    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[...]

  • Page 14

    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. [...]

  • Page 15

    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[...]

  • Page 16

    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 [...]

  • Page 17

    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 [...]

  • Page 18

    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 [...]

  • Page 19

    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 [...]

  • Page 20

    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. [...]

  • Page 21

    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[...]

  • Page 22

    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 [...]

  • Page 23

    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[...]

  • Page 24

    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 [...]

  • Page 25

    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[...]

  • Page 26

    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[...]

  • Page 27

    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. [...]

  • Page 28

    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, [...]

  • Page 29

    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 (~[...]

  • Page 30

    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[...]

  • Page 31

    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[...]

  • Page 32

    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[...]

  • Page 33

    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, [...]

  • Page 34

    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[...]

  • Page 35

    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[...]

  • Page 36

    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[...]

  • Page 37

    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 [...]

  • Page 38

    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 [...]

  • Page 39

    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 /[...]

  • Page 40

    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 [...]

  • Page 41

    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 [...]

  • Page 42

    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[...]

  • Page 43

    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[...]

  • Page 44

    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[...]

  • Page 45

    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 [...]

  • Page 46

    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[...]

  • Page 47

    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[...]

  • Page 48

    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 [...]

  • Page 49

    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[...]

  • Page 50

    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[...]

  • Page 51

    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 [...]

  • Page 52

    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[...]

  • Page 53

    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[...]

  • Page 54

    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[...]

  • Page 55

    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[...]

  • Page 56

    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[...]

  • Page 57

    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[...]

  • Page 58

    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[...]

  • Page 59

    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[...]

  • Page 60

    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[...]

  • Page 61

    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 ,[...]

  • Page 62

    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[...]

  • Page 63

    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[...]

  • Page 64

    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 [...]

  • Page 65

    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[...]

  • Page 66

    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[...]

  • Page 67

    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[...]

  • Page 68

    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[...]

  • Page 69

    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[...]

  • Page 70

    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[...]

  • Page 71

    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[...]

  • Page 72

    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[...]

  • Page 73

    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[...]

  • Page 74

    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[...]

  • Page 75

    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[...]

  • Page 76

    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[...]

  • Page 77

    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[...]

  • Page 78

    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[...]

  • Page 79

    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[...]

  • Page 80

    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 [...]

  • Page 81

    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[...]

  • Page 82

    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[...]

  • Page 83

    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[...]

  • Page 84

    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 [...]

  • Page 85

    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[...]

  • Page 86

    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[...]

  • Page 87

    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[...]

  • Page 88

    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[...]

  • Page 89

    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[...]

  • Page 90

    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 [...]

  • Page 91

    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 [...]

  • Page 92

    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[...]

  • Page 93

    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 [...]

  • Page 94

    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[...]

  • Page 95

    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[...]

  • Page 96

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

  • Page 97

    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[...]

  • Page 98

    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[...]

  • Page 99

    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[...]

  • Page 100

    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[...]

  • Page 101

    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)[...]

  • Page 102

    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[...]

  • Page 103

    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[...]

  • Page 104

    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[...]

  • Page 105

    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[...]

  • Page 106

    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[...]

  • Page 107

    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 [...]

  • Page 108

    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 [...]

  • Page 109

    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[...]

  • Page 110

    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[...]

  • Page 111

    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 [...]

  • Page 112

    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 [...]

  • Page 113

    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[...]

  • Page 114

    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[...]

  • Page 115

    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[...]

  • Page 116

    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 [...]

  • Page 117

    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[...]

  • Page 118

    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[...]

  • Page 119

    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[...]

  • Page 120

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

  • Page 121

    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[...]

  • Page 122

    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[...]

  • Page 123

    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[...]

  • Page 124

    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[...]

  • Page 125

    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- [...]

  • Page 126

    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[...]

  • Page 127

    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. [...]

  • Page 128

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

  • Page 129

    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[...]

  • Page 130

    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[...]

  • Page 131

    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 [...]

  • Page 132

    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[...]

  • Page 133

    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[...]

  • Page 134

    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[...]

  • Page 135

    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[...]

  • Page 136

    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[...]

  • Page 137

    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[...]

  • Page 138

    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[...]

  • Page 139

    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[...]

  • Page 140

    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[...]

  • Page 141

    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[...]

  • Page 142

    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[...]

  • Page 143

    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[...]

  • Page 144

    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,[...]

  • Page 145

    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[...]

  • Page 146

    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 [...]

  • Page 147

    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[...]

  • Page 148

    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[...]

  • Page 149

    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[...]

  • Page 150

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