This guide describes the planning and implementation of resource limits in SAP® Adaptive Server® Enterprise 16.0.
This is Volume 2 of the System Administration Guide for SAP Adaptive Server Enterprise (SAP ASE) 16.0, a database server administration manual published by SAP AG (Document ID DC31644-01-1600-01, last revised May 2014). It is written for system administrators who manage SAP ASE servers.
The guide covers limiting access to server resources through resource limits and time ranges, mirroring database devices for recovery, configuring memory and data caches, managing multiprocessor (SMP) servers and engines, creating and managing user databases, mounting and unmounting databases across servers, and distributed transaction management including XA-compliant coordination services.
It covers resource limits, database device mirroring, memory and data cache configuration, multiprocessor server management, user databases, database mount and unmount, and distributed transaction management.
Chapter 8 of the guide describes mounting and unmounting databases, including moving databases from one SAP ASE to another using a manifest file and device verification.
The guide explains limit types including io_cost, elapsed_time, and row_count, and how to create, modify, and drop resource limits.
Chapter 6, Creating and Managing User Databases, includes instructions for placing a transaction log on a separate device and estimating the transaction log size.