Quick Installation Guide Adaptive Server Enterprise 12.5.
DOCUMENT ID: 39123-01-1250-01 LAST REVISED: September 2002 Copyright © 1989-2002 by Sybase, Inc. All rights reserved. This publication pertains to Sybase software and to any subsequent release until otherwise indicated in new editions or technical notes. Information in this document is subject to change without notice. The software described herein is furnished under a license agreement, and it may be used or copied only in accordance with the terms of that agreement. To order additional documents, U.S.
Contents About This Book ............................................................................................................................ v CHAPTER 1 Installing Adaptive Server .............................................................. 1 System requirements ....................................................................... 1 Preinstallation system setup ............................................................ 1 Upgrading from the early adopter release ............................
Contents Sybase subagent..................................................................... MIB files................................................................................... Configuring trap generation from Adaptive Server .................. Troubleshooting the installation ..................................................... Uninstalling Sybase software ......................................................... Further reading...................................................................
About This Book This guide, Installation Guide Sybase Adaptive Server Enterprise, provides: • An overview of the Sybase® Adaptive Server™ Enterprise installation infrastructure • Instructions for installing and upgrading Adaptive Server, and installing Backup Server™, Monitor Server, XP Server™, jConnect™ for JDBC™, Java utilities, and client products, including the Adaptive Server plug-in for Sybase Central™ • Instructions for installing optional Adaptive Server functionality, such as auditing, and s
vi • Transact-SQL User’s Guide – documents Transact-SQL, Sybase’s enhanced version of the relational database language. This manual serves as a textbook for beginning users of the database management system. This manual also contains descriptions of the pubs2 and pubs3 sample databases. • System Administration Guide – provides in-depth information about administering servers and databases.
About This Book Other sources of information • Using Sybase Failover in a High Availability System – provides instructions for using Sybase’s Failover to configure an Adaptive Server as a companion server in a high availability system. • Using Adaptive Server Distributed Transaction Management Features – explains how to configure, use, and troubleshoot Adaptive Server DTM features in distributed transaction processing environments.
• The Technical Library Product Manuals Web site is an HTML version of the Technical Library CD that you can access using a standard Web browser. In addition to product manuals, you will find links to the Technical Documents Web site (formerly known as Tech Info Library), the Solved Cases page, and Sybase/Powersoft newsgroups. To access the Technical Library Product Manuals Web site, go to Product Manuals at http://www.sybase.com/support/manuals/.
About This Book Conventions The following style conventions are used in this manual: • In a sample screen display, commands you should enter exactly as shown are given in: this font • In a sample screen display, words that you should replace with the appropriate value for your installation are shown in: this font • In the regular text of this document, the names of files and directories appear in this font: /usr/u/sybase • The names of programs, utilities, procedures, and commands appear in this fo
x
CH A PTE R 1 Installing Adaptive Server This documentation describes the steps to install Adaptive Server on Mac OS X, and contains brief descriptions of some of the content of this release. This release is supported via a newsgroup, as well as through the terms in your purchase agreement. You can reach the newsgroup at news://forums.sybase.com/sybase.public.macosx. System requirements The Apple computer you use to install this software must be configured as follows: • Operating system – OS X 10.
Preinstallation system setup • master device pathname – /Applications/Sybase/System/devices/master.dat • master device size – 100MB • sybsystemprocs device pathname – /Applications/Sybase/System/devices/sybprocs.dat • sybsystemprocs device size – 160MB • Server page size – 4096 bytes • Server default character set – iso_1 Upgrading from the early adopter release Upgrading from the Early Adopter release is not supported.
CHAPTER 1 3 Installing Adaptive Server • Click localhost under the machines directory. • Choose Duplicate. • Click on localhost copy under values and change it to your machine’s name. • Apply the changes. Test the update by executing: ping ‘hostname -s’ Installing from a CD If you are installing from a CD, insert the CD into the drive, and when it becomes visible on your desktop, double-click the icon. A Finder window appears, showing the contents of the CD.
Installation 3 Using a browser, go to the Web site and download the disk image to your desktop. For some browsers, downloading a disk image also causes the disk image to be mounted automatically. If this does not happen with your browser when the download is complete, double-click on the disk image. The Finder will mount the image as a new file system volume, named Sybase_ASE_12502. 4 Double-click the Volume icon; its contents appear in a separate window.
CHAPTER 1 Installing Adaptive Server Figure 1-1: Introduction page 2 You see the Read Me notes, which you can print, save, or read by using the scroll bar on the right. These notes are important, and Sybase recommends that you make a hard copy of these notes by clicking the Print button. Select Continue when finished. Figure 1-2: Read me notes 3 The next window displays the software license agreement. View the terms and conditions of the agreement, then click Continue.
Installation Figure 1-3: Software license agreement 4 To continue with the installation, click Agree to accept the terms of the license agreement. If you select Disagree, the installer reverts to the previous window. Figure 1-4: Accepting the software license agreement 5 From the next window, select Macintosh HD (which may vary on some machines.) This is the required boot device. Click continue. This page informs you of the amount of disk space that is needed to contain the actual installation files.
CHAPTER 1 Installing Adaptive Server Figure 1-5: Select a destination 6 Click Install to proceed. If you try to install this package a second time, this button changes to Upgrade. If you click Upgrade, the software is copied from the package into the release location at /Applications/Sybase, but no server is initialized and started. To stop the installation at this point, select Go Back to stop the installater.
Installation Figure 1-6: Easy install 7 The installer now performs a series of tasks, including some preinstallation checks and writing files to the selected disk volume. Figure 1-7: Processing Adaptive Server 8 8 The installer is now running Sybase scripts that initialize a database, install Sybase provided stored procedures, and leave the server up and running when complete. This stage can take 5 – 10 minutes.
CHAPTER 1 Installing Adaptive Server Figure 1-8: Processing databases and stored procedures 9 You are finished. Sybase Adaptive Server Enterprise is now ready for your use. Click on Close, and the installer exits. A record of the installation has been saved in /Library/Receipts/Sybase_ASE_12502.pkg.
Installation on Xserve Figure 1-9: Finishing the installation Installation on Xserve To install Adaptive Server on Xserve running in a “headless” mode (without a monitor,) you have two options: • Use the command line installer. Place the disk image containing the installation package on a disk volume accessible to Xserve. Enter: installer -pkg Sybase_ASE_12502.pkg -target / where the path name to the installation package (.pkg) identifies the exact location of the file.
CHAPTER 1 Installing Adaptive Server Release contents This distribution 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 automatically enabled, and there is no expiration period. To enable usage authorized by your purchase agreement, you must provide license keys using the License Entry application in the /Applications/Sybase directory. Besides Adaptive Server Enterprise version 12.5.
Post-installation tasks • Backup Server • XP Server • ODBC driver from Open Link Software, Inc. Features not yet available Some of the JAdaptive Server features provided for other UNIX platforms are not available yet on Mac OS X, including: • EJB Server • SSL support • LDAP support • ASE Replicator (newly introduced in Adaptive Server 12.5.0.
CHAPTER 1 Installing Adaptive Server • Viewing servers running on your network • Verifying that you can connect to servers • Connecting to Adaptive Server via Sybase Central • Setting the System Administrator password • Starting and stopping Adaptive Server • Reinitializing Adaptive Server • Installing sample databases • Installing online help for Transact-SQL syntax • Starting Sybase XP Server • Starting Sybase services automatically Entering license keys If you have downloaded Adapti
Entering license keys Figure 1-10: License Entry icon 2 You are asked whether you have a Sybase Software Asset Management Certificate. You should have the printed certificate(s) in front of you. Click Yes to continue. If you do not have license certificates to enter, click No and proceed to the next section, “Entering Network License Management Information.” Figure 1-11: Entering a SySAM certificate 3 14 Enter the information for the primary server license first and click Enter.
CHAPTER 1 Installing Adaptive Server Figure 1-12: License key entry screen 4 You are asked whether or not you ahve additional license certificates to enter. You will have additional certificates if you purchased any optional features. If you have additional certificates click Yes and repeat the previous step to enter the information. When you are finished entering all license certificates select No to complete license entry.
Environment variables Figure 1-13: Network license manager If you are using a network license host to server as a central point to check licenses out, enter the machine name and port number for the Network License Manager license daemon. The default port number is 29722. A simplified license is written out that contains ifnormation to direct Adaptive Server to contact the remote license daemon to check out licenses. Otherwise select cancel and the License Entry application exits.
CHAPTER 1 Installing Adaptive Server Viewing servers that are running on your network Adaptive Server, along with its associated Backup Server and XP Server, registers with the network using Rendezvous technology, so that any Rendezvous client can discover what services are available. We have provided a service discovery tool for Sybase servers, called Server Discovery.
Verifying that you can connect to servers Figure 1-15: Server Discovery text file You can use its Configuration menu item to automatically update the Sybase interfaces file for those servers that you have highlighted in the window. In addition, the sample program ctos, in /Applications/Sybase/System/OCS12_5/sample/srvlibrary, contains an example of how to register an Open Server™ application with Rendezvous, that can be detected by Server Discovery.
CHAPTER 1 Installing Adaptive Server Figure 1-16: jISQL icon Attempt to connect when you see the login screen: In the login window, enter: • Username – sa • Password – leave blank • Hostname – servername_ASE • Portnumber – 11222 19
Verifying that you can connect to servers Figure 1-17: jISQL login screen If you can connect successful, you see a window that looks like this: Figure 1-18: Post-connection screen If you see an error message instead of this window, use the Process Viewer or Server Discovery to determine whether or not the server is actually running.
CHAPTER 1 Installing Adaptive Server Connecting to Adaptive Server via Sybase Central Sybase Central provides a graphical user interface for Adaptive Server administrative tasks. Sybase Central displays a hierarchical list of all servers in the left pane and a details list of the selected server in the right pane. To select a server, click on it with the mouse in the left pane. To start Sybase Central: 1 Double-click the Sybase Central icon from the Finder.
Starting and stopping Adaptive Server sp_password null, new_password where null is the default password and new_password is the password that you are assigning to the “sa” account. Starting and stopping Adaptive Server Once you have installed the server, you may need to stop it, or to reinitialize it using an alternative disk location.
CHAPTER 1 Installing Adaptive Server Rebuilding Adaptive Server You may need to rebuild the databases created during the install process for the following reasons: • You want to use an alternative disk device for the database devices, perhaps for faster disks. • You need to change the size of the pages within the database.
Installing online help for Transact-SQL syntax Changing the default character set and sort order You can change the default character set by using the charset utility. You can use this utility only from the UNIX shell, so you must open a Terminal window. The utility is found at /Applications/Sybase/System/ASE-12_5/bin/charset. To change Adaptive Server’s defaults: 1 Run the charset utility to add the character set to Adaptive Server’s system catalogues.
CHAPTER 1 Installing Adaptive Server For more information on sp_syntax, see the Reference Manual. This script includes syntax information for Transact-SQL, the system procedures, and the Sybase utilities. When you execute this script, you install the SQL portion of the sybsyntax database. When you first execute this script, it creates the sybsyntax database and the necessary tables and indexes.
Installing online help for Transact-SQL syntax /* is the space left on the default database devices > size of model? */ if (select sum (high-low + 1)from sysdevices where status & 1 = 1) - (select sum(size) from sysusage, sysdevices where vstart >= sysdevices.low and vstart <= sysdevices.high and sysdevices.status &1 = 1) > (select sum(sysusages.
CHAPTER 1 Installing Adaptive Server Adaptive Server displays a list of commands that contain the word or word fragment “select.” Sybase XP Server XP Server is automatically installed by the build process. The default name of the XP Server is hostname_XP. Starting Sybase services automatically By copying some files to the system’s /Library/StartupItems directory, you can ensure that Sybase services automatically start when your system starts opr restarts.
Sybase SNMP subagent Sybase SNMP subagent The Sybase SNMP subagent allows SNMP-based network monitoring and error notification for Sybase servers.
CHAPTER 1 Installing Adaptive Server ## ./etc/rc.common if ["${SNMPSERVER:=-NO-}" = "-YES-" ]; then ConsoleMessage "Starting SNMP server" /usr/sbin/snmpd -x 705 fi Sybase subagent To install the Sybase SNMP subagent, first edit snmpagent.cfg in /Applications/Sybase/System/SNMP-1_0 to include entries for each server that is to be monitored. There is no limit to the number of servers that can be monitored by the Sybase subagent.Typically, the subagent resides on the same machine as the monitored server.
Sybase SNMP subagent This command should walk through and return values for several MIBs including RDBMS-MIB. For more information on the SNMP command line tool issue man snmpwalk and man snmcmd. Configuring trap generation from Adaptive Server The Sybase subagent allows a Sybase server to generate a trap through a remote procedure call, sp_errornotify. When the remote procedure is called, a trap is generated containing the values in its parameters.
CHAPTER 1 • Installing Adaptive Server The Sybase subagent maintains a table of the most recent 500 errors raised through sp_errornotify. These values can be retrieved from the aseErrorTable table definition in SYBASE-MIB. Troubleshooting the installation Please refer to the Release Bulletin for a complete list of known problems.
Uninstalling Sybase software Uninstalling Sybase software To uninstall Sybase software, use the uninstall script in /Applications/Sybase/System/Install. Note This script removes everything in /Applications/Sybase. Use it carefully. If you have set up your system to automatically restart Sybase services, these StartupItems are also deleted. Finally, the receipt for the installation, found in /Library/Receipts is removed. uninstall requires a single argument, override, before it removes installation files.
CH A PTE R 2 Sybase Software Asset Management This chapter describes important concepts regarding how to license optional Adaptive Server features, add new licenses to existing servers, set up the license manager in a network environment, and set up redundant servers for high availability and failover using Sybase Software Asset Management (SySAM). You need to refer back to this chapter when you begin intalling Adapive Server in a network environment.
Adaptive Server check-out procedure When Adaptive Server is initially installed on the Mac OS X platform it includes a Developer’s Edition (ASE_DEV) license bundled with the software. This is true no matter which edition was purchased. The Developer’s Edition of Adaptive Server has several limits on its use. For example, no more than one database engine and no more than 25 user connections.) However, it does enable all of the available optional non-royalty features.
CHAPTER 2 Sybase Software Asset Management 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 continues starting. Because it is a Developer’s Edition all optional non-royalty features are enabled.
Adaptive Server check-out procedure Table 2-1: Configuration parameters for optional features Feature name License name Java in ASE External File System ASE_JAVA ASE_XFS Configuration parameter enable java enable file access By default, the configuration parameters for optional features are set to 0 (off). To enable an optional feature use sp_configure to set its configuration parameter to 1, and restart Adaptive Server. Some features require additional preparation before you can use them.
CHAPTER 2 Sybase Software Asset Management As part of a failover plan or a load-balancing system, you can have multiple servers running on the same Adaptive Server configuration, using a redundant license across all servers. The redundant server system can be connected by a local-area network (LAN) or by a widearea network (WAN). A redundant server system is an excellent load-balancing mechanism for physically distant servers.
SySAM administration 3 For each machine in the redundant system enter the license information using the License Entry application. The certificate information is provided in you Adaptive Server package on a printed Sybase Software Asset Management Certificate.
CHAPTER 2 Sybase Software Asset Management Starting the software manually If the license manager is not running, you must start the license manager manually. Use the startd.sh script in the /bin directory: $SYBASE/$SYBASE_SYBASE/bin/startd.sh Starting SySAM as an automatic service To start the SySAM sofware automatically when the system is starting, see “Starting Sybase Services Automatically” in this document.
SySAM administration 40
Index A Adaptive Server base license 33 check-out procedures 34 connecting via Sybase Central default character set 2 optional features 35 page size 2 starting 22 stopping 22 uninstalling 32 utilities 35 Adaptive Server Enterprise 33 Adaptive Server name 1 Adaptive Server port number 1 agreement license 6 ASE Replicator 12 ASE_DEV 34 ASE_SBE 14, 34 ASE_SERVER 14, 34 automatic starting Sybase servers 27 B Backup Server 12 Backup Server name 1 Backup Server port number base license 33 boot device 6 bootstra
Index F full-text search LDAP 12 license agreement 6 License Entry 11 license keys entering 13 12 H hard disk configuration headless systems 10 high availability 12 Historical Server 12 host name 1 1 M I installation downloading software for from CD 3 license agreement 6 on headless systems 10 post-installation taks 12 prerequisites 1 Read Me notes 5 record of 9 stoping the 7 installation directory 1 installing SNMP agent 28 3 Mac OS X system requirements 1 Macintosh HD 6 manually starting SySAM 39
Index of Adaptive Server 2 password setting the System Administrator path for master device 2 pathname for sybsystemprocs 2 port number of Adaptive Server 1 of Backup Server 1 of XP Server 1 post-installation tasks 12 preinstallation tasks 1 21 R Read Me notes 5 rebuilding Adaptive Server 23 record of the installation 9 redundant servers 36 release contents 11 Rendezvous 11, 17 row level access control 11 running servers 17 sort order 23 SSL 12 starting Adaptive Server 22 stopping Adaptive Server 22 stop
Index viewing servers 17 W WAN 36 X XML 11 XP Server 12, 27 XP Server name 1 XP Server port number Xserve 10 44 1
