Skip to Content
avatar image
Former Member

How to check if HANA is running properly?

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,

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Nov 06, 2012 at 07:46 PM


    Hi Sejin,

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

    Regards,

    Swapan

    Add comment
    10|10000 characters needed characters exceeded

    • 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 SAP HANA One Platform Quick Start Guide. 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

  • avatar image
    Former Member
    Nov 06, 2012 at 08:40 PM

    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,


    Add comment
    10|10000 characters needed characters exceeded

    • 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