Development Update - SAP on ASE

October 21, 2015

Public
Development Roadmap 2015

SAP ASE 16 SP01

 Introduction of index compression and create indexes in parallel online
 Additional enhancements for SAP BW (parallel query)

SAP ASE 16 next update

 Introduction of SAP Business Suite enhancements adapted to SAP ASE 16

SAP Applications
 Optimization of system operations reducing effort and down time (TCO) / permanent effort
 SAP Zero Downtime Option Support (ZDO)
 Support of SAP Core Data Services

High Availability to ensure resilience of the ASE platform with synchronous replication to enable zero data loss
(planned for SAP ASE 16 only)

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 2

New Graphical JavaScript-Based SQL Statement EXPLAIN

The performance of a database depends on the configuration of the instance, the database design and the formulation of SQL
statements. The SQL Statement EXPLAIN helps customers to find answers to questions, such as Why is this query running
slow? The query optimizer attempts to calculate the most efficient way to execute an SQL query. The SQL Statement EXPLAIN
is the representation of this attempt. It can be visualized in the form of a text or a graph.

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 3

DBA Cockpit – Job Scheduling

The DBA Planning Calendar has been enhanced with specific jobs to execute database backups, transaction log dumps, table
reorganizations and table statistics updates.

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 4

DBA Cockpit – ASE Configuration Check

The ASE configuration check located under Configuration → SAP Configuration Check automatically validates the ASE
configuration. The tool checks whether the configuration corresponds to the settings required or recommended to run SAP on
ASE (see SAP Note 1539124).

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 5

DBA Cockpit – Definition of Resource Limits
The DBA Cockpit can be used to configure the ASE Resource Governor. Resource limits can be defined in screen Configuration
→ Resource Limits. Screen Performance → Resource Limit Violations allows you to analyze resource limit violations that have
occurred in the system.

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 6

DBA Cockpit – New Data Collector Indexes

Two new screens: Performance → I/O → Index I/O and Space → Tables and Indexes → Indexes. This allows historical
monitoring of index usage and space allocation.

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 7

DBA Cockpit – New Data Collector Data Cache Objects

New screen: Performance → Memory → Data Cache Objects

This allows historical monitoring of memory allocated by each object in the ASE data cache(s).

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 8

DBA Cockpit – Enhanced Data Collector Statement Cache

The data collector Statement Cache has been enhanced with an option to also collect query plans. This allows to review and
compare not only currently cached query plans, but also query plans that were used by ASE in the past.

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 9

© 2015 SAP SE or an SAP affiliate company. All rights reserved. 10
© 2015 SAP SE or an SAP affiliate company. All rights reserved. 11
SAP ASE Versions

Product Minor Version Minimum Level Latest Level

Sybase ASE 15.7 for Bus. Suite SP1xx SP134* SP135

Sybase ASE Client 15.7 ODBC / JDBC SP1330 / EBF24376* SP1330 / EBF24376

SAP Replication Server 15.7.1 SP1xx SP121* SP133

SAP ASE 16 for Bus. Suite GA (SP00) SP01 PL01* SP01 PL02

SAP ASE 16 DBClient Bus.Suite ODBC / JDBC SP01 PL01 / EBF24040* SP01 PL02 / EBF24040

SAP Replication Server 15.7.1 SP2xx (not released yet) SP20x SP20x

ASE clients (ODBC, JDBC) are stripped down to the use with SAP BS (Thin Client)
* The minimum level has been increased due to security requirements. Preceding versions are still supported, but SAP recommends to use the newest
versions. Maintenance is limited to the recommended levels. For more information, see SAP Note 1590719 and the referenced SAP Notes.
** Support until Q4/2015
© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 12
SAP ASE with SAP NetWeaver and SAP Business Suite

SAP Business Suite 7i2010 ECC 6.05 CRM 7.01 SRM 7.01 SCM 7.01

SAP Business Suite 7i2011 ECC 6.06 CRM 7.02 SRM 7.02 SCM 7.02

SAP Business Suite 7i2013 ECC 6.07 CRM 7.03 SRM 7.03 SCM 7.03

SAP NetWeaver 7.02

SAP NetWeaver 7.03
SAP NetWeaver 7.2
SAP NetWeaver 7.3
SAP NetWeaver 7.31
SAP NetWeaver 7.4
SAP NetWeaver 7.5
For more information, see SAP Note 1554717.

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 13

SAP ASE: SAP NetWeaver and SAP Business Suite Platforms
Platform Availability Matrix

Application server /
AIX HP-UX Linux Solaris Windows
operating system

Operating system SLES11/SLES12 Win2008 (R2) &

7.1 11.31 10 & 11
versions RHEL6/RHEL7 Win2012 (R2)

Hardware Power IA64 x86_64 Sparc X64

XEN, MS HyperV,
Virtualization PowerVM vPars
KVM, VMWare
Containers
VMWare

SAP Kernel: 7.21_EXT, 722_EXT, 7.40, 7.41, 742, 7.45 - Unicode only!

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 14

High Availability Offerings with SAP ASE

Platform HA Offering available

All OS Platorms Symantec VCS: White Paper available for each supported platform

AIX IBM Power HA: Support planned at a later time

HP-UX HP Service Guard (SAP Note 1650511)

Linux Solution based on Open Cluster

Microsoft MS Cluster Solution Support

© 2015 SAP SE or an SAP affiliate company. All rights reserved. Public 15

© 2015 SAP SE or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate
company) in Germany and other countries. Please see http://global12.sap.com/corporate-en/legal/copyright/index.epx for additional trademark information and notices.

Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors.

National product specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP SE or its
affiliated companies shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP SE or SAP affiliate company products and
services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as
constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop
or release any functionality mentioned therein. This document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future
developments, products, and/or platform directions and functionality are all subject to change and may be changed by SAP SE or its affiliated companies at any time
for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-
looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place
undue reliance on these forward-looking statements, which speak only as of their dates, and they should not be relied upon in making purchasing decisions.

© 2015 SAP SE or an SAP affiliate company. All rights reserved.