This course covers in detail all key capabilities of SAP HANA database system administration. Through the lectures and exercises you will learn how to install, update and operate an SAP HANA 2.0 SPS06 database.
The course covers the most important database administration tasks of an SAP HANA system administrator. During the course, you will learn details about starting and stopping, changing the configuration parameters, monitoring the database, backup and recovery and troubleshoot of a multitenant SAP HANA 2.0 SPS06 database system.
This course is the best starting point to learn about SAP HANA installation, update, configuration and system administration.
Throughout the course, you will learn about the following SAP HANA tools for installation, update, configuration and system administration.
Introduction of SAP HANA
· What is SAP HANA
· What is In Memory Database
· SAP HANA Database Architecture
· SAP HANA Persistence Layer
Preparing Installation
· Sizing of SAP HANA
· T-Shirt Size
· Main Memory Sizing
· SAP HANA sizing using the QuickSizer tool
· Conclusion
SAP HANA Technical Deployment Options
· Single Component on One System (SCOS)
· Multiple Components on one System (MCOS)
· Multiple Components on one Database (MCOD)
Installation
· Introduction SAP HANA Lifecycle Management Tools
· Platform lifecycle Management
· Application lifecycle Management
· SAP HANA Database Installation
· SAP HANA Studio installation
Post Installation
· Post Installation Steps
· SAP HANA license management
· SAP HANA Support Package strategy
· Updating SAP HANA
· SAP HANA Support Package (Revision) upgrade
Admin tools for SAP HANA
· Introduction to SAP HANA Studio
· Introduction to SAP HANA Cockpit
· Introduction to SAP DBA Cockpit
· Monitoring with SAP HANA Studio
SAP HANA Multitenant Database Containers (MDC)
· What is Multitenant Database Containers
· Administration of Multitenant Database Containers
· Starting / Stopping tenant database
· Creating tenant database
· Dropping Tenant database
SAP HANA Configuration & Operation
· Starting and Stopping SAP HANA
· Tools for Starting and Stopping the SAP HANA Database
· Stopping & Starting HANA DB with SAP HANA Studio
· SAP HANA Database stop options
· Starting and Stopping the SAP HANA Database Using OS Commands
· Stopping and Starting Individual Database Services
· Restarting SAP HANA Database
· Configuring SAP HANA Database
· SAP HANA Database *.ini files
SAP HANA Memory Management and Data Persistence
· SAP HANA Core Processes
· SAP HANA Database Startup Sequence
· SAP HANA Database Server Process Port list
· Start of SAP HANA Database – Start – Up Process
· SAP HANA Memory Usages
Backup and Recovery
· Why Backup
· Memory --> Disk--> Backup
· Options for backups
· Overviews of Configuration options
· Log Mode (Overwrite and Normal mode)
· Log Backup Parameters
· Backup Catalog
· SAP HANA Database Backup using HANA Studio
· SAP HANA Database Recovery
· Recovery types
· Recovery Steps
· Recovery Phases
· SAP HANA Database Recovery using HANA Studio
Maintaining Users and Authorizations
· User Management
· Types of Privileges
· Standard Roles
· Administrative Tasks
· Managing Password Policy
SAP HANA Cockpit 2.0
· Understand the SAP HANA cockpit 2.0 architecture
· Configure SAP HANA cockpit 2.0
· Adding Remote HANA database to SAP HANA Cockpit
· Creating resource group and user in SAP HANA Cockpit
Join our public courses in our Netherlands facilities. Private class trainings will be organized at the location of your preference, according to your schedule.