How to check if HANA is running properly?

[Former Member]

I ran follow commands in hdbadm user. now, how does "HDB info" looks like when it's running correctly?

here is how mine looks like:

imdbhdb:/usr/sap/HDB/HDB00> HDB info; netstat -nat

USER       PID  PPID %CPU    VSZ   RSS COMMAND

hdbadm    4402  4401  0.0  13728  2720 -sh

hdbadm    4658  4402  0.0  12744  1672  \_ /bin/sh /usr/sap/HDB/HDB00/HDB info

hdbadm    4684  4658  0.0   4788   848      \_ ps fx -U hdbadm -o user,pid,ppid,pcpu,vsz,rss,args

hdbadm    4290     1  0.0  42628  1824 sapstart pf=/usr/sap/HDB/SYS/profile/HDB_HDB00_imdbhdb

hdbadm    4306  4290  0.1 504952 158408  \_ /usr/sap/HDB/HDB00/imdbhdb/trace/hdb.sapHDB_HDB00 -d -nw -f /usr/sap/HDB/HDB00/imdbhdb/daemon.ini pf=/usr/sap/HDB/SYS/profile/HDB_HDB00_imdbhd

hdbadm    4150     1  0.0 285868 107284 /usr/sap/HDB/HDB00/exe/sapstartsrv pf=/usr/sap/HDB/SYS/profile/HDB_HDB00_imdbhdb -D -u hdbadm

and I don't see port 30015 listening when I run netstat -nat.

Any help is appreciated.

Thanks,

[Former Member]

Well, It's working now.

I've been starting/stoping aws instance from AWS console but I think maybe it's not good practice to do stop instance from aws console every end-of-day.

I restarted hanadb instance from root user (# shutdown -r now) and it's working fine now.

Here is screenshot of HDB info and tcp ports when running correctly.

Thanks,

[swapan_saha]

Hi Sejin,

Based on your above screenshot, it does not appear to be HANA One instance. If you use HANA One, you only need to SSH once to the instance to set hdmadm (OS) password, start HANA, reset system (DB) password and open recommended ports (30015, 50013-50014). Subsequently, you do not need to do anything to start or stop HANA at AWS. They will come up or go down once you stop EC2 instance from EC2 console. If you use HANA One and want to keep running HANA, you do not need to stop or start EC2 instance but it will incur costs.

Regards,

Swapan

[swapan_saha]

Hi Sejin,

Could you please let us know which step(s) you followed in the Quick Start Guide?

Regards,

Swapan

[Former Member]

I am sorry I don't think I followed Quick Start Quide.

I have followed from http://scn.sap.com/docs/DOC-28294  .

I was able to install and setup and connect from my studio and created new user and created databases etc

also, I was able to connect from my application no problem.

I was also stopping aws hanadb instance everyday at end-of-day and start back on next morning for about a week without any problem; until over this weekend.

also, I tried to run startsap or stopsap didn't work either. I get this when I run stopsap in the command line.

imdbhdb:/usr/sap/HDB/HDB00> stopsap

  End program!

  Starting with NGAP 2.0 the startsap/stopsap scripts will be removed

  and is no more available.

  For detailed information see Incompatible Change:

    https://wiki.wdf.sap.corp/wiki/display/LeanByD/IC_0152

Thanks,

[swapan_saha]

Hi Sejin,

SAP HANA One is for productive use cases and different from the link you sent. If you are looking for a productive grade HANA on public cloud with having performance, scalability, security considered, you can use SAP HANA One.

Before you start using, we request you to read . if you have any questions from SAP HANA One, please feel free to post questions here. Please monitor your instance from AWS EC2 console. If you do not need to keep running, please make sure you shut down and restart when you need to control the cost.

Regards,

Swapan