Hi Friend,
In this blog, we are going to see how to HANA database services status with the help of the command line.
Sometimes, we observed that we are unable to check the status of HDB services from the HANA studio. at that time we can log in to OS with the user SIDADM ( HANA DB host ).
1: Login on HANA database host with user <SID>ADM
2: We can check the same in two ways.
a: HDB info ( note HDB must in capital letters )
b: Sapcontrol -nr xx -function GetProcessList ( nr --> instance number/ -function --> function which like to user )
@AWS-D-HDB-TEST:/usr/sap/HXX/HDB00> sapcontrol -nr 00 -function GetProcessList
07.10.2020 02:39:16
GetProcessList
OK
name, description, dispstatus, textstatus, starttime, elapsedtime, pid
hdbdaemon, HDB Daemon, GREEN, Running, 2020 10 06 06:35:01, 20:04:15, 9172
hdbcompileserver, HDB Compileserver, GREEN, Running, 2020 10 06 06:36:05, 20:03:11, 9610
hdbdiserver, HDB Deployment Infrastructure Server, GREEN, Running, 2020 10 06 06:36:32, 20:02:44, 10629
hdbdiserver, HDB Deployment Infrastructure Server-COCKPITDB, GREEN, Running, 2020 10 06 06:36:32, 20:02:44, 10632
hdbdiserver, HDB Deployment Infrastructure Server-HDB, GREEN, Running, 2020 10 06 06:36:32, 20:02:44, 10635
hdbindexserver, HDB Indexserver-COCKPITDB, GREEN, Running, 2020 10 06 06:36:06, 20:03:10, 9662
hdbindexserver, HDB Indexserver-HDB, GREEN, Running, 2020 10 06 06:36:06, 20:03:10, 9665
hdbnameserver, HDB Nameserver, GREEN, Running, 2020 10 06 06:35:02, 20:04:14, 9199
hdbpreprocessor, HDB Preprocessor, GREEN, Running, 2020 10 06 06:36:05, 20:03:11, 9613
hdbwebdispatcher, HDB Web Dispatcher, GREEN, Running, 2020 10 06 06:36:32, 20:02:44, 10638