Sybase MAC OS X manuel d'utilisation

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

Aller à la page of

Un bon manuel d’utilisation

Les règles imposent au revendeur l'obligation de fournir à l'acheteur, avec des marchandises, le manuel d’utilisation Sybase MAC OS X. Le manque du manuel d’utilisation ou les informations incorrectes fournies au consommateur sont à la base d'une plainte pour non-conformité du dispositif avec le contrat. Conformément à la loi, l’inclusion du manuel d’utilisation sous une forme autre que le papier est autorisée, ce qui est souvent utilisé récemment, en incluant la forme graphique ou électronique du manuel Sybase MAC OS X ou les vidéos d'instruction pour les utilisateurs. La condition est son caractère lisible et compréhensible.

Qu'est ce que le manuel d’utilisation?

Le mot vient du latin "Instructio", à savoir organiser. Ainsi, le manuel d’utilisation Sybase MAC OS X décrit les étapes de la procédure. Le but du manuel d’utilisation est d’instruire, de faciliter le démarrage, l'utilisation de l'équipement ou l'exécution des actions spécifiques. Le manuel d’utilisation est une collection d'informations sur l'objet/service, une indice.

Malheureusement, peu d'utilisateurs prennent le temps de lire le manuel d’utilisation, et un bon manuel permet non seulement d’apprendre à connaître un certain nombre de fonctionnalités supplémentaires du dispositif acheté, mais aussi éviter la majorité des défaillances.

Donc, ce qui devrait contenir le manuel parfait?

Tout d'abord, le manuel d’utilisation Sybase MAC OS X devrait contenir:
- informations sur les caractéristiques techniques du dispositif Sybase MAC OS X
- nom du fabricant et année de fabrication Sybase MAC OS X
- instructions d'utilisation, de réglage et d’entretien de l'équipement Sybase MAC OS X
- signes de sécurité et attestations confirmant la conformité avec les normes pertinentes

Pourquoi nous ne lisons pas les manuels d’utilisation?

Habituellement, cela est dû au manque de temps et de certitude quant à la fonctionnalité spécifique de l'équipement acheté. Malheureusement, la connexion et le démarrage Sybase MAC OS X ne suffisent pas. Le manuel d’utilisation contient un certain nombre de lignes directrices concernant les fonctionnalités spécifiques, la sécurité, les méthodes d'entretien (même les moyens qui doivent être utilisés), les défauts possibles Sybase MAC OS X et les moyens de résoudre des problèmes communs lors de l'utilisation. Enfin, le manuel contient les coordonnées du service Sybase en l'absence de l'efficacité des solutions proposées. Actuellement, les manuels d’utilisation sous la forme d'animations intéressantes et de vidéos pédagogiques qui sont meilleurs que la brochure, sont très populaires. Ce type de manuel permet à l'utilisateur de voir toute la vidéo d'instruction sans sauter les spécifications et les descriptions techniques compliquées Sybase MAC OS X, comme c’est le cas pour la version papier.

Pourquoi lire le manuel d’utilisation?

Tout d'abord, il contient la réponse sur la structure, les possibilités du dispositif Sybase MAC OS X, l'utilisation de divers accessoires et une gamme d'informations pour profiter pleinement de toutes les fonctionnalités et commodités.

Après un achat réussi de l’équipement/dispositif, prenez un moment pour vous familiariser avec toutes les parties du manuel d'utilisation Sybase MAC OS X. À l'heure actuelle, ils sont soigneusement préparés et traduits pour qu'ils soient non seulement compréhensibles pour les utilisateurs, mais pour qu’ils remplissent leur fonction de base de l'information et d’aide.

