SAP ASE DBA Course - Join Now
SAP ASE DBA-Introduction to Adaptive Server Enterprise
- Introducing SAP ASE DBA
- Learn about Adaptive Server Enterprise 16.0 and Adaptive Server Databases.
- What are your responsibilities as System Administrator.
Installing Servers -
- Learn about downloading ASE Software.
- Installing Adaptive Server on Linux
- Take a look at ASE Directory Structure on a Linux.
- How to Start and Stop ASE Servers.
Establishing Connectivity -
- What are the interfaces file and what is windows sql.ini file.
- Maintaining the interfaces files on Linux and Windows Operating Systems.
- Introduction to LDAP directory services.
- Practicing Working with databases.
Configuring Server Behavior
- What are Configuration Values for ASE?
- Viewing and Modifying Configuration values
- Managing Multiple Configuration files
- Practicing Database configuration Parameters
Configuring Memory - Watch Video Recording of Lecture
- What are Components of Memory in ASE.
- Learn about Allocation of Memory in SAP ASE
- Major uses of Memory for an Adaptive Server.
- Estimating Initial Configuration Values
Initializing and Using Devices
- Creating and Dropping Devices for ASE
- What are Default Devices? How to Mirror Devices
Creating and Using Databases
- Sizing and Creating Databases
- Setting Ownership and options for a Database in an SAP
- Expanding Databases
- Lab: Create database, Drop database ,Start database and Stop database
Suggested Disk Resource Strategies
- Resource Allocation for System Databases and User Databases
- Monitoring Space Usage
- Practicing Adding and Modify Devices or data files in Databases
Auto Expansion - Watch Video Recording of Lecture
- Overview of Auto Database Expansion
- Installing Auto Expansion of Databases on Sybase ASE
- Managing Auto Expansion using sp_dbextend
- Review of System tempdb
- Installing multiple tempdbs
- Binding Database Objects to a tempdb in a Sybase ASE
- Managing tempdbs - Precedence
- Troubleshooting and Recommendations
Administering System Roles and Logins
- Overview of Access Concept.
- Define System Roles and Logins.
- What is Proxy Authorization
Managing Database Access and Users
- Database Owners and Users
- Object Creation Permissions
- Lab : Create user, Drop user and Manage user permissions
Implementing Object Permissions, Groups and Roles
- Object Permissions in SAP ASE
- Creating and Managing Groups in SAP ASE
- Overview of User-defined Roles
- Implementing User-defined Roles
Using Bulk Copy Utility on Sybase
- Copying Definitions
- Bulk Copy Overview and Syntax
Overview of Automatic Recovery - Watch Video Recording of Lecture
- Overview of Automatic Recovery
- Recording Modifications
- Recovering Modifications after a Shutdown
- What are Checkpoints?
- Manage Recovery Order while recovering a Database
Checking and Fixing Database Consistency
- Overview of dbcc Command
- Checking Page Linage and Page Allocation
- Setting up the dbccdb Database
- Using dbcc checkstorage
Planning for a Database Backup
- Backup Basics and Backup Server
- Truncating the Transaction Log
- Developing a Backup Plan
Performing a Backup of SAP ASE Database
- Making Backup Servers known to Adaptive Server
- Dumping and Loading Databases on SAP ASE 16.0
- Dumping and Loading Transaction Logs on Sybase ASE
- Practicing a Database Backup
Practicing Advanced Backup Techniques
- What are Thresholds?
- Working with Transaction Log Recovery and Database Recovery
- Rebuilding the master Database
- Practicing Restore backups into database
- Sybase Cockpit
- Install new ASE cockpit server
- ASE COCKPIT REPOSITORY
- Add an ASE instance to the ASE cockpit
- Know how to navigate through ASE cockpit
Monitoring the Sybase ASE Server
- Monitoring Errors, Processes, Licenses and System Performance
- Practicing Applying Patches, patch set and Database upgrade
Introduction to Sybase ASE Replication
- Why Replicate Data?
- What are the advantages of Data Replication for SAP ASE.
- Data Replication and Failover Methods
- What is an ID Server
- Understanding Replication System Domain and Server Threads.