Skip to Content

HANA DB Parameter changes

How we can change parameters in secondary node without moving the DB. I have tried with DEFAULT, SYSTEM, HOST layers for that in ALTER SYSTEM ALTER CONFIGURATION at HDBSQL however , they only work on filesystem level?

As of now once we move the DB to secondary node the parameters changes being made at primary site gets lost.

Regards,

Dharm

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Nov 27, 2015 at 11:06 AM

    Hello Dharm,

    may I draw you attention to the following note:

    2186744 - FAQ: SAP HANA Parameters

    pt. 17

    BR, Bojan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Bojan,

      Thanks. I have already gone through 1999880 note. The script tells you the difference among sites parameters changes.However , I am looking for a solution where i can apply the changes in parameter file for both sites without switching over the DB.

      Regards,

      Dharm