LIST OF HANA ACTIVITIES

Installation:

1. Navigation for SAP HANA software and Support Packages and Patches for SAP HANA in market place

2.Software Authenticity Verification

3.Conversion of HANA DB from single container to combination of system DB and tenant DB.

4.2235581 - SAP HANA: Supported Operating Systems

5.Supporting Operating system for HANA

6.*SUSE Linux Enterprise Server(SLES)

   1944799 - SAP HANA Guidelines for SLES Operating System Installation

   2205917 - SAP HANA DB: Recommended OS settings for SLES 12 / SLES for SAP Applications 12

   1984787 - SUSE LINUX Enterprise Server 12: Installation notes

7.* Suport Hardware platforms

     sap note: 2493172

8.* 1900823 - SAP HANA Storage --> Attachments -->storagewhitepaper

9.SUSE Linux Enterprise Server 15.x for SAP HANA

10.Concept of swap-in and swap-out --> My reference Snote.

11.How To Create a Linux Swap File

12.SAP HANA Hardware and Cloud Measurement Tools for scale out systems💢maintenance activity

13.Measure System & Performance - Scale-up Systems 💢maintenance activity

• SAP HANA installation preparation
  
• SAP HANA database sizing with quick sizer
  
• HDB update check list
• HANA DB backup using HANA studio
  
• Unenforced and enforced license key in SAP HANA
  
• Determine Ports for SAP HANA Cockpit and Cockpit Manager
  
• What is the major difference between single-container mode and multi-container mode?
  
• Install a Multiple-Host SAP HANA System Using the Command-Line Interface
  

ACC:

• SQL Ports for HANA 2.0 to connect system database and tenant database
• Different kinds of HA DR replication modes and operation modes
  
• 
  

COCKPIT 

1.  overview & list of activities can do in HANA cockpit.

2.   Default user id created during HANA cockpit installation process.

3. HANA cockpit installation.

4.Set up SAP HANA Cockpit for the First Time.

5.HOW to find SAP HANA COCKPIT AND COCKPIT MANAGER ports.

6.Specifying the port for SAP HANA Cockpit before installation.

7.Credentials required for HANA resources Access.

8.Authorizations Needed for Monitoring and Administration.

9.Setup and Administration with the Cockpit Manager.

10.How to manage database users credentials in HANA cockpit.

11.creating cockpit user.

12.Grant a cockpit user access to specific groups.

13.Edit Settings for a Cockpit User.

14.Delete a Cockpit User or Revoke Cockpit Access.

15.configuring cockpit settings,Setting Connection Timeout.

16.Working with resource and Resource groups.

17.HOW to check multi-tenant databases list in HANA studio(HDBSQL console).

18.Export Resources in cokcpit.

19.Importing resources in hana cockpit.

20.Managing resource groups.

21.Add or Remove Resources in Resource Groups

22.Delete a Resource Group

23.Add or Remove Users in Resource Groups

24.Managing Resources, Users, and Groups with the Cockpit APIs

25.Send a Notification to Logged-In Users in HANA cockpit

26.View Logs to Troubleshoot the Cockpit.

27.How to trouble shoot hana cockpit issues

28.Configure SSO Access to a Resource

29.creating NEW tenant Database in HANA

30.How to reset system user password in SAP HANA environment

31.Deleting or dropping tenant database

32.how to start and stop tenant DB

33.Assign the OS User and Group for High Isolation

34.brief note on HANA studio.

35.How to create new package in HANA studio

36.How to stop & drop tenant Database in HANA database

37. where exactly to check for HANA issue

38. HANA cretification notes series - introduction

39. Pre-requsites for HANA DB installation


40.HADR

      How to check HA replication info
41.HANA DB Refresh
     user password reset for user re-use in hdbuserstore list

42. HANA Administration with python scripts

• brief intro and fullSystemInfoDump.py script
• HanaHwCheck.py
  

• If any of the python wrappers(LandscapeTest.py/FilesystemTest.py/NetworkTest.py) in HWCCT 1.0 (<220) are not working/giving errors, please check HWCCT patch note at http://service.sap.com/sap/support/notes/2161344

  
  

Backup and recovery:

1.  Backup and recovery introduction



HANA Concepts:

Delta merge in SAP HANA

OOM

SQL command for CPU utilization in HANA DB

All about HDBUSERSTORE LIST




Dynamic Typing:

• Complete course of HANA Dynamic tyring
  
  
  

TABLE ADMINISTRATION:

1. Create ROW TABLE:
   
2. Syntax for creating new column store table
   
3. TRUNCATE TABLE A;
   
4. Exporting and importing table data and definations
5. Monitoring memory Usage of table
   
6. Managing Large tables with partitioning
   
7. 
   

Slow system -wide performance:

1.run time dump file creation in SAP HANA
2. Kernel profile in SAP HANA
3. Snote - 2600030 - parameter recmommandations in SAP HANA environments.
                                  Scripts to be executed in SYSTEM DB and Tenant database level.

4. Snote - 2114710 - FAQ - SAP HANA Threads and Thread samples on how to identity and solve problems with running and blocked threads.

5. HANA_Global_TimeFrameReport_2.00.043+.txt and load history 
6.HANA_LoadHistory_services_2.00.030+.txt to do following

Evaluate CPU/Memeory/Disk
Check running vs waiting Threads
check on MVCC versions
Check Blocked Transactions /locking issues

2222217 - How-To: Troubleshooting SAP HANA Startup Times