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.
The aim of this document is to help you get started with the SAP Adaptive Server Enterprise (ASE) database that is run with SAP applications.
Over the past years, SAP ASE has supported a number of high availability solutions that work as a complement to hardware solutions in providing reduced downtime and recovery effort for applications. ASE HADR in SAP ASE 16 will enhance the offerings, bringing the same transparent client failover, zero data loss, and ease-of-use capability that cluster systems enjoy with ASE installations that are long distances apart.
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.
SAP 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, and 7i2013.
For more information, refer to SAP Note 1554717.
|ASE CE Cluster Startup with XML file 3 hours ago in SAP Adaptive Server Enterprise (SAP ASE) for Custom Applications||by Javier Barthe|
|Re: ASE displaying high %MEM in 'top' 3 days ago in SAP Applications on SAP Adaptive Server Enterprise (SAP ASE)||by Jade Cloete|
|ODATA services in ASE 5 days ago in SAP Adaptive Server Enterprise Developer Center||by Mahesh Gadgil|
|Re: ASE displaying high %MEM in 'top' 1 week ago in SAP Applications on SAP Adaptive Server Enterprise (SAP ASE)||by Jade Cloete|
|Re: ASE displaying high %MEM in 'top' 1 week ago in SAP Applications on SAP Adaptive Server Enterprise (SAP ASE)||by Jeff Tallman|
|Getting Started with SAP Applications Using SAP Adaptive Server Enterprise 1 week ago||by Anne Lanfermann|
|Backup challenges on Sybase 1 year ago||by Frederich Murador|
|DBA Cockpit: Automatic Table Maintenance for Sybase ASE 8 months ago||by Andreas Zimmermann|
|ASE 16: SAP (SYBASE?) BRAND NEW RELEASE… 3 months ago||by Andrew Melkonyan|
|Configuring Automatic Database Space Expansion in SAP Adaptive Server Enterprise 2 weeks ago||by Markus Ohly|