cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Hello Export, I would like to know how to check if HANA Fast Restart option is enabled in system?

Wajid
Explorer
0 Likes
510

Hello Expert, I want to know multiple way to check if HANA FRO is enabled on running database? Thanks 

SAP HANA Cloud, SAP HANA database  

Accepted Solutions (0)

Answers (1)

Answers (1)

HakanHaslaman
Product and Topic Expert
Product and Topic Expert
0 Likes

Please check:
https://me.sap.com/notes/3439821

>>><<<
There are at least 2 different ways to check if FRO is enabled or not.

  • Run the diagnostic script HANA_Configuration_Overview_2.00.040+ of the SQLCollection.zip of SAP Note 1969700 - SQL Statement Collection for SAP HANA 
    and check its result about "Fast restart option (FRO) configured" It will show either No or Yes
  • Another way to check if it is disabled or enabled is to run the SQL command select * from m_cs_tables
    It will either return TRUE or FALSE for the column PERSISTENT MEMORY

>>><<<