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.