Loading...

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

You can add a new host by specifying a DBInstances element for each physical host before you run the qoperation command.

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

Remove a host

If you want to remove a host, then specify a 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>

Last modified: 2/26/2018 3:09:34 PM