Skip to Content

Do HANA parameters are case sensitive

Dear Friends,


I have query related to HANA Log Mode parameter. To understand is this parameter is case sensitive ?

  1. 1. I have set Log Mode  parameter as OVERWRITE  , automatic log backup was enabled (Though this parameter show in disabled state after setting in Overwrite mode) and bounced HANA DB.

In this case, it generated the archive log files in /hana/log-backup/* , Means OVERWRITE parameter was not adapted.

  1. 2. I have disabled  automatic log backup, set log mode parameter as  OVERWRITE  and bounced HANA DB.

In this case,  it has generated log segment files in /hana/log/mnt*/* ,  means OVERWRITE parameter was not adapted.

When I set OVERWRITE mode in small letters “overwrite” then the overwrite mode was adapted by HANA.


Regards,

Sahil

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 01, 2015 at 01:39 PM

    In general upper and lower case shouldn't matter for parameters and values, see SAP Note 2186744 (12). I just tested and log_mode is an exception. I got the following error in the indexserver trace file:

    Unknown log mode OVERWRITE specified, value not changed

    I just discussed with SAP HANA development and they consider to change this unfortunate behavior in a future SAP HANA Revision.

    Add comment
    10|10000 characters needed characters exceeded