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'