SetSubClientProperty

Scope

Platform

• CommServe (Database: CommServ)

Release

• 9.0.0

Description

The SetSubClientProperty script allows you to modify the properties of a specific subclient. By default, the subclient takes the properties set from the CommCell Console.

Usage

Use the following command to modify the property of a specific subclient.

qoperation execscript -sn SetSubClientProperty.sql -si 'c=<client name>' -si 'a=<agent type>' -si 'i=<instance name>' -si 'b=<backup set name>' -si 's=<subclient name>' -si <subclient property> -si <subclient property value> -si <subclient property type >

where,

client name - specifies the name of the client computer

agent type - specifies the type of the iDataAgent on the client computer

instance name - specifies the name of the instance on the client computer

backup set name - specifies the name of the backup set on the client computer

subclient name - specifies the name of the subclient on the client computer

subclient property - specifies the name of the subclient property to be set

subclient property value - specifies the value with which the given subclient property is to be set

subclient property type - specifies the type of subclient to be configured. By default, the value is 7.

Examples

qoperation execscript -sn SetSubClientProperty.sql -si 'c=client_name1' -si 'a=Q_WINDOWS_FS' -si 'b=backupset_name1' -si 's=subclient_name1' -si Use VSS for System State -si 1 

Disabling the System State for Windows Files System iDataAgent (Windows Vista 32-bit, Windows Vista 64-bit, Windows Server 2008 32-bit, and Windows Server 2008 64-bit):

qoperation execscript -sn SetSubClientProperty.sql -si 'c=client_name1' -si 'a=Q_WINDOWS_FS' -si 'b=backupset_name1' -si 's=subclient_name1' -si System State -si 0

1. Create the subclient.

   qcreate subclient -cs leonard64 -c dbserve4 -a Q_ORACLE -i auto -n "NEWSUB" -sp "ying_data" -f "auto"

2. Enable Selective Online Full Option

   qoperation execscript -sn SetSubClientProperty.sql -si 'c=dbserve4' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=NEWSUB' -si 'Oracle Online Selective Full' -si '1' -si '2'

Creating Oracle Offline Subclient and enabling the Light Out script

1. Create the subclient.

   qcreate subclient -cs leonard64 -c dbserve4 -a Q_ORACLE -i auto -n "OFFLINE" -sp "ying_data" -f "auto"

2. Enable the offline option.

   qoperation execscript -sn SetSubClientProperty.sql -si 'c=dbserve4' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=OFFLINE' -si 'Oracle Backup Mode' -si '2'

3. Enable the Light Out script.

   qoperation execscript -sn SetSubClientProperty.sql -si 'c=dbserve4' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=OFFLINE' -si 'Light out Script’ -si ‘1’ -si '2'

Creating Log Only Subclient

1. Create the subclient.

   qcreate sub client -cs leonard64.devemc.commvault.com -c dbserve4 -a Q_ORACLE -i auto -n "NEWlog" -sp "ying_data" -f "auto"

2. Disable Data Option

   qoperation execscript -sn SetSubClientProperty.sql -si 'c=dbserve4' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=NEWlog' -si 'Oracle Backup Mode' -si '1' –si ‘2’

3. Disable Backup Control File Option

   qoperation execscript -sn SetSubClientProperty.sql -si 'c=dbserve4' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=NEWlog' -si 'Backup Control Files' -si '0' -si '2'

4. Disable Delete Archive Log Option

   qoperation execscript -sn SetSubClientProperty.sql -si 'c=dbserve4' -si 'a=Q_ORACLE' -si 'i=auto' -si 'b=default' -si 's=NEWlog' -si 'Archive Log Deleting' -si '0' -si '2’

Version

Disclaimer of Warranties

CommVault provides software tools and utilities on an "as is" basis, as a courtesy and convenience to its users, and they may be changed from time to time without notice. These tools and utilities are provided without express, implied, or statutory warranties of any kind. You assume full risk and responsibility for the selection, possession, performance and proper installation and use of the software tools and utilities, and for verifying the results obtained there from. Your use of CommVault software tools and utilities indicates your unconditional acceptance of the above disclaimer.