We often needs to change the parameters in Hana database. If we have Hana System Replication enabled it is always a question how to update the parameter in the secondary site. As SQL console is disable in secondary site. And only in read mode if active active replication is setup.
There are two ways to change the parameter in the secondary site of Hana Database
- Using hdbnsutil -reconfig
One simple way is just update the respective .ini file where your parameters are stored
ts1adm@hanahost:>>cdglo
ts1adm@hanahost:>>cd hdb/custom/config; pwd
ts1adm@hanahost:>>/usr/sap/TS1/SYS/global/hdb/custom/config
You can navigate to above directory which contains your custom parameters of Hana DB. For example I am editing a parameter in global.ini. Open global.ini in vi editor and add parameter and save it.
Once you have added the parameter in your secondary host execute the below command from <sid>adm user.
ts1adm@hanahost:>>:/usr/sap/TS1/SYS/global> hdbnsutil -reconfig
That’s it with this your parameter would be updated in the secondary site.
2. Update the parameter in secondary site automatically using replicate parameter
When we have Hana system replication enabled we can update the parameter in the secondary site automatically once it is updated in the primary site.
All we have to do is just add the below parameter in the primary site [inifile_checker]/enable = true once you have enabled the parameter in the primary site. It would look like below.
With this all the parameters updated in the primary site will be updated in the secondary site except the one which is mentioned in exclusion list.
References for the above details