Sybase MAC OS X Bedienungsanleitung

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

Zur Seite of

Richtige Gebrauchsanleitung

Die Vorschriften verpflichten den Verkäufer zur Übertragung der Gebrauchsanleitung Sybase MAC OS X an den Erwerber, zusammen mit der Ware. Eine fehlende Anleitung oder falsche Informationen, die dem Verbraucher übertragen werden, bilden eine Grundlage für eine Reklamation aufgrund Unstimmigkeit des Geräts mit dem Vertrag. Rechtsmäßig lässt man das Anfügen einer Gebrauchsanleitung in anderer Form als Papierform zu, was letztens sehr oft genutzt wird, indem man eine grafische oder elektronische Anleitung von Sybase MAC OS X, sowie Anleitungsvideos für Nutzer beifügt. Die Bedingung ist, dass ihre Form leserlich und verständlich ist.

Was ist eine Gebrauchsanleitung?

Das Wort kommt vom lateinischen „instructio”, d.h. ordnen. Demnach kann man in der Anleitung Sybase MAC OS X die Beschreibung der Etappen der Vorgehensweisen finden. Das Ziel der Anleitung ist die Belehrung, Vereinfachung des Starts, der Nutzung des Geräts oder auch der Ausführung bestimmter Tätigkeiten. Die Anleitung ist eine Sammlung von Informationen über ein Gegenstand/eine Dienstleistung, ein Hinweis.

Leider widmen nicht viele Nutzer ihre Zeit der Gebrauchsanleitung Sybase MAC OS X. Eine gute Gebrauchsanleitung erlaubt nicht nur eine Reihe zusätzlicher Funktionen des gekauften Geräts kennenzulernen, sondern hilft dabei viele Fehler zu vermeiden.

Was sollte also eine ideale Gebrauchsanleitung beinhalten?

Die Gebrauchsanleitung Sybase MAC OS X sollte vor allem folgendes enthalten:
- Informationen über technische Daten des Geräts Sybase MAC OS X
- Den Namen des Produzenten und das Produktionsjahr des Geräts Sybase MAC OS X
- Grundsätze der Bedienung, Regulierung und Wartung des Geräts Sybase MAC OS X
- Sicherheitszeichen und Zertifikate, die die Übereinstimmung mit entsprechenden Normen bestätigen

Warum lesen wir keine Gebrauchsanleitungen?

Der Grund dafür ist die fehlende Zeit und die Sicherheit, was die bestimmten Funktionen der gekauften Geräte angeht. Leider ist das Anschließen und Starten von Sybase MAC OS X zu wenig. Eine Anleitung beinhaltet eine Reihe von Hinweisen bezüglich bestimmter Funktionen, Sicherheitsgrundsätze, Wartungsarten (sogar das, welche Mittel man benutzen sollte), eventueller Fehler von Sybase MAC OS X und Lösungsarten für Probleme, die während der Nutzung auftreten könnten. Immerhin kann man in der Gebrauchsanleitung die Kontaktnummer zum Service Sybase finden, wenn die vorgeschlagenen Lösungen nicht wirksam sind. Aktuell erfreuen sich Anleitungen in Form von interessanten Animationen oder Videoanleitungen an Popularität, die den Nutzer besser ansprechen als eine Broschüre. Diese Art von Anleitung gibt garantiert, dass der Nutzer sich das ganze Video anschaut, ohne die spezifizierten und komplizierten technischen Beschreibungen von Sybase MAC OS X zu überspringen, wie es bei der Papierform passiert.

Warum sollte man Gebrauchsanleitungen lesen?

In der Gebrauchsanleitung finden wir vor allem die Antwort über den Bau sowie die Möglichkeiten des Geräts Sybase MAC OS X, über die Nutzung bestimmter Accessoires und eine Reihe von Informationen, die erlauben, jegliche Funktionen und Bequemlichkeiten zu nutzen.

Nach dem gelungenen Kauf des Geräts, sollte man einige Zeit für das Kennenlernen jedes Teils der Anleitung von Sybase MAC OS X widmen. Aktuell sind sie genau vorbereitet oder übersetzt, damit sie nicht nur verständlich für die Nutzer sind, aber auch ihre grundliegende Hilfs-Informations-Funktion erfüllen.

Inhaltsverzeichnis der Gebrauchsanleitungen

  • Seite 1

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

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

  • Seite 3

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

  • Seite 4

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

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

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

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

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

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

  • Seite 10

    x[...]

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

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

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

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

  • Seite 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: [...]

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

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

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

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

  • Seite 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 : [...]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

  • Seite 50

    SySAM administration 40[...]

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

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

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

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