Objectifs

• Manage physical data replacement and storage
• Create, backup and restore databases
• Create and manage multiple temporary databases

Public

• Database Administrator
• System Administrator

Pré-requis

EDB116 or equivalent knowledge

Post-Formation

Méthodes

80% Pratique et 20% Théorie

Programme

• SAP Adaptive Server Enterprise (ASE)
• Explaining SAP ASE
• Describing the Database Architecture
• Using Query Editors
• Installation
• Installing Servers
• Identifying Installation Parameters
• Starting and Stopping SAP ASE
• Connecting Clients to the Server
• Database Server Configuration
• Explaining the Server Configuration File
• Modifying the Server Configuration File
• Explaining Memory Mechanisms
• Configuring Memory
• Configuring the Size of Caches
• Space Management
• Creating Devices
• Managing Devices
• Mirroring Devices
• Creating Databases
• Managing Databases
• Managing Disk Resources
• Managing Temporary Databases
• Security
• Managing Roles
• Creating Logins
• Managing Logins
• Managing Database Users
• Managing Creation Permissions
• Managing Object Permissions
• Creating Groups
• Creating Roles
• Maintenance
• Using SAP ASE Extraction Utilities
• Using the Bulk Copy Utility
• Explaining Automatic Recovery
• Ensuring Database Consistency
• Setting Up the High Speed Consistency Checker
• Backup
• Planning for Backups
• Executing Database Backups
• Restoring Database Backups
• Performing Transaction Log Backups
• Using Advanced Backup Techniques
• Monitoring
• Using SAP DB Control Center
• Monitoring SAP ASE

Environnement

VM Linux

Mot-clés

SAP SYBASE ASE DBA