How to get hostname in SAP HANA

[Former Member]

Hi,

I want to get the hostname of current SAP HANA via SQL statement, just like

     SELECT host_name()

in SQL server. I try this in SAP Hana, but it doesn't work. So is there any way to get hostname, instance number

of an SAP HANA using SQL statement? thanks

[former_member781059]

Ah, finally got it. No spaces between the "=" sign

[former_member781059]

Hi,

I have the same issue where XSA Migration Assistant tells me

"Error: HANA_HOST not set in environment"

I have gotten the parameters as such from HANA queries:

Set HANA_HOST = <SELECT CLIENT_HOST FROM M_CONNECTIONS WHERE CONNECTION_ID = CURRENT_CONNECTION;>

Set HANA_SQL_PORT = <SELECT DISTINCT sql_port FROM SYS.M_SERVICES WHERE SQL_PORT > 0;>

Set HANA_USER = my User

Set HANA_PASSWD = my pwd

Please help me understand why it does not recognize when I provide the HANA Host Parameter

Thanks

[former_member620557]

Hi,

Please try below SQL.

SELECT SYSTEM_ID, DATABASE_NAME, HOST, USAGE FROM "SYS"."M_DATABASE";

Regards

Shash

[JoergAldinger]

Hello Zhongcun,

Not sure if you still need this, but here is the solution:

SELECT CLIENT_HOST FROM M_CONNECTIONS WHERE CONNECTION_ID = CURRENT_CONNECTION;

Hope that helps,

Joerg.

[Ravi_Channe]

Hi,

Please check the view M_HOST_INFORMATION for the details you require.

Regards,

Ravi