Recordings
HANA Administration_11th July 2024
In session 1, we have covered the basics of Linux commands, HANA architecture, SystemDB and TenantDB, SQL ports in HANA, and the HANA stop and start process. This session will provide a solid foundation for understanding the fundamentals of HANA and its operating system, as well as essential commands and processes for managing the HANA database. By the end of this session, participants will have a clear understanding of how to navigate the HANA environment, execute commands, and ensure the proper functioning of their HANA system. This knowledge will be crucial for anyone working with HANA databases and will pave the way for further advanced learning in subsequent sessions.
In session 2, We have covered Details of services in HANA Database, License Administration and Applying license in HANA Database through HANA Studio, HANA Cockpit and Using HANA interactive terminal. In the final part of the session we have deep-dived into GAL and it's calculation in scaleup and scale-out scenario.
In session 3, We have covered Details HANA Memory Management, HANA File System Layout and details of HANA Data volume and HANA Log volume. We have also discussed Save point , Persistence in depth. Live demonstration included in this session.
In session 4, We highlighted on HANA Parameter change using Python program, HANA Interactive terminal and HANA Cockpit. Also we have discussed on HANA Security administration such as User Administration, Role assignment, Privilege assignment using HANA Cockpit, HANA Studio.
In session 5, We highlighted on HANA System USER administration, Importance of SYSTEM USER, Reset of SYSTEM User in SYSTEMDB and Tenant DB.
In session 6, We highlighted on HANA SIZING ,HANA Data size calculation, Log volume size calculation, Installation directory size, OS Parameter settings and Network parameter settings for HANA Installation.
In session 7, We highlighted on HANA Database installation media download, Platform for HANA Installation, HANA Database Installation, Post Installation Tasks and HANA Revision Upgrade.
In session 8, We highlighted on HANA cockpit installation media download, Deployment of scenarios for HANA cockpit, Resource Registration.
In session 9, We highlighted on HANA Backup strategy, Using backup cycle, Types of backup in HANA, Understanding backup process and backup sequence for recovery
In session 10, We highlighted on Triggering backup using HANA Studio, HANA Cockpit, HDBSQL. We also focused on HANA snapshot and taking internal database snapshot. later part we discussed on multiple tools such as hdbbackupcheck, hdbbackupdiag and hdbrecovercheck
In session 11, We highlighted on HANA Recovery using HANA cockpit, HANA Studio, HDBSQL and recoverSys.py. We also discussed different aspect of Point in time recovery and also discussed on recreating backup catalog
In session 12, We Discussed HANA system replication prerequisites, Replication mode, operation mode. Setting up multitier replication and steps. Also had a demonstration on feasibility of replication considering operation modes.
In session 13, We Discussed HANA Multi Tier system replication, significance of operation mode and replication mode. We have setup HANA Replication between two sites with sync and log replay. At the end we also discussed on how to change operation mode and replication mode
In session 14, We Discussed HANA Multi Tier system replication, Failover, Takeover, Failback. We have discussed how failover works in case of Multi Target replication. Also discussed detailed command for multi target replication
In session 15, We Discussed Automatic registration of secondary sites in Multi target replication, also we have discussed how to setup alternative secondary sites. Later part we have discussed Hana upgrade using Near zero downtime.
In session 16, we discussed on delta merge concept, Merge Motivation, Merge dog process, Merge Token, Delta merge history check, cost functions and Memory requirement for delta merge
In session 17, we have demonstrated the Delta Merge operation using HANA Studio, HANA Cockpit. We have understood the necessary cost function required for certain merge motivations.
In session 18, we discussed on table partitioning concept, Need of table partitioning, Types of table partitioning such as single level , multi level. Later part we had hands-on session on table partitioning using HASH, Range, and multiple such as HASH/Range. Also we have discussed necessary preparations required for production table partitioning
In session 19, we have discussed Admission control and HANA Client. Special emphasis give to hdbuserstore and Hana cleaner setup. Later part we have discussed on HANA Troubleshooting
In session 20, we discussed data reclaim, log reclaim, important issues in HANA and troubleshooting
Access SAP HANA Documents
We offer a comprehensive platform to download SAP HANA documents organized by topics, ensuring you find the resources you need efficiently and effectively.
150+
15
Trusted By Experts
Quality Assured