SAP ASE 16.0 Officially Supports HADR
SAP Business Suite on SAP ASE 16.0 officially supports HADR scenarios starting September 19, 2016. This includes support for synchronous replication in addition to near-synchronous and asynchronous replication. For more information, see HADR Availability on SAP Adaptive Server Enterprise 16.0.
New Documents on High Availability
The HADR Users Guide for setting up HADR for SAP ASE 15.7 is available here
. The guide is valid for the SAP Replication Server in general, but also for running SAP Business Suite on SAP ASE in an SAP Replication Server environment with SAP ASE 15.7.
The HADR Users Guide for setting up HADR for SAP ASE 16.0 is availabe here.
SAP ASE 15.7
The following document describes the installation of a disaster recovery solution with two data centers and an SAP system in each data center:
HADR Installation in a Nutshell - Part II
Everyone using SAP Replication Server with SAP ASE and SAP Business Suite should check the following document:
Rolling Database Update in an SAP ASE and SAP Replication Server Environment
SAP ASE 16.0
The following document focuses on installing a disaster recovery solution in two data centers with an SAP system in each data center:
HADR Installation on SAP ASE 16 for SAP NetWeaver ABAP (2 PAS)
This document shows an installation of an HADR solution in one data center with only one SAP System switching between two SAP ASE 16.0 databases:
HADR Installation on SAP ASE 16 for SAP NetWeaver ABAP with Single PAS
Similarly to the Rolling Upgrade document mentioned above, another document will be provided soon for use with Rolling Upgrade scenarios for SAP ASE 16.0. This document will contain rolling upgrade scenarios starting from SAP ASE 16.0 SP02 PL0x to a higher version.
SAP NetWeaver AS ABAP 7.50 SP2 - Developer Edition on SAP ASE
The SAP NetWeaver AS ABAP 7.50 SP2 Developer Edition provides an easy way to explore the database SAP ASE as well as SAP NetWeaver on SAP ASE. Discover the Performance Dashboard in the DBA Cockpit for SAP Adaptive Server Enterprise. This tutorial
introduces the Performance Dashboard, which is part of the DBA Cockpit. The dashboard displays a summary of the most important metrics of the SAP ASE database and can be customized to specific needs.
Try the SAP NetWeaver AS ABAP and SAP BW 7.50 SP02 on ASE Developer Edition.
The aim of this document is to help you get started with the SAP Adaptive Server Enterprise database that is run with SAP applications.
This document describes best practices that are specific to the migration and operation of SAP NetWeaver-based products on SAP Adaptive Server Enterprise (SAP ASE). In addition, this guide provides best practices for SAP Business Warehouse and other SAP applications based on SAP BW, like SCM/APO, SEM, and the SAP Solution Manager.
With SAP ASE 15.7, advanced compression capabilities have been introduced that allow large data volumes to be stored more compactly, thus reducing I/O times. In addition, SAP ASE 16.0 provides an index compression feature which further reduces the overall database size. However, compressing existing databases requires resources and time to rebuild the indexes. This can become a challenge for multi-terabyte databases or environments with extremely high load and limited maintenance windows.
This white paper introduces system administrators to the automatic database expansion feature in SAP Adaptive Server Enterprise. The author will focus on deployments of SAP Business Suite applications running on SAP ASE. With automatic database expansion activated, administrators can further reduce the time needed for administration tasks. More importantly, interruptions to business users can be avoided because the database server can automatically obtain the space resources needed for continuous operation.
An issue has been identified that can potentially cause incorrect results in an SAP Business Warehouse system running on SAP Adaptive Server Enterprise. The problem has been observed whenever the optimization goal 'allrows_dss' or another optimization goal that includes optcriteria 'advanced_aggregation' is used for an SQL statement. This is typically the case for SAP BW systems. SAP ERP systems running on ASE are not affected. In SAP ERP systems, optimization goal 'allrows_mix' has been configured.
Details and corrections are available in SAP Note 2026328 - SYB: Incorrect results with SUM aggregation on decimal fields. We strongly recommend to implement the corrections in SAP BW as soon as possible.
On the Road to an Enterprise Cloud
Customer demands for support of virtualization are rapidly growing. SAP offers support for running its applications in virtualized cloud environments. You can start your projects and can bring the innovations from SAP into production in a matter of weeks instead of months, with complete flexibility of deployment choice. Landscape Virtualization Management (LVM) is available for SAP Business Suite on SAP Adaptive Server Enterprise.
Maintaining tables, indexes and data partitions is crucial for productive database systems. Continuous insertion, update and deletion of data induces fragmentation, bad cluster ratios and inaccurate optimizer statistics. The article shows how the DBA Cockpit and its automatic table maintenance for SAP ASE ensures good cluster ratios on tables and indexes, frees up unused space and ensures accurate optimizer statistics.
General Availability of SAP Adaptive Server Enterprise
SAP Business Suite on ASE is available for SAP Business Suite 7i2010, 7i2011, 7i2013 and 7i2016. For more information, refer to SAP Note 1554717