How to check HDB Shutdown and Startup History in SAP HANA

[former_member386395]

I want to know which system table stores the history records about the HDB Shutdown and Startup in HANA SQL.

Or is there any other convenient way to find these history records without browsing lots of trace logfiles？

[Cocquerel · Accepted solution]

you can get the information with the following SQL:

SELECT * FROM "SYS"."M_SYSTEM_AVAILABILITY"

[former_member386395 · Accepted solution]

OK！ But it seems that the M_SYSTEM_AVAILABILITY can only store the older history records for 4 months ？

> > select count(*) from SYS.M_SYSTEM_AVAILABILITY where EVENT_TIME > '2021-02-01 00:00:00';

| COUNT(*) |

| -------------------- |

| 12075 |

1 row selected (overall time 4551.425 msec; server time 556.992 msec)

hdbsql SYSTEMDB=>

>

>

> select count(*) from SYS.M_SYSTEM_AVAILABILITY where EVENT_TIME < '2021-02-01 00:00:00';

| COUNT(*) |

| -------------------- |

| 0 |

1 row selected (overall time 2210.432 msec; server time 552.665 msec)

hdbsql SYSTEMDB=>

[Cocquerel · Accepted solution]

the view SYS.M_SYSTEM_AVAILABILITY is reading data from 2 files: system_availability_<host>.trc and system_availability_<host>_old.trc that maximum size is 1MB

From note 2119087, "file size and number of files are hardcoded and can't be influenced."

But, what you could do is to persist from time to time, the data of SYS.M_SYSTEM_AVAILABILITY in a custom table.

[sapfun08]

Hello,

You can get useful information about the startup timestamps of the different hosts with the help of statement "HANA_Startup_StartupTimes". The statement can be found in the attachments of SAP Note 1969700 - SQL Statement Collection for SAP HANA (SQLStatements.zip)

Best Regards,
Anna