- ホーム
- > 洋書
- > 英文書
- > Computer / General
Full Description
Skip the marketing jargon, and jump right into the heart of the major tasks for administering SAP ASE 16. Starting with an introduction to the database and an installation overview, this book is packed with you'll use on any platform. Get the information you need to define database storage areas, create database elements, work with security and user roles, manage backup and restoration, achieve high availability, and more. SAP ASE 16: Get all of the details for the newest release of ASE, including high availability and DBA tools. Core Database Tasks: Cement your administration skills on topics like data partitioning, preventative maintenance, memory configuration, and more. SAP ASE-Specific Tools: Every database is different. Learn how SAP ASE provides tools like the Logical Process Manager to prioritize resources, the Query Processor for cost-based optimization, and the Replication Server for syncing. Highlights:
Database logging and recovery
Security
Auditing
Named caches
Remote procedure calls
SAP ASE connectivity
Resource Governor
High availability and disaster recovery
Remote server management
Memory configuration
Contents
Acknowledgments
Preface
Introduction to SAP ASE System Administration
Introduction to SAP ASE 16
Placement within the SAP Landscape
Architecture Overview
SAP ASE 16: Key Features
SAP ASE Key Capabilities
Summary
Installation and Connectivity
Preparation
File Transfer
Running Installation
Installation Files
Frontend Installation
Starting the Server
Shutting the Server Down
Summary
Defining Physical and SAP ASE-Mirrored Devices to the Server
Creating and Dropping Devices
SAP ASE Mirroring
Volume Management
Summary
Defining Databases and Logs
Database Structures
System Databases
Working with the Database
System Tables
Summary
Database Logging and Recovery
Transactions
The Transaction Log
Summary
Security, User Administration, and Roles
SAP ASE Security Levels
Standard Roles
Server Roles
User-Defined Roles
Login Activities
Commands
Object Permissions
Access Rules
Column Encryption
Summary
Auditing
Installation Overview
The sybsecurity Database and Tables
Audit Storage
Querying the Audit Trail
External Applications and Third-Party Software
Additional Tips on How to Effectively Audit
Summary
Backing Up and Restoring
Roles and Responsibilities
Backup Types
Backup Server
Dumping the Database
Loading the Database
Monitoring the Transaction Log
Dumping Transactions
Loading Transactions
Restoring the Master Database
Cumulative Dumps
Dumping and Loading Across Platforms
Quiesce Database
Database Recovery Scenarios: Q&A
Miscellaneous Topics
Summary
Resource Governor
Enabling Resource Limits
Time Ranges
Creating a Limit
Limit Hierarchies
System Tables
Summary
Logical Process Manager
Purpose of the Logical Process Manager
Logical Process Manager Execution Classes
Logical Process Manager Procedures
Thread Pools and Engine Groups
Logical Process Manager Conflicts and Precedence
Summary
Memory Configuration and Tuning
SAP ASE Releases
SAP ASE Configuration Basics
Summary Table of Memory-Related Variables
Recommended Configuration Settings
Summary
Data Cache
Named Caches
Buffer Pools
Binding
How to Tune Caches
Summary
Semantic Data Partitioning
Why Use Data Partitioning?
Types of Partitioning
How and When to Use Data Partitioning
Local versus Global Indexes
Working with Partitions
Some Uses for Semantic Partitioning
Summary
Remote Server Management
Remote Procedure Call
Component Integration Services
Summary
Preventative Maintenance Regimen
Server-Level Maintenance
Database-Level Maintenance
Table-Level Maintenance
Summary
High Availability and Disaster Recovery
Definitions and Causes
Broad Approaches to High Availability and Disaster Recovery Planning
Architecting the System for Availability and Recoverability
DBA and User Activity
Backup Strategies
Cold Standby: Dump Shipping
Warm Standby: SAP Replication Server
Hot Standby: Clustering
Summary
SAP Replication Server
Advantages of SAP Replication Server
New Features in SAP Replication Server (Support Packages Series)
Replication Methods
Components and Features
Installation of SAP Replication Server
Setting Up Warm Standby
Troubleshooting Overview
Summary
Introduction to Query Optimization
Changes in SAP ASE 16
Query Optimization Process
Layers of SAP ASE 16
Query Processor and the I/O Size
Query Optimization and the Performance Impacts on Tuning
Automatically Updating Statistics
Changing Rules for LRU and MRU in Query Optimization
Summary
SAP ASE In-Memory Database
Use Cases for SAP ASE IMDBs
Difference between SAP ASE IMDB and Traditional SAP ASE
Operations Supported By Different Database Configurations
Creating and Managing Relaxed Durability Databases
Summary
Tools
Bulk Copy Program
defncopy Command Tips
Extract Creation Script (ddlgen)
Command Parser (isql)
Display System Table Information (optdiag)
Interactive SQL
Summary
Appendices
Tips and Tricks
System-Specific Recommendations
Database Maintenance
Performance Tuning
Common Problems and Solutions
Security
DBA Commands: Reference Sheet
Acknowledgements
Troubleshooting
The Server Won't Come Up
Some Users Claim the Server Stopped
Server Is Up, Some Users Can't Gain Access
Processing Slows Down or Stops
Some Database(s) Can't Be Accessed
Users Can't Access Objects
Other Resources
The Authors
Index
