Log On to the CommServe
To run command line operations, you must first login to the CommServe.
From Command prompt, navigate to <Software_Installation_Directory>/Base and run the following command:
qlogin -cs <commserve name> -u <user name>
For example, to log on to CommServe 'server1' with username 'user1':
qlogin -cs server1 -u user1
Instance Configuration
Adding an Instance
-
Download the create_instance_template.xml file and save it on the computer from where the command will be executed.
-
Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values:
qoperation execute -af create_instance_template.xml -appName "SAP for MAX DB" -clientName xxxxx -instanceName xxxxx -commandLineStoragePolicy/storagePolicyName xxxxx -logBackupStoragePolicy/storagePolicyName xxxxx -userGroupName xxxxx -associatedUserGroupsOperationType ADD
If you plan to schedule backups using a schedule policy, create the instance using the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters values:
qoperation execute -af create_instance_template.xml -appName "SAP for MAX DB" -clientName xxxxx -instanceName xxxxx -commandLineStoragePolicy/storagePolicyName xxxxx -logBackupStoragePolicy/storagePolicyName xxxxx -osUser/userName 'xxxxx' -dbUser/userName 'xxxxx' -dbmcliPath 'xxxxxx' -osUser/Password 'xxxxx' -dbUser/Password 'xxxxx' ADD
Modifying an Instance
-
Download the modify_instance_template.xml file and save it on the computer from where the command will be executed.
-
Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters and attributes.
For example, the command below modifies the name of the instance.
qoperation execute -af modify_instance_template.xml -appName "SAP for MAX DB" -clientName xxxxx -instanceName xxxxx -newName xxxxx
If you plan to schedule backups using a schedule policy, associate the instance to a schedule policy to perform the backups using the following command:
qoperation execute -af modify_instance_template.xml -appName "SAP for MAX DB" -clientName xxxxx -instanceName xxxxx -newName xxxxx -commandLineStoragePolicy/storagePolicyName 'xxxxx' -logBackupStoragePolicy/storagePolicyName 'xxxxx' -osUser/userName 'xxxxx' -dbUser/userName 'xxxxx' -dbmcliPath 'xxxxx' -osUser/Password 'xxxxx' -dbUser/Password 'xxxxx'
Deleting an Instance
Warning: If you do not include the instanceName parameter when you delete instances, all SAP MaxDB instances are deleted for the client.
-
Download the delete_instance_template.xml file and save it on the computer from where the command will be executed.
-
Execute the following command from the <Software_Installation_Directory>/Base folder after substituting the parameters and attributes.
qoperation execute -af delete_instance_template.xml -appName "SAP for MAX DB" -clientName xxxxx -instanceName xxxxx
Available Parameters for Instance Configuration
The following table displays all the parameters you can use with the commands mentioned in the above sections. To add a parameter to your command, use the following syntax:
qoperation execute -af <template XML file> -<parameter name> <value>
Parameter |
Description of Parameter Values |
clientName |
Name of the client computer. |
appName |
Name of the application. In this case it would be 'SAP for MAX DB'. |
instanceName |
Name of the SAP for MAX DB instance. |
description |
A general description of the instance. |
encryptionFlag |
Option to set the encryption points during backups. Valid values are:
|
generateSignature |
A component of deduplication performed on the client or MediaAgent computer. Valid values are:
|
networkAgents |
Number of Network Agents. |
softwareCompression |
Option to enable compression. Valid values are:
|
throttleNetworkBandwidth |
Enhancing backup performance by reducing network bandwidth overhead. Valid values are 0/1. |
enableDeduplication |
Option to enable deduplication on subclient. Valid values are True/False. |
commandLineStoragePolicy/storagePolicyName |
Name of the storage policy used to back up this instance. |
logStoragePolicy/storagePolicyName |
Name of the storage policy used to back up data and logs of this instance. |
userGroupName |
Name of the user group to be associated to the instance. This is the user group that you associate from the Security tab of the instance properties dialog box in the CommCell Console. |
associatedUserGroupsOperationType |
Specifies the operation that you want to perform on the user groups. Valid values are:
|
CvQcmdTokenFile |
You must use this parameter when the CommCell Console authenticates the user that initiates the RMAN backup or restore job. For information on configuring CommCell Console authentication, see Enabling CommCell Console Authentication of Third Party Command Line Jobs. The parameter value is the token file that you generate by running the qlogin command with the -f option. For information on running the qlogin command to generate a token file, see qlogin. |
The following example shows how to add a parameter for a command:
Modify the Log Storage Policy |
qoperation execute -af modify_instance_template.xml -appName "SAP for MAX DB" -clientName client1 -instanceName instance1 -logBackupStoragePolicy/StoragePolicyName log_SP1 |
Enable Encryption and Software Compression |
qoperation execute -af modify_instance_template.xml -appName "SAP for MAX DB" -clientName client1 -instanceName instance1 -encryptionFlag ENC_NETWORK_AND_MEDIA -softwareCompression USE_STORAGE_POLICY_SETTINGS |
Log Off from the CommServe
Once you have completed the command line operations, you can logout from the CommServe using the following command:
qlogout -cs commserve
For example, to log out from the CommServe 'Server1'.
qlogout -cs Server1