sapdbctrl using wrong user

[former_member597277]

Hello,

I have a problem with the sapdbctrl part of saphostagent (721 PL40). Every minute saphostexec forks a new process which polls the HANA database with DB user X:

/usr/sap/hostctrl/exe/sapdbctrl status <DBSID> -P -f cimobject -T 1 -t HDB -H <DBhost> -u X -p - -i HDB02

This is obvious also from dev_sapdbctrl :

[PID 109466] SQL STMT: CONNECT to database <DBSID>@<DBhost> with user X

I have changed the user to Y according to OSS note 2023587 but the sapdbctrl still uses the user X even after deleting all entries in the hdbuserstore and creating the entries manually as per note 1625203. Reinstalling the saphostagent results in the same issue. Currently the hdbuserstore on the DB host as <dbsid>adm looks like this:

hdbuserstore list

DATA FILE : /usr/sap/<DBSID>/home/.hdb/<DBhost>/SSFS_HDB.DAT

KEY FILE : /usr/sap/<DBSID>/home/.hdb/<DBhost>/SSFS_HDB.KEY

KEY <DBSID>SAPDBCTRL

ENV : <DBhost>:<DBport>

USER: <DBSID>SAPDBCTRL

According to the documentation the sapdbctrl should use the <DBSID>SAPDBCTRL key in order to connect to the database. I also tried to create SAPDBCTRL key which did not help either.

Furthermore the sapdbctrl does not respond well when being called from the command line:

./sapdbctrl -H

This program is not supposed to be used in this way

Thank you for your support.

BR,

Lukas H.

[starkbr · Accepted solution]

Hi Lukas,

such behavior could be in theory caused by invalid X user status.

By any chance, is the same user used by other functionality. e.g SAP LVM ? As it also uses sapdbctrl so possibly there could be some interference.

Regards,

Brano

[former_member597277 · Accepted solution]

Hello Brano,

Thanks for reply. Your assumption was correct. SAP LVM was triggering the sapdbctrl with the defined user. After I changed it everything went back to normal.

BR,

Lukas H.