Skip to Content
0
Former Member
Sep 26, 2014 at 07:16 PM

Convert Standby Node to Worker node : SAP HANA

736 Views

Hi All,

We have an appliance BW on HANA. BW is on SAP NW 7.31 and HANA is on SPS7 Rev73.

HANA Database is distributed with 3+1 (3 worker nodes and 1 standby node). Due to increase in memory utilization, we have decided to convert the standby node to a worker node which is a temporary work around.

Question : Can I change the configuration file to change the node from standby to worker and redistribute the tables across all the slave nodes from HANA Studio. Will this suffice my need?

or

Do I need to delete the standby host from SAP HANA Lifecycle manager(HLM) and then add the same host as a worker node from HLM?

Present configuration of Standby node

=====================================

Name server configured role : Slave

Name server actual role : Slave

Index server configured role: Standby

Index server actual role : Standby

New configuration of Standby node to change the role to worker

==============================================================

Name server configured role : Slave

Name server actual role : Slave

Index server configured role: Worker

Index server actual role : Slave

Please let me know all possible options, best practices to implement this.

Thanks,

Sampath