SAP Adaptive Server Enterprise 16.0 System Administration Guide: Volume 2

This guide describes the planning and implementation of resource limits in SAP® Adaptive Server® Enterprise 16.0.


SAP Adaptive Server Enterprise 16.0 System Administration Guide: Volume 2 - cover page
Brand
SAP
Category
Other software
Document type
User Manual
Language
English
Pages
476
File format
PDF
File size
3 MB
Published
03 November, 2023
Updated
03 November, 2023
MD5 checksum
E80819BBDC72DB64408F79960E91C6DE

About this manual

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.

What's inside

  • Limiting Access to Server Resources
  • Mirroring Database Devices
  • Configuring Memory
  • Configuring Data Caches
  • Managing Multiprocessor Servers
  • Creating and Managing User Databases
  • Database Mount and Unmount
  • Distributed Transaction Management

Frequently asked questions

What topics are covered in SAP ASE 16.0 System Administration Guide: Volume 2?

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.

How do I move databases from one SAP ASE to another?

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.

How do I limit I/O cost, elapsed time, and result set size for users in SAP ASE?

The guide explains limit types including io_cost, elapsed_time, and row_count, and how to create, modify, and drop resource limits.

How do I place the transaction log on a separate device in SAP ASE?

Chapter 6, Creating and Managing User Databases, includes instructions for placing a transaction log on a separate device and estimating the transaction log size.

Download PDF (3 MB)

More SAP Manuals


View all SAP manuals →