Use XML to add SAP HANA instances. Run the operation from the command line, or automate configuration by combining command line operations in a script.
Procedure
-
If you are not logged on to the CommServe computer, run the qlogin command.
-
Download the CreateInstance.xml file to the computer where you will run the command.
-
On the command line, go to Software_Installation_Directory/Base and type the command.
qoperation execute -af CreateInstance.xml -instance/clientName '$[client_name]' -instance/instanceName '$[instance_name]' -saphanaInstance/SAPHANAUser/userName '$[sap_hana_user]' -saphanaInstance/dbInstanceNumber $[database_instance_number] -saphanaInstance/dbUser/userName '$[user_name]' -saphanaInstance/dbUser/password '$[user_password]' -saphanaInstance/DBInstances/clientName '$[client]' -saphanaInstance/hdbsqlLocationDirectory '$[hdbsql_directory]' -commandLineStoragePolicy/storagePolicyName '$[command_line_storage_policy]' -logBackupStoragePolicy/storagePolicyName '$[log_backup_storage_policy]'
Notes:
-
For information on supported instance XML parameters, see XML Parameters for SAP HANA Instance Configuration.
-
You can define the XML parameters in the xml file, instead of on the command line. For information on command line parameters and XML elements, see Command Line - Syntax.
-
-
To log off the CommServe computer, run the qlogout command.
Examples
Add an Instance
The following command adds a SAP HANA instance. In this example, the parameters are listed on the command line.
qoperation execute -af CreateInstance.xml -instance/clientName '$[Multinode_M00]' -instance/instanceName '$[M09]' -saphanaInstance/SAPHANAUser/userName '$[m09adm]' -saphanaInstance/dbInstanceNumber $[86] -saphanaInstance/dbUser/userName '$[SYSTEM1]' -saphanaInstance/dbUser/password '$[password1234]' -saphanaInstance/DBInstances/clientName '$[idchana01]' -saphanaInstance/hdbsqlLocationDirectory '$[/usr/sap/M09/HDB00/exe]' -commandLineStoragePolicy/storagePolicyName '$[command_line_dedup]' -logBackupStoragePolicy/storagePolicyName '$[dedup_sp]'