Installation and Upgrade Guide for Windows - SAP

1 Installation GuidePUBLICSAP Adaptive Server Enterprise SP03 Document Version: 2017-06-19 Installation and Upgrade Guide for WindowsContent1 Installation Download SAP ASE SAP ASE SAP ASE Components and SAP ASE on VMware vSphere SAP ASE Ports for SAP ASE SAP ASE Licensing Your Product SySAM License Knowing the Product License Feature Preparing to Install SAP System Requirements for System Requirements for System Requirements for SAP ASE Installation Directory Contents and SAP Java Runtime Environment .. VMware vSphere Guest Operating Memory Huge Installing SAP Installing SAP ASE in GUI Installing SAP ASE in Console Line Installing SAP ASE Using a Response in Silent and Upgrade Guide for Configuration Postinstallation Set Up sybase User in Verifying That Servers are Verifying Your Connection to the Test the Installation and Network The System Administrator Installing Sample Devices for Sample the Database the interpubs the jpubs Sample Starting and Stopping SAP ASE SAP ASE Considerations When Upgrading from SAP ASE for Component Integration for Moving from SCC to SAP ASE Considerations When Upgrading from a Developer Edition of SAP Upgrade Java in the Upgrade and Runtime Logging.

2 Preparing to Changes in SAP ASE Preupgrade Stored the Database and sybprocsdev Upgrade to SAP ASE SAP ASE on Upgrading SAP and Upgrade an Existing Upgrading in Silent Postupgrade the Text and Image Functionality in SAP ASE After Permissions on System Stored Migrate From 32-Bit to and Upgrade Guide for WindowsContentPUBLIC3 Migrating Data Using a Dump-and-Load Data Using SAP ASE Components and Related Job High Availability and Cluster Java in the Backup Databases Using Dump and Compiled Objects Are Handled When Upgrading SAP SAP ASE Preparing to Downgrade SAP Downgrading from SAP ASE Version Dumping a SP03 Database to Load Into an Older Version of SAP ASE Downgrading Job Post-downgrade Tasks for SAP Uninstalling SAP Removing an Existing SAP ASE Troubleshoot Your Error Logs for

3 Installation Error Logs for SAP ASE Troubleshooting Common Installation the Installation Quits While You Are Configuring an SAP ASE Environment Variable Exceeds Maximum Stopping an SAP ASE Server After a If SAP ASE Fails the Preupgrade Eligibility When an Upgrade You Can Identify the Cause of the Upgrade Databases After a Failed from a Failed You Cannot Identify the Cause of an Upgrade and Upgrade Guide for WindowsContent1 Installation OverviewThis Guide explains how to install, Upgrade , downgrade, and uninstall SAP SAP ASE for the First the system the components and options to a SAP ASE using the GUI mode, console mode, or a response postinstallation to a New Version of SAP your Upgrade eligibility and review system the components and options to the new SAP ASE using the GUI mode, console mode, or a response the preupgrade utility to test Upgrade SAP postupgrade SAP ASESee Uninstalling SAP ASE [page 108].

4 See the configuration Guide for information about configuring attributes of your SAP ASE server, Backup Server, and XP Server to meet your specific and Upgrade Guide for WindowsInstallation Download SAP ASE SoftwareThe SAP ASE Installation and Upgrade packages are available on the SAP Software Download download the Installation media for SAP ASE, go to:Software Downloads INSTALLATIONS & UPGRADES, go to:OptionDescriptionFor a major re leaseBy Alphabetical Index (A-Z)ASAP Adaptive Server EnterpriseSAP ASE your operating system, then choose the Installation package from the bottom of the support pack ages an patchesBy Alphabetical Index (A-Z)ASAP Adaptive Server EnterpriseSAP ASE Packages and PatchesSAP ASE SERVER your operating system, then choose the support package or patch from the bottom of the SAP ASE EditionsAnalyze your system and scalability requirements to determine which edition of SAP ASE is appropriate for your ASE Editions Enterprise edition has no limit on scalability and supports all of the options that can be purchased or licensed separately.

5 Platform edition has no limit on scalability. Some options are included and others can be purchased or licensed separately. Does not include the Disaster recovery package. Edge edition has limited scalability, and supports a limited set of the options that are purchased or licensed separately. Express edition (Linux x86-64 platform) has limited scalability, memory, and database size. Enterprise edition, free evaluation See Download SAP ASE Enterprise Edition and Upgrade Guide for WindowsInstallation OverviewNoteFor a complete list of SAP ASE editions, see SAP ASE the EditionUse sp_lmconfig 'edition' to determine the edition that is currently Editions and Optional Features The SAP ASE installer automatically installs a SySAM license server if you choose the full Installation option or enter a served license when prompted for the SySAM license key.

