background image

CHAPTER 1    Installing Adaptive Server

13

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 Adaptive Server from the Web or purchased a copy of 
the Developer’s Edition of Adaptive Server, you do not need to use the license 
entry application. There is no need to enter any license key and you do not need 
to start up the license daemon software (referred to as SySAM).

If you have purchased the Adaptive Server software with either an Enterprise 
or Small Business Edition license then you must follow the steps below to set 
up the license information.

1

In the Finder, double-click License Entry.

Summary of Contents for Adaptive Server Enterprise 12.5.x

Page 1: ...Quick Installation Guide Adaptive Server Enterprise 12 5 x Mac OS X...

Page 2: ...nect InternetBuilder iScript Jaguar CTS jConnect for JDBC MainframeConnect Maintenance Express MDI Access Server MDI Database Gateway media splash MetaWorks MySupport Net Gateway Net Library New Era o...

Page 3: ...at are running on your network 17 Verifying that you can connect to servers 18 Connecting to Adaptive Server via Sybase Central 21 Setting the System Administrator password 21 Starting and stopping Ad...

Page 4: ...gement 33 SySAM overview 33 Adaptive Server base license 33 Adaptive Server check out procedure 34 Utilities 35 Starting Adaptive Server with optional features 35 Types of SySAM systems 36 SySAM in th...

Page 5: ...ollowing documents comprise the Sybase Adaptive Server Enterprise documentation The release bulletin for your platform contains last minute information that was too late to be included in the books A...

Page 6: ...ect performance query optimization how to tune Adaptive Server for very large databases disk and cache issues and the effects of locking and cursors on performance The Utility Guide documents the Adap...

Page 7: ...Full Text Search Specialty Data Store User s Guide describes how to use the Full Text Search feature with Verity to search Adaptive Server Enterprise data Historical Server User s Guide describes how...

Page 8: ...vigation bar on the left 3 Select a product name from the product list 4 Select the Certification Report filter specify a time frame and click Go 5 Click a Certification Report title to display the re...

Page 9: ...le who are authorized to contact Sybase Technical Support If you cannot resolve a problem using the manuals or online help please have the designated person contact Sybase Technical Support or the Syb...

Page 10: ...x...

Page 11: ...to install this software must be configured as follows Operating system OS X 10 2 or higher Client or Server Computer Any system that can run Macintosh OS X 10 2 including iBook iMac PowerBook PowerMa...

Page 12: ...setup Before proceeding with the installation make sure your system is using a resolvable host name for its network connection Your machine is known to TCP IP by the name returned by the shell command...

Page 13: ...described in the next sections to complete the installation process If you intend to install on a headless system you must make this package visible to that system You can use the Finder to copy the...

Page 14: ...uld appear in that window Double click the Package icon to automatically start the OS X installer For installing on headless systems such as an Xserve system see Installation on Xserve on page 10 The...

Page 15: ...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...

Page 16: ...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...

Page 17: ...de 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 i...

Page 18: ...einstallation checks and writing files to the selected disk volume Figure 1 7 Processing Adaptive Server 8 The installer is now running Sybase scripts that initialize a database install Sybase provide...

Page 19: ...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...

Page 20: ...nstaller 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...

Page 21: ...aphical interface Server Build an interactive graphical configuration utility that allows you to define the parameters of a new server build and then performs actions necessary to build a new server a...

Page 22: ...e Server 12 5 0 1 on other platforms High availability Full Text Search Historical Server Monitor Server DTM Post installation tasks At the end of the installation process you have a minimally configu...

Page 23: ...r Starting Sybase services automatically Entering license keys If you have downloaded Adaptive Server from the Web or purchased a copy of the Developer s Edition of Adaptive Server you do not need to...

Page 24: ...ted 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...

Page 25: ...ep to enter the information When you are finished entering all license certificates select No to complete license entry 5 Now that the license certificates have been entered start the license daemon E...

Page 26: ...ense daemon to check out licenses Otherwise select cancel and the License Entry application exits See Sybase Software Asset Management for more details Environment variables Add entries to your login...

Page 27: ...gy so that any Rendezvous client can discover what services are available We have provided a service discovery tool for Sybase servers called Server Discovery Click Server Discovery from the Finder Fi...

