Register Login

saphostagent functions of querying the database status for NewDB

Updated May 18, 2018

The saphostagent functions for querying the database status and for starting and stopping the database are now also available for the NewDB.

Apply a SAPHOSTagent patch with at least patch level 84.

If you want to use the connect without a password, the following prerequisites must be met:
1. To query information from the database, you require a database user with the monitoring role.
You can create a database user with the NewDB studio. Connect as the SYSTEM user and execute the following SQL commands:
   CREATE USER SAPDBCTRL PASSWORD x<password>x
   GRANT MONITORING TO SAPDBCTRL
Then logon to the NewDB studio under the username <username> and execute the following command:
   ALTER USER SAPDBCTRL PASSWORD  <password>

2. As the OS user <sid>adm, you must provide the user key <SID>SAPDBCTRL in hdbuserstore on the database server. You can check the existence of the user key with the following command:
   hdbuserstore LIST <SID>SAPDBCTRL
If the user key does not exist, you can create it as follows:
   hdbuserstore SET <SID>SAPDBCTRL <dbhost>:<port> SAPDBCTRL <password>

The tool hdbuserstore is installed under the following paths:
/usr/sap/hdbclient or
/usr/sap/<SID>/hdbclient

3. To check whether the sapdbctrl queries without passwords work, execute the following command as OS user <sid>:
    /usr/sap/hostctrl/exe/saphostctrl -function GetDatabaseStatus -dbname <SID> -dbtype hdb


If sapdbctrl responds with the following error text:
ERROR: Database user authentication failed: SQLDriverConnect: Connect with userkey failed!
then you must check the connect data in hdbuserstore again.


×