How to find SAP HANA System Start | Stop | Restart Information With A Special File

How to find SAP HANA System Start | Stop | Restart Information With A Special File

In this post we are going to discuss on a special file from which You can easily find when the Hana system was stopped /started /Restarted.  Most of the times available.log in Hana doesn’t give clear picture on when the services /system was down .In this post we are going to discuss on a special file called history.glf .

History.glf  in sap hana Records the Execution of the below commands .It is present by default in the following location – usr/sap/SID/hdb00/hostname/trace.From You can easily find when the Hana system was stopped /started /Restarted
Start
Stop
RestartInstance
RestartService
StopService
StartSystem
StopSystem
RestartSystem
UpdateSystem
UpdateSCSInstance

Example –

Info 2016 09 06 16:25:56 SAP-StartService started
Info 2016 09 06 16:25:59 Start instance by user “trusted unix domain socket user” from “localhost”
Info 2016 09 12 05:43:15 Stop instance by user “trusted unix domain socket user” from “localhost”
Info 2016 09 12 05:51:59 Start instance by user “trusted unix domain socket user” from “localhost”
Info 2016 09 12 05:53:15 Stop instance by user “trusted unix domain socket user” from “localhost”
Info 2016 09 12 06:03:39 Start instance by user “trusted unix domain socket user” from “localhost”
Info 2016 09 12 06:09:33 Stop system by user “trusted system user” from “XXXXXXXXXXXXXX / XXXXXXXXXXXXXXXXXX”

  • From 7th line the above output you can easily say that Hana was stopped at 2016 09 12 06:03:39 using HDB stop .
  • 8th line Stop system by user “trusted system user” from “XXXXXXXXXXXXXX / XXXXXXXXXXXXXXXXXX” – Which means Stop was triggered using sapcontrol commands to stop all the nodes .
  • Started by user – represents who stopped the system .localhost – represents local user . As of now Localhost or other node ip adress will be maintained in this file.

 

Leave a Reply