System and Database Administration: SAP Sybase Adaptive Server Enterprise 16 (ASE3)

This course focuses on administering SAP Adaptive Server Enterprise, basic monitoring and performance tuning, and on efficient use of system resources (memory, disks, CPU) to build a secure, easy-to-manage database system.

You will install ASE and practice tasks hands-on, including backups, resource tuning and lock management. The course also covers system and user-defined roles to help you run and secure real-world ASE deployments.

Location, current course term

Contact us

Custom Customized Training (date, location, content, duration)

The course:

Hide detail
  • SAP Adaptive Server Enterprise (ASE)
    1. Explaining SAP ASE
    2. Describing the Database Architecture
    3. Using Query Editors
  • Installation
    1. Installing Servers
    2. Identifying Installation Parameters
    3. Starting and Stopping SAP ASE
    4. Connecting Clients to the Server
  • Database Server Configuration
    1. Explaining the Server Configuration File
    2. Modifying the Server Configuration File
    3. Explaining Memory Mechanisms
    4. Configuring Memory
    5. Configuring the Size of Caches
  • Space Management
    1. Creating Devices
    2. Managing Devices
    3. Mirroring Devices
    4. Creating Databases
    5. Managing Databases
    6. Managing Disk Resources
    7. Managing Temporary Databases
  • Security
    1. Managing Roles
    2. Creating Logins
    3. Managing Logins
    4. Managing Database Users
    5. Managing Creation Permissions
    6. Managing Object Permissions
    7. Creating Groups
    8. Creating Roles
  • Maintenance
    1. Using SAP ASE Extraction Utilities
    2. Using the Bulk Copy Utility
    3. Explaining Automatic Recovery
    4. Ensuring Database Consistency
    5. Setting Up the High Speed Consistency Checker
  • Backup
    1. Planning for Backups
    2. Executing Database Backups
    3. Restoring Database Backups
    4. Performing Transaction Log Backups
    5. Using Advanced Backup Techniques
  • Monitoring
    1. Using SAP DB Cockpit
    2. Monitoring SAP ASE
Assumed knowledge:
Completion of the Fast Track to Adaptive Server Enterprise course or equivalent experience; basic ASE knowledge recommended.
Schedule:
5 days (9:00 AM - 5:00 PM )
Education Partner:
MIBCON DIMA s.r.o.
Language: