HANA 2- Add new system via Linux command line

[chladek]

Hello,
as is in HANA Studio possible 'Add new system' is it possible do it from Linux command line?
I made bash script for fully automated Installation HANA 2 + SAB B1 v10 and last thing what I miss is add the new system into HANA.

Thank You
Regards Zdenek

[dvankempen]

Got the answer to your question? To improve the knowledge base and make the right answers easier to find, please mark the best answer and close the question. Thanks!

Don’t know how? See https://answers.sap.com/questions/13162472/how-to-mark-an-answer-and-how-to-close-a-question.html

For the readers, before you leave, don't forget to up/down vote the answers. You can vote on the question too.

Thanks.

[dvankempen]

Hi zdenek.chladek,

The SAP HANA cockpit web client has an API to do this programmatically but for SAP HANA studio all we have are a few command line parameter flags.

Would this solve your issue?

• https://help.sap.com/viewer/6b94445c94ae495c83a19646e7c3fd56/2.0.05/en-US/50b9056b780f4072a88237bbd2...

If not, Studio is just a plugin for Eclipse so you could look into what programmatically is possible with the IDE. For SAP HANA studio plugin, development stopped in 2016 so you would have to look at 3rd party solutions.

[chladek]

Hello Denys,
Your are close to my purpose. What exactly I would like is add service 'scriptserver' into Tenant database. The mentioned command from your link:

hdbstudio -h hana1 -n 02 -u DBADMIN -d Tenant01

will probably want to open HANA Studio with GUI and I need do all without GUI

[dvankempen]

Two different topics,

• opening SAP HANA studio with GUI probably can be achieved using its configuration file: hdbstudio.ini. You would have to Google this a bit but as mentioned, studio is just an Eclipse plugin. Some JVM setting.
• the script server is adding by changing system parameter. For this there is a SQL Interface and, as of SPS 05, also a Python utility

See

• https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.05/en-US/ee36e3441ae24a7883ab353631...
• https://launchpad.support.sap.com/#/notes/1650957
  
• https://blogs.sap.com/2020/06/30/hana-parameter-change-without-db-user-from-console-tool-setparamete...
  

[chladek]

Thank You Denys,
in this way it should be possible, directly from Linux command line.
/usr/sap/NDB/SYS/exe/hdb/

./hdbsql -n localhost -u SYSTEM -p mypass "ALTER DATABASE MY_TENANT_DATABASE ADD 'scriptserver' ;"

[chladek]

last thing what I miss is pass the password in the command via variable in bash script

./hdbsql -n localhost -u SYSTEM-p $mypass -d SYSTEMDB "ALTER DATABASE MY_TENANT_DATABASE ADD 'scriptserver' ;"

[dvankempen]

Best to use the secure user store. You can find some example here

• https://blogs.sap.com/2016/03/18/sap-Hana-database-interactive-terminal-hdbsql-by-the-sap-Hana-acade...

For the documentation, see

• https://help.sap.com/viewer/b3ee5778bc2e4a089d3299b82ec762a7/2.0.05/en-US/dd95ac9dbb571014a7d7f0234d...

[HakanHaslaman]

It looks not possible:
https://help.sap.com/viewer/a2a49126a5c546a9864aae22c05c3d0e/2.0.00/en-US/d89c2f69142c4c25a479553796...