Table des matières du manuel d’utilisation

  • Page 1

    Quick Inst allation Guide Adaptive Server Enterpr ise 12.5.x Mac OS X[...]

  • Page 2

    DOCUMENT ID: 39123-01-12 50-01 LAST REVISED: Se ptember 20 02 Copyright © 19 89-2002 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 this document is s ubject to change withou t notic e. The softw[...]

  • Page 3

    Content s iii About This B ook ................................................................................................................ ............ v CHAPTER 1 Installing Adaptive S erver ............ ............. ................... ............. ..... 1 System requirements ................................................................[...]

  • Page 4

    Contents iv Sybase subagent..................................................................... 29 MIB files................................................................................... 29 Configuring trap generation from Adaptive Server .................. 30 Troubleshooting the installation ..................................................[...]

  • Page 5

    v About This Book This guide, Installation Guide Syba se Adap tive Ser ver En terprise, provi des : • An over view of th e Sybase® A daptive Ser ver™ Enterprise installation infras tructure • Instruct ions for i n stalling and upgrad ing Adaptive Server , and installing Backup Server ™ , Monitor Server , XP Server™, jConnect™ for JDBC?[...]

  • Page 6

    vi • T ransact-SQL User ’ s Guide – do cuments T ransact-SQL, S ybase’ s enhanced vers ion of the rel ational dat abase la nguage. This manual ser ves as a textb ook for beg inning users of the database manag ement system. This manual also contains descri ptions of the pubs2 and pubs 3 samp le datab ases . • Syste m Adm i nis trat i o n G[...]

  • Page 7

    About This Book vii • Using Sybase Failo ver in a High A vailability System – provid e s instruction s for usin g Sybase’ s Failover to confi gur e an Adapti ve Server as a companion server in a high availability system. • Using Adaptive Server Distributed T ransaction Management Featu r es – explains how to config ure, use, and troublesh[...]

  • Page 8

    viii • The T echnical Libr ary Product Manuals W eb site is an HTML v ersion of the T echnical Library CD that yo u can access us ing a standard W eb browser . In addition to product m anuals, you will find links to the T echnical Documents W eb site (formerl y known as T ech Info L ibrary), the Solved C ases page, and Sybas e/Powers oft newsg ro[...]

  • Page 9

    About This Book ix Conventions The f ollowing style conventions are us ed in this manual: • In a sample screen display , commands you should enter exactly as shown are given in: this font • In a sample screen di s play , words that you should replace with the appropriate value for your in stallation are sh own in : this font • In the regul ar[...]

  • Page 10

    x[...]

  • Page 11

    1 CHAPTER 1 Inst alling Adaptive Server This documentation describes the step s to install Adaptive Server on Mac OS X, and con tains brief descri ptions o f some of the content of t h is release. This release is sup ported via a newsgr oup, as well as throu gh the terms in your pur chase agreement. Y ou can reach the newsgr oup at news://forum s.s[...]

  • Page 12

    Preinstallation system setup 2 • master de vice p ath nam e – /Applications/Sybase/Sys tem/devices/master .dat • master device size – 10 0MB • sybsystempro cs device pathname – /Applications/Sybase/Sys tem/devices/sybprocs.dat • sybsystempro cs device size – 160MB • Server p age size – 4096 bytes • Server default char acter se[...]

  • Page 13

    CHAPTER 1 Installing Adaptiv e Serv er 3 • Click localh ost under the machines director y . • Choose Duplicate. • Click on loca lhost copy under values and chan ge it to your machine’ s name. • Apply the ch anges. 3 T est the update by executing: ping ‘hostname -s’ Inst alling from a CD If you are ins talling from a CD, in sert the CD[...]

  • Page 14

    Installation 4 3 Usi ng a bro wser , go to the W eb site and do wnl oad the di sk i mag e to yo ur desktop. For some browsers , downloading a disk image also caus es the disk image to be mounted automatically . If this does not happen with your browser w hen the downl o ad i s co mple te, do uble-click on the disk i mage. The Finder will moun t the[...]

  • Page 15

    CHAPTER 1 Installing Adaptiv e Serv er 5 Figure 1-1: In tr oduction page 2 Y ou see the Read M e notes, whi ch you can print , save, or read by using t he scroll bar on the rig h t. These notes are important, and Sybase reco mmends that you mak e a hard co py of th ese notes by clicking t he Print button. Select Continue when finished. Figure 1-2: [...]

  • Page 16

    Installation 6 Figure 1-3: Software license agreement 4 T o continue with the installation, click Agr ee to accept the terms of the license agreement. If you select Disagree, t he installer reverts to the previo us window . Figure 1-4: Accepting the software license ag r eement 5 Fro m the next w indow , select Macinto s h HD (which may v ary on so[...]

  • Page 17

    CHAPTER 1 Installing Adaptiv e Serv er 7 Figure 1-5 : Select a destination 6 Click Install to pro ceed. If you try to install this pack ag e a second time, this button changes to Up grade. If you click Upg r ade, the software is copied from the package in to the release location at /Ap p lications/Sybas e , but no server is initi alized and started[...]

  • Page 18

    Installation 8 Figure 1-6: Easy install 7 The insta l l er n ow per fo rms a se ries o f task s, incl udin g so me preinstallation checks and writing files to th e selected disk volume. Figure 1-7: Proce ssing Adaptive Serv er 8 The installer is n ow running Sybase scrip ts that initial ize a database, i nstall Sybase pro v ided stored procedures, [...]

  • Page 19

    CHAPTER 1 Installing Adaptiv e Serv er 9 Figure 1-8: Proc essing databases a nd stored procedures 9 Y ou are finished. Sybase Adaptive Serv er Enterpris e is now ready for your use. Click on Close, and the inst aller exits. A record of the installation has been saved in /Library/Receipts /Syba se_ASE_12502.pkg .[...]

  • Page 20

    Installation on X serve 10 Figure 1-9: Finishing the ins tallation Inst allation o n Xserve T o install Adaptive Server on Xserve running in a “headless” mode (without a monitor ,) you have two options: • Use the command line in staller . Place the disk image containi ng the installation package on a disk volume accessible to Xserve. Enter : [...]

  • Page 21

    CHAPTER 1 Installing Adaptiv e Serv er 11 Release conten t s This distributio n is provided with a Developer ’ s Edition license that enables single-CPU operation, and restricts the number of concurrent users to 25. All other available features are au tomatica lly en abled, and there is no expiration period. T o enable usage auth orized by your p[...]

  • Page 22

    Post-installation tas k s 12 • Backup Server • XP Server • ODBC driver from Open Link Software, Inc. Features not yet availabl e Some of the JAdaptive Serve r features provided fo r other UNIX platfor ms are not available yet on Mac OS X, includ ing: •E J B S e r v e r • SSL s upport • LDAP s upport • ASE Replicator (newly in trod uce[...]

  • Page 23

    CHAPTER 1 Installing Adaptiv e Serv er 13 • V iewin g servers runn ing on y our network • V erifying that you can co nnect to servers • Connecting to Adaptiv e Se rver via Sybase Central • Setting the Sy stem Administr ator passw ord • St arting and stopping Adapt ive Ser ver • Reinitializing Adaptiv e Server • Installing sam p le dat[...]

  • Page 24

    Entering license key s 14 Figure 1-10 : License Entry icon 2 Y ou are asked w hether y ou have a Sy base Software Asse t Management Certificate. Y ou should have the printed certificate(s) in front of yo u. Click Y es to continue. If you do not have li cense certificates to enter, click No and proceed to the next section, “Entering Network Licens[...]

  • Page 25

    CHAPTER 1 Installing Adaptiv e Serv er 15 Figure 1-1 2: License key entry screen 4 Y ou are asked whether or not you a hve ad ditional license certificates to enter . Y ou will have additional certificates if you purchased any optional features. If you h ave additional certificates click Y es and repeat the previous step to enter the in formatio n.[...]

  • Page 26

    Environment variables 16 Figure 1-13 : Network license ma nager If you are u sing a network license host to server as a central point to check licenses out, ente r the machin e name and port numb er for the Network License Manager licen se daemon. Th e default port num ber is 29722. A simplified license is written out that contains ifnormatio n to [...]

  • Page 27

    CHAPTER 1 Installing Adaptiv e Serv er 17 Viewing servers tha t are running o n your network Adaptive Server , along with its associ ated Backu p Server and XP Server , registers with the n etwork using Rendezv ous technology , s o that any Rendezvous client can discover what servi ces are available. W e have provided a service discovery tool for S[...]

  • Page 28

    Verifying that you can connect to servers 18 Figure 1-15: Serv er Discove ry text file Y ou can use its Config uratio n menu item to automatically update the Sy base interfaces file fo r those servers that you have hig hlighted in the window . In addit i on, the s ample progr am ctos , in /Applicatio ns/Sybase/System /OCS- 12_5 /sample/ srvlibra ry[...]

  • Page 29

    CHAPTER 1 Installing Adaptiv e Serv er 19 Figure 1-16: j ISQL icon Attempt to connect when y ou see the login s creen: In t he lo gin w ind ow , e n t e r: • Username – sa • Password – l eave blank • Hostname – server name _A SE • Portnumber – 1 1222[...]

  • Page 30

    Verifying that you can connect to servers 20 Figure 1-17: jISQL login screen If you can connect successful, yo u see a window that looks like this: Figure 1-18 : Post-connection scree n If you see an erro r mes sage instead of this window , use the Process V iewer or Server Discovery to determine whether or not th e ser ver is actually running.[...]

  • Page 31

    CHAPTER 1 Installing Adaptiv e Serv er 21 Connectin g to Adaptive Server via Sybase Cen tral Sybase Central pr ovides a graphical user interface fo r Adaptive Server admini stra tive task s. Syb ase Ce ntra l displa ys a hierarchical list of all servers in the left pane an d a details lis t of the s elected server in the right pan e. T o select a s[...]

  • Page 32

    Starting and stopping Adapti ve Server 22 sp_password null, new_password where null is the default password and new_pa sswor d is the password that you are assigning to the “sa” account. S tarting and stopping Ada ptive Server Once you have installed the server, you may need to stop it, or to reinitiali ze it using an alternative disk location.[...]

  • Page 33

    CHAPTER 1 Installing Adaptiv e Serv er 23 Rebuilding Ada ptive Server Y o u may need to rebuild the d atabases cr eated during the install process for the following reaso ns : • Y ou want to use an alternative disk de vice for the database devices, perha p s for f aster di sks. • Y ou need to change the size of th e pages within the database. Y[...]

  • Page 34

    Installing online hel p for Transact-SQL syntax 24 Changing the default chara cter set and sort order Y ou can change the defau lt character set by using the charset utility . Y ou can use this utility onl y from the UNIX shell, s o you must op en a T erminal window . The utility is found at /Applications/Sybase/System/ ASE-12_5/ bin/charset . T o [...]

  • Page 35

    CHAPTER 1 Installing Adaptiv e Serv er 25 For more inf o rmation on sp_syntax , see the Refer ence Manual . This s c ri pt includes syntax infor mation for T ransa c t-SQL, the system procedures, and the Sybase utiliti es. Wh en you execute this script, you install the SQL portion of the sybsyntax database. When you first execute this script, it cr[...]

  • Page 36

    Installing online hel p for Transact-SQL syntax 26 /* is the spac e left on the default databas e devices > size of model? */ if (select sum (high-low + 1)from s ysdevices where status & 1 = 1) - (select sum(size) from sysusage, sysdevices where vstart >= sysdev ices.low and vstart <= s ysdevices.high an d sysdevices.status &1 = 1)[...]

  • Page 37

    CHAPTER 1 Installing Adaptiv e Serv er 27 Adaptive Server dis plays a list of comma nds that contain the word or word fragment “select.” Sybase XP Server XP Server is automatical ly installed by the buil d process. The default name of the XP Server is hostna me _XP . St a rting Sybase services autom atically By copying s ome files to th e syste[...]

  • Page 38

    Sybase SNMP subagent 28 Sybase SNMP subagent The Sybas e SNMP su bagent allows SNMP-bas ed network monito ring and error not ification for Sybas e servers. This subagent features: • Support for V1, V2c, and V3 SNMP • Implementation of NETWORK-SER VICES-MIB, RBDMS-MIB, SYBASE-MIB • T rap generation on ser v er errors via the sp_errornoti fy re[...]

  • Page 39

    CHAPTER 1 Installing Adaptiv e Serv er 29 ## ./etc/rc.common if ["${SNMPSERVER:=-NO-}" = "-YES-" ]; then ConsoleMessage "Starting SNMP server" /usr/sbin/snmpd -x 705 fi Sybase subagent T o install the Sybase SNMP s ubagent, first edit snmpagent.cfg in /Applica t ions/S ybase/Syst em/SNMP-1 _0 to includ e entries for ea[...]

  • Page 40

    Sybase SNMP subagent 30 This command should walk thro ugh and return values for sever al MIBs including RDBMS-MIB. For more in form ation on the SNMP command line tool issue m an snmp wal k and man snmcmd . Configuring trap generation from Adaptive Se rver The Sybase s ubagent allows a Sybase s erver to generate a t r ap through a remote proced ure[...]

  • Page 41

    CHAPTER 1 Installing Adaptiv e Serv er 31 • The Sybase subagent maintains a table of the m o st recent 500 err ors raised through sp _errorno tify . These values can be retrieve d from the aseError T able table defi nition i n SYBASE -MIB. T rouble shootin g the inst al lation Please refer to the Release Bullet in for a complete list of known pro[...]

  • Page 42

    Uninstalling Sybase software 32 Uninst alling Sybase software T o uni nstall Sy base software, use the un insta ll scrip t in /Applications/Sybase/Sys tem/Install . Note This scr ipt remo ves ever ything in /Applications/Sybase . Use it carefully . If you h ave set up yo ur system to automatically res tart Sybase services, these S tartupI tems are [...]

  • Page 43

    33 CHAPTER 2 Sybase Software Asset Management This chapter de scribes impor tant concepts regard ing how to license optional Adaptive Server features, add new licenses to existing servers, set up the licen se manager in a network environment, and set up redun dant servers for high availabilit y and failover using Sybase So f tware Asset Management [...]

  • Page 44

    Adaptive Server check-out procedure 34 When Adaptive Server is initiall y installed on the Mac OS X platf orm it includes a Developer’ s Edition (ASE_DEV) license bundled w ith the software. This is true no matter which edition was p urchased. The Developer ’ s Edition of Adaptive Server has sever al limits on its use. Fo r example, no more tha[...]

  • Page 45

    CHAPTER 2 Sybase Software Asset Management 35 For a Developer ’ s Edition all that is in the license file is a Developer ’ s Edition license key (ASE _DEV). The Adaptive Server examines the license and as long as it is valid contin ues s tarting. Because it is a Developer’s Edition all optional non-r oyalty features are enabled. For Small Bus[...]

  • Page 46

    Adaptive Server check-out procedure 36 T able 2-1: Config uration para meters for optio nal features By default, the configuration parameters for o ptional features ar e set to 0 (off). T o enable an optional feature use sp_configure to set its config uratio n parameter to 1, and restart Adaptive Server . Some features require additional preparat i[...]

  • Page 47

    CHAPTER 2 Sybase Software Asset Management 37 Redundant servers As part of a failover plan or a load-balancing s ystem, you can have multiple servers runni ng on th e sam e Adaptiv e Ser ver configur ation, usin g a redundant licens e across al l servers. The r edundant server system can be connected by a local-area network (LAN) or by a w ide- are[...]

  • Page 48

    SySAM administration 38 3 For each machine in the re dundant sy stem enter the li cense inf ormation using the License Entry applicatio n. The certificate information is provi ded in you A daptive S erver p ackage on a printed Sybase Software Asset Management Certificate. 4 After the ins tallation is completed, and fo r each server in the redundant[...]

  • Page 49

    CHAPTER 2 Sybase Software Asset Management 39 St arting the software manually If the license manag er is not running, you must start the license manager manually . U se the startd.sh script in the /bin directory: $SYBASE/$SYBASE_SYBASE/bin/startd.sh St arting SySAM as an automatic ser vice T o start the SySAM sofwar e automatically when the system [...]

  • Page 50

    SySAM administration 40[...]

  • Page 51

    41 A Adap tive Ser ver base li ce nse 33 check-o ut pro ced ures 34 conn ec tin g via Syba s e Cen t ra l 21 default character set 2 optional feat ures 35 page size 2 starting 2 2 stopping 22 uninstallin g 32 utilitie s 35 Adaptive Server En terprise 33 Adap tive Se rver na me 1 Adap tive S erv er port num ber 1 agreement license 6 ASE Rep lic ator[...]

  • Page 52

    Index 42 F full-tex t search 12 H hard d isk co nfigu ration 1 headless systems 10 high ava ilabil ity 12 Historical Se rver 12 host n ame 1 I installation downloading software for 3 fro m CD 3 license ag reement 6 on headless system s 10 post -installati on taks 12 prerequisites 1 Rea d Me n ote s 5 rec ord of 9 stoping the 7 installatio n directo[...]

  • Page 53

    Index 43 of A daptiv e Serv er 2 password setting th e System Administrato r 21 path for master device 2 pathnam e for sybsystemprocs 2 port numb er of A daptiv e Serv er 1 of Backup Server 1 of XP Serve r 1 post-installa tion tasks 12 preinstall a tion tasks 1 R Read Me notes 5 rebui lding Adapti ve Server 23 record o f the instal lation 9 redund [...]

  • Page 54

    Index 44 viewing servers 17 W WAN 36 X XML 11 XP Se rver 12, 27 XP Server name 1 XP Server port nu m ber 1 Xserve 10[...]