HANA Database Parameters before and after SPS/Revision Upgrade

[Mithran]

Dear Guru's,

We are planning to upgrade HANA 2.0 SPS from version 4 to 5 version latest patch 59 revision. How to cross check or get a list of parameters that are changed after upgrade.

How to take a list of existing parameters from HANA before upgrade as well how to check list of parameters changed after an upgrade.

Kindly check and do the needful

Thanks & Regards,

Mithran

[simon25 · Accepted solution]

Hi Mithran ,

You could use this script from before and after the upgrade to compare : 'HANA_Configuration_Parameters_Values_2.00.040+.txt'

'HANA_Configuration_Parameters_2.00.040+.txt' will highlight any parameters which may be misconfigured according to the current revision of HANA. "check why set" messages may appear where the parameter was already set to the new, default value provided with the latest revision, or , if the parameter is not expected to be set to a custom value. This doesn't always mean it is erroneous though.

This script collects changes made manually by users to the inifiles :

HANA_Configuration_Parameters_Changes_2.00.030+.txt

See KBA 2903141 - Best practice configuration checks for SAP HANA

(To access these scripts, please navigate to the SQLstatements.zip folder at the bottom of Note 1969700)

Kind Regards

Simon

[Mithran · Accepted solution]

Hi simon25,

In case if I forget to run the SQL statement before upgrade and Is it possible to check after HANA DB Upgrade like history of HANA parameters that got changed after upgrade.

Thanks & Regards,

Mithran

[simon25]

Hi Mithran,

The Inifile change history is recorded in the M_INIFILE_CONTENT_HISTORY System View

This script from Note 1969700 also serves the same purpose: 'HANA_Configuration_Parameters_Changes_*'

[INVOLVED TABLES]

- M_INIFILE_CONTENT_HISTORY

Check the sections '[OUTPUT PARAMETERS]' & '[EXAMPLE OUTPUT]' for a sample result.

Kind Regards

Simon