Sybase MAC OS X User Manual

Quick Installation Guide Adaptive Server Enterprise12.5.xMac OS X

x

1CHAPTER 1Installing Adaptive ServerThis documentation describes the steps to install Adaptive Server on Mac OS X, and contains brief descriptions of

Preinstallation system setup 2 • master device pathname – /Applications/Sybase/System/devices/master.dat•master device size – 100MB•sybsystemprocs de

CHAPTER 1 Installing Adaptive Server3• Click localhost under the machines directory.• Choose Duplicate.• Click on localhost copy under values and c

Installation 4 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 ca

CHAPTER 1 Installing Adaptive Server5Figure 1-1: Introduction page2 You see the Read Me notes, which you can print, save, or read by using the scro

Installation 6 Figure 1-3: Software license agreement4 To continue with the installation, click Agree to accept the terms of the license agreement. I

CHAPTER 1 Installing Adaptive Server7Figure 1-5: Select a destination6 Click Install to proceed. If you try to install this package a second time,

Installation 8 Figure 1-6: Easy install7 The installer now performs a series of tasks, including some preinstallation checks and writing files to the

CHAPTER 1 Installing Adaptive Server9Figure 1-8: Processing databases and stored procedures9 You are finished. Sybase Adaptive Server Enterprise is

DOCUMENT ID: 39123-01-1250-01LAST REVISED: September 2002Copyright © 1989-2002 by Sybase, Inc. All rights reserved.This publication pertains to Sybase

Installation on Xserve 10 Figure 1-9: Finishing the installationInstallation on XserveTo install Adaptive Server on Xserve running in a “headless” mo

CHAPTER 1 Installing Adaptive Server11Release contentsThis distribution is provided with a Developer’s Edition license that enables single-CPU oper

Post-installation tasks 12 • Backup Server• XP Server• ODBC driver from Open Link Software, Inc.Features not yet availableSome of the JAdaptive Serve

CHAPTER 1 Installing Adaptive Server13• Viewing servers running on your network• Verifying that you can connect to servers• Connecting to Adaptive

Entering license keys 14 Figure 1-10: License Entry icon2 You are asked whether you have a Sybase Software Asset Management Certificate. You should h

CHAPTER 1 Installing Adaptive Server15Figure 1-12: License key entry screen4 You are asked whether or not you ahve additional license certificates

Environment variables 16 Figure 1-13: Network license managerIf you are using a network license host to server as a central point to check licenses

CHAPTER 1 Installing Adaptive Server17Viewing servers that are running on your networkAdaptive Server, along with its associated Backup Server and

Verifying that you can connect to servers 18 Figure 1-15: Server Discovery text fileYou can use its Configuration menu item to automatically update t

CHAPTER 1 Installing Adaptive Server19Figure 1-16: jISQL iconAttempt to connect when you see the login screen:In the login window, enter:• Username

ContentsiiiAbout This Book ...

Verifying that you can connect to servers 20 Figure 1-17: jISQL login screenIf you can connect successful, you see a window that looks like this:Figu

CHAPTER 1 Installing Adaptive Server21Connecting to Adaptive Server via Sybase CentralSybase Central provides a graphical user interface for Adapti

Starting and stopping Adaptive Server 22 sp_password null, new_passwordwhere null is the default password and new_password is the password that you a

CHAPTER 1 Installing Adaptive Server23Rebuilding Adaptive ServerYou may need to rebuild the databases created during the install process for the fo

Installing online help for Transact-SQL syntax 24 Changing the default character set and sort orderYou can change the default character set by using

CHAPTER 1 Installing Adaptive Server25For more information on sp_syntax, see the Reference Manual. This script includes syntax information for Tran

Installing online help for Transact-SQL syntax 26 /* is the space left on the default database devices> size of model? */ if (select sum (high-low

CHAPTER 1 Installing Adaptive Server27Adaptive Server displays a list of commands that contain the word or word fragment “select.”Sybase XP ServerX

Sybase SNMP subagent 28 Sybase SNMP subagentThe Sybase SNMP subagent allows SNMP-based network monitoring and error notification for Sybase servers.

CHAPTER 1 Installing Adaptive Server29## ./etc/rc.common if ["${SNMPSERVER:=-NO-}" = "-YES-" ]; then ConsoleMessage "

ContentsivSybase subagent... 29MIB files...

Sybase SNMP subagent 30 This command should walk through and return values for several MIBs including RDBMS-MIB. For more information on the SNMP com

CHAPTER 1 Installing Adaptive Server31• The Sybase subagent maintains a table of the most recent 500 errors raised through sp_errornotify. These va

Uninstalling Sybase software 32 Uninstalling Sybase softwareTo uninstall Sybase software, use the uninstall script in /Applications/Sybase/System/Ins

33CHAPTER 2Sybase Software Asset Management This chapter describes important concepts regarding how to license optional Adaptive Server features, add

Adaptive Server check-out procedure 34 When Adaptive Server is initially installed on the Mac OS X platform it includes a Developer’s Edition (ASE_DE

CHAPTER 2 Sybase Software Asset Management35For a Developer’s Edition all that is in the license file is a Developer’s Edition license key (ASE_DEV

Adaptive Server check-out procedure 36 Table 2-1: Configuration parameters for optional featuresBy default, the configuration parameters for optional

CHAPTER 2 Sybase Software Asset Management37Redundant servers As part of a failover plan or a load-balancing system, you can have multiple servers

SySAM administration 38 3 For each machine in the redundant system enter the license information using the License Entry application. The certificate

CHAPTER 2 Sybase Software Asset Management39Starting the software manuallyIf the license manager is not running, you must start the license manager

vAbout This BookThis guide, Installation Guide Sybase Adaptive Server Enterprise, provides: • An overview of the Sybase® Adaptive Server™ Enterprise i

SySAM administration 40

41AAdaptive Serverbase license 33check-out procedures 34connecting via Sybase Central 21default character set 2optional features 35page size 2st

Index42 Ffull-text search 12Hhard disk configuration 1headless systems 10high availability 12Historical Server 12host name 1Iinstallationdownloa

Index43of Adaptive Server 2passwordsetting the System Administrator 21pathfor master device 2pathnamefor sybsystemprocs 2port numberof Adaptive Se

Index44 viewing servers 17WWAN 36XXML 11XP Server 12, 27XP Server name 1XP Server port number 1Xserve 10

vi • Transact-SQL User’s Guide – documents Transact-SQL, Sybase’s enhanced version of the relational database language. This manual serves as a text

About This Bookvii• Using Sybase Failover in a High Availability System – provides instructions for using Sybase’s Failover to configure an Adapt

viii • The Technical Library Product Manuals Web site is an HTML version of the Technical Library CD that you can access using a standard Web browse

About This BookixConventionsThe following style conventions are used in this manual: • In a sample screen display, commands you should enter exa