Transforming Database Management with the new SAP HANA 2 feature, Active/Active read-enabled

Tech Ed Barcelona 2016 is happening now this week from Nov 8 – 10, and an exciting announcement was made for SAP HANA 2. With the launch of the next generation platform SAP HANA 2, SAP is looking further to bring greater stability and agility for customers looking to build a solid foundation for innovation and digitalization.

A key feature announced is Active/Active Read-Enabled. Along with enhanced data encryption, workload management and the SAP HANA Cockpit, these new features look to help further simplify and Free up IT efforts to allow them to focus on innovation.

Reset the SYSTEM User's Password in HANA DB

Overview
If the SYSTEM user's password is lost, you can reset it as the operating system administrator by starting the index server in emergency mode. If your HANA DB is Multitenant, this process will not work.  My HANA DB revision was 102.04

Prerequisites
You have the credentials of the operating system administrator (<sid>adm).

Procedure
Step 1: Log on to the server on which the master index server is running as the operating system user (that is, <sid>adm user).

Step 2: Open a command line interface.

Step 3: Shut down the instance by executing the following command:
/usr/sap/<SID>/HDB<instance>/exe/sapcontrol -nr <instance> -function StopSystem HDB

How to Guide for Tier Based HANA System-Replication

SAP HANA System Replication is used in most of the SAP HANA implmentation for HA or DR scnearios.

In this blog, is more for the technology consultants, a bit inclined to technical people.

I have installed three HANA instances with same SID and instance number. So won't be talking any thing on installing SAP HANA systems.