Page 28: ...rvers that you have highlighted in the window In addition the sample program ctos in Applications Sybase System OCS 12_5 sample srvlibrary contains an example of how to register an Open Server applica...

Page 29: ...R 1 Installing Adaptive Server 19 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...

Page 30: ...in 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 Dis...

Page 31: ...nd leave the password blank After you log in for the first time change the system administrator s password See Setting the System Administrator password on page 21 for more information Sybase Central...

Page 32: ...Applications Sybase System OCS 12_5 bin isql You can also stop the server by using this operating system command although this method is not recommended as data corruption may occur sudo kill 9 pid w...

Page 33: ...used by srvbuildres Changing the default character set sort order or language Adaptive Server supports a wide variety of character sets are supported and messages can be localized to suit your particu...

Page 34: ...before you add any user data to the Adaptive Server If your server contains data follow the procedure outlines in the System Administration Guide to save and restore it Changing the default language C...

Page 35: ...installs sybsyntax on the master device Sybase does not recommend this configuration because sybsyntax uses valuable space that is best left available for future expansion of the master database To a...

Page 36: ...you have commented out this entire section add this line to the script create database sybsyntax on device_name where device_name is the name of the device on which you want to install sybsyntax Exec...

Page 37: ...Server You may need to edit the shell script in this directory to refer to the correct server name that is to be started SybaseLicenseManager contains scripts necessary to automatically start the lice...

Page 38: ...gent is a distribution of the Net SNMP master agent This is a very feature rich master agent available through the public domain More information on it can be found at http www net snmp org The Sybase...

Page 39: ...executing java jar SYBASE SNMP 1_0 lib SybaseAgent c SYBASE SNMP 1_0 snmpagent cfg A log file is produced in the location specified in snmpagent cfg or in SybaseAgent log if a log file location was no...

Page 40: ...you specified in snmpagent cfg as its port address The name of the server can be any valid server name Add the Sybase subagent as a remote server to your Adaptive Server using sp_addserver Use the sa...

Page 41: ...e installation process assumes the host name of your system is the same as returned by the shell command hostname s This name is used in entries within the interfaces file If you attempted the install...

Page 42: ...t for the installation found in Library Receipts is removed uninstall requires a single argument override before it removes installation files You must have superuser privileges to run uninstall sudo...

Page 43: ...need to refer back to this chapter when you begin intalling Adapive Server in a network environment SySAM overview SySAM is a licensing mechanism that Provides System Administrators with a means to mo...

Page 44: ...feature If the Small Business Edition is what was purchased then an ASE_SBE license key must be entered after the base Adaptive Server installation is complete The Small Business Edition requires a li...

Page 45: ...ck in or check out licensed features Using information in the license file Adaptive Server connects to SySAM and attempts to check out a license ASE_SERVER or ASE_SBE for the base Adaptive Server prod...

Page 46: ...r a WAN and for backup and load balancing purposes Depending on which instance of Adaptive Server primary or secondary servers you are installing the procedures for registering licenses vary Standalon...

Page 47: ...any reason the second server responds to the license request If that server fails too the next server in the list is contacted and so on SySAM in the network environment Before you begin installing a...

Page 48: ...9722 huey 29722 dewey 29722 louie The first server in the license list is the first server queued by the licensing software SySAM administration If you are installing servers in a network environment...

Page 49: ...ocument Adding feature licenses This section describes how to update the license file to enable Adaptive Server features To add features for which you have licenses follow the instructions under Enter...

Page 50: ...SySAM administration 40...

Page 51: ...base license 33 boot device 6 bootstrap script 23 C chainging character set 23 changing sort order 23 changing language 23 character set 23 check out procedures 34 command line installer 10 Component...

Page 52: ...11 jISQL 11 20 K kill command 22 L LAN 36 language 23 LDAP 12 license agreement 6 License Entry 11 license keys entering 13 M Mac OS X system requirements 1 Macintosh HD 6 manually starting SySAM 39...

Page 53: ...master device 2 of sybsystemprocs device 2 Small Business Edition 33 Small Business Edition license key 13 SNMP subagent 28 29 sort order 23 SSL 12 starting Adaptive Server 22 stopping Adaptive Server...

Page 54: ...Index 44 viewing servers 17 W WAN 36 X XML 11 XP Server 12 27 XP Server name 1 XP Server port number 1 Xserve 10...

Reviews: