Sybase 12.5.X manual

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

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

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

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

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

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

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

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

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

x[...]

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

SySAM administration 40[...]

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

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

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

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