SYSTEM AND DATABASE ADMINISTRATION: SAP SYBASE ASE 16
Duration: 5 days
Goals:
1. Manage physical data replacement and storage
2. Create, backup and restore databases
3. Create and manage multiple temporary databases
Content:
1. SAP Adaptive Server Enterprise (ASE)
Explaining SAP ASE
Describing the Database Architecture
Using Query Editors
2. Installation
Installing Servers
Identifying Installation Parameters
Starting and Stopping SAP ASE
Connecting Clients to the Server
3. Database Server Configuration
Explaining the Server Configuration File
Modifying the Server Configuration File
Explaining Memory Mechanisms
Configuring Memory
Configuring the Size of Caches
4. Space Management
Creating Devices
Managing Devices
Mirroring Devices
Creating Databases
Managing Databases
Managing Disk Resources
Managing Temporary Databases
5. Security
Managing Roles
Creating Logins
Managing Logins
Managing Database Users
Managing Creation Permissions
Managing Object Permissions
Creating Groups
Creating Roles
6. Maintenance
Using SAP ASE Extraction Utilities
Using the Bulk Copy Utility
Explaining Automatic Recovery
Ensuring Database Consistency
Setting Up the High Speed Consistency Checker
7. Backup
Planning for Backups
Executing Database Backups
Restoring Database Backups
Performing Transaction Log Backups
Using Advanced Backup Techniques
8. Monitoring
Using SAP DB Cockpit
Monitoring SAP ASE