HANA parameter change history

How to check HANA parameter change history ?
 
Requirement : You want to check HANA parameter history and want to know who changed the parameter and when a HANA parameter was changed. 

Solution : In order to check HANA parameters history changes , you can use system view M_INIFILE_CONTENT_HISTORY. 

example - Following query will return HANA parameter change history sorted with time. 
 SELECT * FROM M_INIFILE_CONTENT_HISTORY ORDER BY TIME DESC.   



Here you can see who(Application User) changed the parameter and what was the HANA parameter previous and new value after change. 

Please note : Above SQL command will only show the parameters changes from HANA application layer for example changes made with issuing ALTER SQL , or from HANA Studio or cockpit will be captured in the history table. 

Changes made from OS level by modifying the INI files will not be reflected. 
Changes made with hdbnsuti will also not be captured in this system view. 

 How to reset  M_INIFILE_CONTENT_HISTORY  historical view data: 
ALTER SYSTEM CLEAR INIFILE CONTENT HISTORY [UNTIL ‘timestamp] 

example:  ALTER SYSTEM CLEAR INIFILE CONTENT HISTORY UNTIL '2021-12-31 23:59:59';


Tags : Tracking HANA parameter change. Paramter Change logs, Which user changed HANA parameters.