. Quick Installation Guide Adaptive Server Enterprise 12.5.x Mac OS X.
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. Viewing servers that 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 Adaptive Server. 22 Rebuilding Adaptive Server. Configuring trap generation from Adaptive Server.30 Troubleshooting the installation. 31 Uninstalling Sybase software.32 Further reading.32 CHAPTER 2 Sybase Software Asset Management. 33 SySAM overview.33 Adaptive Server base license.33 Adaptive Server check-out procedure.34 Utilities.35 Starting Adaptive Server with optional features. Instructions for installing optional Adaptive Server functionality, such as auditing, and sample databases, and localization information Audience This guide is written for Sybase System Administrators and other qualified personnel who are familiar with their system’s environment, networks, disk resources, and media devices.
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 sample pubs2 pubs3 databases. Monitor Client Library Programmer’s Guide – describes how to write Monitor Client Library applications that access Adaptive Server performance data. Other sources of Use the Sybase Technical Library CD and the Technical Library Product information Manuals Web site to learn more about your product:. Specify a time frame and click Go.
Select a product. Click an EBF/Update title to display the report. To create a personalized view of the Sybase Web site (including support pages) Set up a MySybase profile. MySybase is a free service that allows you to create a personalized view of Sybase Web pages. If you need help Each Sybase installation that has purchased a support contract has one or more designated people 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 Sybase subsidiary in your area. Hard disk – At least 700MB of available disk space. Preinstallation system setup The following items are predetermined by the installer:. Installation directory – /Applications/Sybase.
Hostname – yourhost (obtained dynamically via ‘hostname -s’. Adaptive Server name, port number – hostnameASE, 11222.
Preinstallation system setup. device pathname – master /Applications/Sybase/System/devices/master.dat. device size – 100MB master. device pathname – sybsystemprocs /Applications/Sybase/System/devices/sybprocs.dat. device size – 160MB sybsystemprocs. Server page size – 4096 bytes.
Chickering and sons piano serial numbers. Chickering and Sons is a Boston-based piano manufacturing company which is known for their award-winning pianos and music instruments of topnotch quality.
Server default character set – iso1 Upgrading from the early adopter release Upgrading from the Early Adopter release is not supported. (NFS-mounted file system), and then review “Installation on Xserve” on page 10. Downloading the software The Sybase Web site is located at Select the Download Now button. You are asked to answer a few questions and provide registration information.
Xserve” on page 10. Installation This section describes the steps required to install Adaptive Server on Mac OS Figure 1-1shows the Introduction page, which identifies this package as the Sybase Adaptive Server. To move to the next page, click Continue.
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. Installation Figure 1-3: Software license agreement 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 From the next window, select Macintosh HD (which may vary on some machines.) This is the required boot device. 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. Figure 1-7: Processing Adaptive Server 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. Installing Adaptive Server Figure 1-8: Processing databases and stored procedures 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/SybaseASE12502.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. Sybase Server Discovery – uses Rendezvous technology to display the name and location of all servers running on your network.
Each Sybase server registers itself with Rendezvous when it starts, and Sybase Server Discovery shows you where each of these servers is located. Also, the Configuration option allows you to automatically generate and update entries in the interfaces file, for each server selected in the list. 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:. 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. Entering license keys Figure 1-10: License Entry icon 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. Execute the startd.sh script located in /Applications/Sybase/Systems/SYSA-10 from the terminal window. The license daemon needs to be started after the system is restarted. If you click No, when asked whether you have any Sybase Software Asset Management Certificates to enter, the following screen is displayed.
“Sybase Software Asset Management” for more details. Environment variables Add entries to your login script (.login) so that Sybase environment variables area always set. An example of this is contained in /Applications/Sybase/System/SYBASE.csh. If you do not have a.login script in your home directory, you can use the.cshrc file. 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.
Click Server Discovery from the Finder: Figure 1-14: Service discovery tool. 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/OCS- 125/sample/srvlibrary, contains an example of how to register an Open Server™.
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.
Sybase Adaptive Server Anywhere Download
Password – leave blank. Hostname – servernameASE. Portnumber – 11222. 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. See “Setting the System Administrator password” on page 21 for more information. Sybase Central has online help files.
To access the online help for a server, right-click the server icon, and select Online Help from the drop-down list. To access online help for Sybase Central, select Help from the menu bar, then select Sybase Central Help. Once the server is stopped, you can restart it in one of two ways:. Open the Terminal window, and execute the command found in startserver /Applications/Sybase/System/ASE-125/install: startserver -f RUNhostnameSYBASE. From the Finder, double-click the Startservername.command file in /Applications/Sybase. The command file is recognized by the Finder as a shell script. You need to change the size of the pages within the database.
You can rebuild the server in one of two ways:. Using the bootstrap shell script in /Applications/Sybase/System/ASE- 125/install – you can edit this script to take action as necessary. The script installs a new server using which is driven by a resource file. You can charset use this utility only from the UNIX shell, so you must open a Terminal window. The utility is found at /Applications/Sybase/System/ASE-125/bin/charset. To change Adaptive Server’s defaults: Run the utility to add the character set to Adaptive Server’s system charset catalogues., see the Reference Manual. This script spsyntax includes syntax information for Transact-SQL, the system procedures, and the Sybase utilities.
When you execute this script, you install the SQL portion of database. Sybsyntax When you first execute this script, it creates the. Execute: isql -Usa -Ppassword -Sservername -i$SYBASE/$SYBASEASE/scripts/inssynsql where sa is the user ID of the System Administrator, password is the System Administrator’s password, and servername is the Adaptive Server on which you plan to install the database.
To ensure that you have installed the. 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. In /Applications/Sybase/System/Install/StartupItems, more the following directories to /Library/StartupItems to enable the associated services to automatically start when the system is restarted:.
Installation Net-SNMP Master Agent The sybase SNMP Subagent uses the Agent X protocol for extending the capabilities of a master agent. It works with any master agent that implements the Agent X protocol.
Included with this subagent is a distribution of the Net- SNMP master agent. Sybase subagent.Typically, the subagent resides on the same machine as the monitored server. The snmpagent.cfg file contains documentation for configuration settings. To test the Sybase subagent, you can start it from the command line by executing: java -jar $SYBASE/SNMP-10/lib/SybaseAgent -c $SYBASE/SNMP-10/snmpagent.cfg. Configuring trap generation from Adaptive Server The Sybase subagent allows a Sybase server to generate a trap through a remote procedure call,. When the remote procedure is called, a sperrornotify 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. These values can be retrieved from the sperrornotify aseErrorTable table definition in SYBASE-MIB.
Troubleshooting the installation Please refer to the Release Bulletin for a complete list of known problems. If you cannot connect to the server, there are several things that you should check:. /Applications/Sybase/System/Install. This script removes everything in /Applications/Sybase. Use it carefully.
Note 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.
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 you start Adaptive Server version 12.5, it attempts to locate the license file license.dat located in $SYBASE/$SYBASESYSAM/licenses. If the file does not exist, Adaptive Server looks for the license file specified in the environment variable LMLICENSEFILE., to manage licensing activities, and two daemons – the license lmutil management daemon ( ) and the vendor daemon (SYBASE).
The lmgrd daemons handle requests to check in or check out licensed features. Using information in the license file, Adaptive Server connects to SySAM and attempts to check out a license (ASESERVER or ASESBE) for the base Adaptive Server product. Adaptive Server check-out procedure Table 2-1: Configuration parameters for optional features Configuration Feature name License name parameter Java in ASE ASEJAVA enable java External File System ASEXFS enable file access By default, the configuration parameters for optional features are set to 0 (off).
To enable an optional feature use to set its configuration spconfigure. CHAPTER 2 Sybase Software Asset Management As part of a failover plan or a load-balancing system, Redundant servers 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 wide- area network (WAN). 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.
After the installation is completed, and for each server in the redundant system, set the LMLICENSEFILE environment variable to: 'port@machine:port@machine:port@machine'. 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. Adding feature licenses This section describes how to update the license file to enable Adaptive Server features.
SySAM administration. Index changing sort order Adaptive Server changing language base license character set check-out procedures check-out procedures connecting via Sybase Central command line installer default character set Component Integration Services optional features configuration page size hard disk starting memory stopping contents. Index LDAP license agreement full-text search License Entry license keys entering hard disk configuration headless systems high availability Mac OS X Historical Server system requirements host name Macintosh HD manually starting SySAM master device pathname master device size memory requirements installation MIB files downloading software for. System Administrator starting Adaptive Server path stopping Adaptive Server for master device stopping the installation pathname Sybase Central for sybsystemprocs Sybase Server Discover port number SybaseCentral of Adaptive Server sybmigrate of Backup Server sybsyntax database of XP Server sybsystemprocs device pathname. Index viewing servers XP Server 12, 27 XP Server name XP Server port number Xserve.
From Sybase Adaptive Server Enterprise (ASE) 12.5.1 on the Mac OS X platform, is designed to support the demanding requirements of transaction-intensive, mission-critical OLTP and decision support applications while delivering innovations that meet the emerging needs of e-Business. ASE for Mac OS X provides the Mac community with the ability to run client/server applications on a single operating system, running on hardware that spans from iBook to Xserve. Additionally, ASE gives Mac users the flexibility to run client/server applications on a mixture of Mac and virtually any other software or hardware OS platform. Sybase ASE is the product of choice for mission-critical applications requiring high performance, reliability and scalability. With complete support for Mac OS X, ASE 12.5.1 offers superior database capabilities, including Java and XML support with a dramatically lower total cost of ownership. This version is the first release on CNET Download.com. Full Specifications What's new in version 12.5.1 This version is the first release on CNET Download.com General Publisher Publisher web site Release Date February 27, 2008 Date Added February 27, 2008 Version 12.5.1 Category Category Subcategory Operating Systems Operating Systems Mac/OS X 10.3 Additional Requirements Mac OS X 10.3 Download Information File Size 443.43MB File Name SybaseASE1253ESD1.dmg Popularity Total Downloads 4,793 Downloads Last Week 2 Pricing License Model Free Limitations Not available Price Free.
Export Control Restrictions You acknowledge that the Software is subject to the export control laws and regulations of the United States of America, including any amendments thereof, and may include technical data also subject to export and re-export restrictions imposed by U.S. You confirm you will not export or re-export the Software, directly or indirectly, either to:. Rar zip free download.
any countries that are subject to U.S. Export restrictions, or. any end user who you know or have reason to know will utilize them in the design, development or production of nuclear, chemical or biological weapons, or. any end user who has been prohibited from participating in U.S. Export transactions by any federal agency of the U.S.
By clicking the DOWNLOAD THE SOFTWARE button, you agree to comply with the export restrictions described above. SAP DEVELOPER CENTER MASTER SOFTWARE DEVELOPER LICENSE AGREEMENT Please scroll down and read the following SAP Developer Center Software Developer License Agreement (“ Developer Agreement”) carefully. By clicking “I Accept” or by attempting to access or use the SAP Software, You agree that this Developer Agreement forms a legally binding agreement between You (“ You” or “ Your”) and SAP SE, for and on behalf of itself and its subsidiaries and affiliates (as defined in Section 15 of the German Stock Corporation Act) (“ SAP”) and You agree to be bound by all of the terms and conditions stated in this Developer Agreement. If You are trying to access or download the SAP Software on behalf of Your employer or as a consultant or agent of a third party (either ' Your Company'), You represent and warrant that You have the authority to act on behalf of and bind Your Company to the terms of this Developer Agreement and everywhere in this Developer Agreement that refers to ‘You’ or ‘Your’ shall also include Your Company. If You do not agree to these terms, do not click 'I Accept', and do not access or use the SAP Software. DEFINITIONS: “ Content” shall mean code, models, applications, configurations, data, or other electronic materials created by You using the Tools and/or any SAP Software licensed hereunder.
“ Excluded License” shall mean an open source or other software license that requires, as a condition of license, use, modification, distribution or conveyance, that (a) the code be disclosed or distributed in source code form; (b) others have the right to modify or create derivative works of it; and/or (c) it becomes redistributable at no charge.
Business climates are changing, and organizations must provide an infrastructure that can quickly adapt to those changes. Successful organizations work smarter and faster with greater agility and flexibility. Cloud fundamentally changes the way IT builds new apps, delivers services and consumes compute and software resources.
In its many forms (public, private or hybrid), cloud computing is quickly becoming both the delivery and consumption models for IT. However, getting the correct mix between traditional IT, private cloud and public cloud can be a challenge. The new IBM Power Systems™ E850C, E870C and E880C, with OpenStack based cloud management and open source automation, enable clients to accelerate the transformation of their IT infrastructure for cloud while providing tremendous flexibility during the transition. These powerful, high performance systems provide clients increased security, high availability, rapid scalability, simplified maintenance and management. It also enables business growth and dramatically reduces costs. The Power® E850C, E870C and E880C systems management capabilities speed up and simplify cloud deployment by providing fast, automated virtual machine (VM) deployments, pre-built image templates and self-service capabilities with an intuitive, user-friendly interface.
1 Calculated over 5 years; compares what a client would pay for hardware and software maintenance over 5 years on earlier POWER technology to what they will pay for POWER8 technology over the same 5 year period after migration to E870C or E880C. 2 Performance guarantee: POWER8 E880 (4.35 GHz) and E870 (4.19 GHz) systems delivers at least 72% greater per core performance vs. POWER7 and POWER6 systems. 72% greater per core performance means that an application will run with substantially similar performance on an eligible machine with less than or equal to 58% of the number of cores on the compared machine. The enhanced performance of POWER8 E880 and E870 systems is designed to lower infrastructure (e.g.
Hardware, space, energy) and software licensing costs and provide capacity for new workloads. Compensation: IBM will provide additional performance optimization and tuning services consistent with IBM best practices. If unable to reach guaranteed level of performance, IBM will provide additional hardware (core activations) and operating systems licenses to reach the guaranteed level of performance. 3 Source: ITIC 2016 Global Server Hardware Server OS Reliability Results, Updated January 2016.