Hana db filesystem directory structure and process command line

[#1]

Hi experts,

Could someone provide please actual directory structure of Hana db filesystem?

Generally speaking, I need to model some Hana db(of 1.0, 1.5 versions) entities. Among them:

• Schemas

• Data files

• Log files

• Important configuration files

• Database parameters(guess found in config files and command line)

• Database version

The question is where i can find such information having access to filesystem?

One another question is how common Hana db commandline looks like?

Does it have one process or several?

It would be perfect if someone give some ps -aef command result grepped with relevant Hana Db processes

Thanks,

Eugene

Edited by: Eugene Kondrashev on Dec 28, 2011 12:51 PM

[Former Member]

Eugene - Below are the default directory structure per HANA Install guide:

Installation Path /usr/sap

Home directory /usr/sap/<SID>/home

Home of the login shell /bin/sh

Data volumes <inst_path>/<sid>/global/hdb/data

Log volumes <inst_path>/<sid>/global/hdb/log

Under the global directory you'll have the following sub-directories:

---global

--security

--sapcontrol

--hdb

-install

bin

| -hdbuninst

| -hdbaddhost

| -hdbrename

|--data

|--data_volume_0000...99999

|--log

|--hdb0001...99999

|--log_segment_000_00000000.dat

|--log_segment_000_00000000.dat

I hope the above information helps.

Regards,

Octavio

Edited by: Octavio Alvarez Jr on Dec 29, 2011 1:17 AM

[Former Member]

Thanks a lot Octavio!

But the question with command line is still relevant.

• What are the processes relevant to Hana Db?

• What is the signature of starting command?

• How can I identify running Hana Db instance on a host having shell access?

• Does Hana DB started with SAP start profile? If so, could someone point me to the example of such a profile?

Thanks,

Eugene

[lbreddemann]

> * What are the processes relevant to Hana Db?

This is still changing pretty much ...

Anyhow, just check the running services in HANA studio (landscape tab) and you have all the process at hand.

> * What is the signature of starting command?

What is that supposed to mean?

> * How can I identify running Hana Db instance on a host having shell access?

How about the HDB command?

SUSE Linux Enterprise Server 11 (x86_64)

/usr/sap/HAN/HDB00> HDB help
Usage: /usr/sap/HAN/HDB00/HDB { start|stop|reconf|restart|version|info|proc|admin|kill|kill-<sig>|term }
  kill or kill-9 should never be used in productive environment!

/usr/sap/HAN/HDB00> HDB info
USER       PID  PPID %CPU    VSZ   RSS COMMAND
hanadm   14682 14677  0.0  85580  2180 sshd: hanadm@pts/0
hanadm   14683 14682  3.3  16768  2980  \_ -bash
hanadm   14756 14683 18.1  13652  1680      \_ /bin/sh /usr/sap/HAN/HDB00/HDB info
hanadm   14782 14756  0.0   6620   892          \_ ps fx -U hanadm -o user,pid,ppid,pcpu,vsz,rss,args
hanadm   31638     1  0.0  42624  1820 sapstart pf=/usr/sap/HAN/SYS/profile/HAN_HDB00_vml3012
hanadm   31645 31638  0.0 528216 151400  \_ /usr/sap/HAN/HDB00/vml3012/trace/HDB.sapHAN_HDB00 -d -nw -f /usr/sap/HAN/HDB00/vml3012/daemon.ini pf=/usr/sap/HAN/SYS/profi
hanadm   31665 31645  0.5 5001972 1002844      \_ hdbnameserver
hanadm   31723 31645  0.0 4367024 244336      \_ hdbpreprocessor
hanadm   31744 31645  1.9 5664496 1779448      \_ hdbindexserver
hanadm   31752 31645  3.6 7197924 3359440      \_ hdbstatisticsserver
hanadm   31759 31645  0.6 5289164 1507684      \_ hdbxsengine
hanadm   32017 31645  0.0 429188 124344      \_ sapwebdisp_hdb pf=/usr/sap/HAN/HDB00/vml3012/wdisp/sapwebdisp.pfl -f /usr/sap/HAN/HDB00/vml3012/trace/dev_webdisp
hanadm   31527     1  0.0 292676 110380 /usr/sap/HAN/HDB00/exe/sapstartsrv pf=/usr/sap/HAN/SYS/profile/HAN_HDB00_vml3012 -D

> * Does Hana DB started with SAP start profile? If so, could someone point me to the example of such a profile?

?? seriously... take a guess

regards,

Lars

[Former Member]

This is still changing pretty much ...

Could you please give some more info? Is it changing on per version basis, or what do you mean?

Anyhow, just check the running services in HANA studio (landscape tab) and you have all the process at hand.

As I said, I have only shell access, so no gui or similar apps applicable, only console commands.

But now i see that i can grep ps -aef with <SAPSID>_HDB<Instance_No>_<host_name> pattern matching sapstart pf=/usr/sap/HAN/SYS/profile/HAN_HDB00_vml3012

That is what i mean saying about signature:

sapstart pf=<Path_to_Profile>

So, is it correct that every sapstart pf=<SAPSID>_HDB<Instance_No>_<host_name> process means Hana Db instance running? Meaning one-to-one relation?

?? seriously... take a guess 

Ok, I just needed command signatures in that profile, I don't think it would raise any security issues or something..

A few additional questions:

• where can i find hana db version information? Some config file or command?

• How can I retrieve list of schemas of current Hana db instance?

As for last question I guess it should be some sql query. But I have no clue what client to use( /usr/sap/hbdclient ?) and what exact sql.

Thanks a lot for your help!

Eugene

[Former Member]

Hi Lars,

Thank you for provided inputs, when we run df -k  how does the output of file system look like...

I have prepared based on istguide but just wanted to cross check since i am pretty confused few areas...

Thanks,

rahul