Virtual DB hostname not displayed in DBACOCKPIT

[Farid]

Hello,

We have installed several HANA Databases (SPS12.0 and SPS11.2) and different SAP systèmes have been connected : S/4 HANA , SAP ECC EhP8.

The HANA Database is always running on its own server, and the SAP system running on its distinct server.

The SAP system has been connected to HANA through its Virtual IP adress.

For example we just installed a HANA Database on its physical IP adress sapt01hana1

The Virtual IP adress of the HANA server is hanatest

The SAP Netweaver system has been installed and conencted to HANA through its virtual IP adress : hanatest

In hdbusersore there is no mention whatsoever of the physical hostname ,only the virtual hostname

sapt01d01:t01adm 59> hdbuserstore LIST

DATA FILE       : /home/t01adm/.hdb/sapt01d01/SSFS_HDB.DAT

KEY FILE        : /home/t01adm/.hdb/sapt01d01/SSFS_HDB.KEY

KEY DEFAULT

  ENV : hanatest:30015

  USER: SAPECC

In the DEFAULT profile, the virtual hostname of the DB has been configured during the installation :

SAPDBHOST = hanatest

Connection from SAP system to virtual hostname of the DB works fine

hdbsql=> \c -n hanatest -i 00 -u SAPECC -p Mypassword

Connected to QHA@sapt01hana1.****.com:30015

I checked with netstat and SAP system is communicating with its DB through the virtual IP adress only

But in SAP screens, only the physical hostname of the DB is displayed, not the virtual hostname :

Here a screenshot of DBACOCKPIT, or System---|Statut.

I do not understand why the virtual hostname is not being picked up

I checked DBCO entries : there was no DEFAULT entry, so I created one pointing to the virtual hostname it did not change anything

Thank you for your attention

[former_member182967 · Accepted solution]

Hi Raoul,

This situation is normal. In my case, one application connects to HANA virtual hostname, where HANA is configured in system replication mode. After performing take over, the hostname shows the physical hostname of new primary. 

I just guess the hostname in DBACOCKPIT is get from hostname command in OS.

Regards,

Ning

[lucas_oliveira · Accepted solution]

Hi,

In addition to what Ning described, the DEFAULT entry is the actual DEFAULT key from your hdbuserstore.

So the connection is probably resolving the virtual name to the actual name (maybe an nslookup would show that)  and the value is kept within abap kernel modules in global variables.

Regards,

Lucas de Oliveira

[uta_hedemann]

We have used the virtual hostname in the SAP APPL hdbuserstore KEY DEFAULT, but DBACOCKPIT/DB02 showed physical hostname of primary when HANA lived on primary site. No possibility to adjust in DBAOCKPIT as raoul.shiro already wrote.

After takeover to secondary site, dbacockpit shows the physical hostname of the secondary site, without manual intervention 🙂

[Farid]

Thank you Ning and Lucas !