Category: Hana Administration

[Guide] Most frequently Used Commands For SAP HANA Administrators

To Check Timezone ============================ select * from m_host_information where key=’timezone_name’ CHECKING FULL DB BACKUP ============================== SELECT ENTRY_TYPE_NAME,STATE_NAME,SYS_END_TIME,SYS_START_TIME from “SYS”.”M_BACKUP_CATALOG” where ENTRY_TYPE_NAME=’complete data backup’ and STATE_NAME=’successful’ order by ‘SYS_END_TIME’ desc …