System and Database Administration: Adaptive Server Enterprise

5 days

During this course students will gain: Manage physical data placement and storage, Create, backup and restore databases, Create and manage multiple temporary databases and Create user accounts and manage permissions

This course is aimed at Database and System Administrators with an understanding of sap Sybase ASE & EDB116

Please find the course objectives below:

SAP Adaptive Server Enterprise 

  • Explaining SAP ASE 
  • Describing the Database Architecture 
  • Using Query Editors


  • 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 
  • Creating Databases 
  • Managing Databases 
  • Managing Disk Resources 
  • Managing Temporary Databases


  • Managing Roles 
  • Creating Logins 
  • Managing Logins 
  • Managing Database Users 
  • Managing Creation Permissions 
  • Managing Object Permissions 
  • Creating Groups 
  • Creating Roles


  • Using SAP ASE Extraction Utilities 
  • Using the Bulk Copy Utility 
  • Ensuring Database Consistency 


  • Planning for Backups 
  • Executing Database Backups 
  • Restoring Database Backups 
  • Performing Transaction Log Backups
For an onsite course please contact us