SAP ASE 16 / Sybase ASE Administration

Jeffrey Garbus has a B.S. from Rensselaer Polytechnic Institute, and has worked with everything from PCs to mainframes and back again. He has decades of client/server, Sybase, and Microsoft SQL Server experience, with a special emphasis on assisting clients in migrating from existing systems to pilot and large-scale projects with very large databases. Jeff has spoken at user conferences and user groups since the early 1990s, has written articles and columns for many magazines nationally and internationally, and has about 20 books to his name. Recently, his focus has been on database performance, tuning, monitoring, and reengineering. Jeff has been in consulting, training, and the software businesses for more than two decades. He has a demonstrated talent for staying at the leading edge of technology, as well as transferring his knowledge to others. You can contact Jeff at jeff@soaringeagle.guru.

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