Convert Standby Node to Worker node : SAP HANA

[Former Member]

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

[Former Member · Accepted solution]

Hi All,

I have performed this task recently and below is the high level plan.

• Identity the column store tables which are not allocated to any specific Table group.
• Allocate table group to all the column store tables.
• Take a backup of the existing table distribution plan.
• Identify wrong table placements in the new distribution plan and correct them.
• Add a new node as slave node to the HANA appliance / convert the standby node to slave node.
• Run the Table redistribution from SAP HANA studio.

You can access the detailed instructions from the below URL.

SAPFreelancing :: Blogs :: Blog Detail