> Documentation > Backup and Restore Agents > Databases > SAP > SAP HANA > Commvault Command Line

Modifying SAP HANA Instances Using the Commvault Command Line Interface

Use XML to modify SAP HANA instance properties. Run the operation from the command line, or automate configuration by combining command line operations in a script.

Procedure

  1. If you are not logged on to the CommServe computer, run the qlogin command.

  2. Download the updateInstance.xml file to the computer where you will run the command.

  3. On the command line, go to Software_Installation_Directory/Base and type the command.

     
    qoperation execute -af updateInstance.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 add multiple nodes, you must manually add a DBInstances element for each node in the CreateInstance.xml file before you type the qoperation command.

  4. To log off the CommServe computer, run the qlogout command.

Examples

Modify the software compression

The following command modifies the software compression. In this example, the parameters are listed on the command line.

 
qoperation execute -af updateInstance.xml -instance/clientName 'hana03SI1' 'hana03SI1' -instanceName 'SI1' - softwareCompression 'USE_STORAGE_POLICY_SETTINGS'

Add multiple hosts

If you want to add multiple hosts, specify a DBInstances element for each physical host that you want to include before you run the qoperation command.

For example, if upghana01, upghana02 is already added for the given HANA instance and you want to add a new host upghana03, include all the existing and new hosts again as shown in the following structure:

<DBInstances> 
  <clientName>upghana01</clientName>
  <type>GALAXY</type>
</DBInstances>
<DBInstances>
  <clientName>upghana02</clientName>
  <type>GALAXY</type>
</DBInstances>
<DBInstances>
  <clientName>upghana03</clientName>
  <type>GALAXY</type>
</DBInstances>

Remove a host

If you want to remove a host, specify a DBInstances element for each physical host that you want to include and leave out the one that you want to remove. For example, if there are 3 hosts (upghana01, upghana02 and upghana03), and you want to remove upghana02, use the following structure: 

<DBInstances>
  <clientName>upghana01</clientName>
  <type>GALAXY</type>
</DBInstances>
<DBInstances>
  <clientName>upghana03</clientName>
  <type>GALAXY</type>
</DBInstances>

Loading...