6 You can also install the license server using the installer's custom Installation option. For more information, see the SySAM Users SAP ASE Components and UtilitiesSAP ASE is based on a client/server model, communicating with its clients over the network via the Tabular Data Stream (TDS) protocol. Each client process may execute on one machine and communicate with a database server on the same or a different ASE runs as an application on top of an operating system. The hardware that the operating system runs on is completely transparent to SAP ASE, which sees only the operating system's user interfaces. To enhance performance on multiprocessor systems, configure multiple processes (engines).SAP ASE is divided into a database management system (DBMS) component and a kernel component. The kernel component uses the operating system services for process creation and manipulation, device and file processing, and interprocess communication.

7 The DBMS component manages SQL statement processing, accesses data in a database, and manages different types of server for SAP ASEFor download and Installation instructions, see 2093510 How to Download Free SDK for SAP ASE [ Windows , Linux, Unix]. For more information, see SAP Open Server and SDK for SAP ASE New Features and Upgrade Guide for WindowsInstallation OverviewPUBLIC7 SySAM UtilitiesThe SySAM utilities are available from the SAP ASE Installation image and installed in the SAP ASE top level directory. See Licensing Your Software [page 12] and the SySAM User Server Admin UtilityInstall this component from the SAP ASE Windows 64 this components from the SAP ASE server image Running SAP ASE on VMware vSphere can install and run SAP ASE on VMware vSphere to the VMware Compatibility Guide to view hardware supported by VMware. The performance of SAP ASE may depend on the vSphere configurations for the hardware you choose.

8 Refer to VMware published best practices for running vSphere on the SAP ASE CockpitSAP ASE cockpit provides a single, comprehensive, Web-administration console for real-time performance, status, and availability monitoring of large-scale SAP enterprise ASE cockpit includes historical monitoring, threshold-based alerts and notifications, alert-based script execution, and intelligent tools for identifying performance and usage trends. SAP ASE cockpit is designed as an onboard management solution, where you install the cockpit on each SAP ASE host to manage and monitor that ASE cockpit is installed as part of an SAP ASE server Installation . The SAP ASE cockpit agent continually broadcasts information about the server to subscribing clients via the SAP ASE cockpit framework. Messages from the Web client pass through the SAP ASE cockpit framework to the agent, which in turn, processes the request on the SAP ASE ASE cockpit is free of charge to customers who have a paid license for SAP detailed SAP ASE cockpit information, see theSAP Adaptive Server Enterprise Cockpit documentation, which includes SAP ASE configuration procedures, user assistance, and troubleshooting and Upgrade Guide for WindowsInstallation Network Ports for SAP ASE CockpitCheck the ports used on the Installation machine for conflicts with the ports SAP ASE cockpit SE cockpit uses TCP ports for a variety of services.

9 If another application is using one of the ports listed here, the cockpit may fail to start, or its services might not work properly. You can use --info ports to list ports currently in use (by any application or server).Table 1: Network Port Requirements for SAP ASE CockpitPort NameDefault Port NumberRequired?DescriptionRMI4992 YesServer port used for RMI pro tocol port used for HTTP Web access to the server. All HTTP traffic is redirected to the secure HTTPS port used for secure HTTPS Web access to the server. All HTTP traffic is re directed to the secure HTTPS repository database port; used by several serv Service4993 YesServer messaging port used for Tabular Data Stream (TDS) protocol Http9092 NoJini HTTP port for Jini discov ery Rmid9095 NoJini RMID server port for Jini discovery discovery service adapter and Upgrade Guide for WindowsInstallation SAP ASE OptionsSAP offers various optional features for SAP ASE, such as data compression, partitions, and encrypted 2: SAP ASE OptionsOptionDescriptionDatabase MemScaleThe MemScale option is a licensed option introduced in SAP ASE version SP02 as part of the SQL Server Administration group.

10 This option includes various features, in cluding: Compiled queries (simplified native access plans) Transactional memory Latch-free indexesIf you have a license for the SAP ASE In Memory Database feature, MemScale includes this all of the features included in the ASE_MEMSCALE license by turning the sp_config enable mem scale option you enable an individual feature that is part of the MemScale option, the li cense manager verifies that you have the ASE_MEMSCALE license, and that you have enabled the enable mem scale configuration Memory DatabaseFully integrated within SAP ASE, this option equips applications with instant responsive ness and very high throughput. SAP ASE in-memory databases have zero-disk footprint and reside completely in enterprises to recover from adverse events by restoring operations as quickly as possible and recovering as much information as possible, reducing the return to op erations and mitigating data loss.