Use XML to create Sybase subclients and run On-Demand backups. Run the operation from the command line, or automate configuration by combining command line operations in a script.
The XML parameters can be included in the XML file, or specified on the command line when they frequently change. For more information on command line parameters and XML elements, see Command Line - Syntax.
You can use an external input file to specify the content when you perform an On-Demand backup.
Note: If you use Sybase ASE version 15.7 ESD #2 (SP100) or later, you can configure the Sybase software to run transaction log dumps even when a full or cumulative dump is running. Set 'enable concurrent dump tran' to 1 to use this feature. When this feature is enabled and you run a restore, there is a possibility that the transaction log load order goes out of sequence. The following error may occur:
Specified file 'dump device' is out of sequence. Current time stamp is Nov 3 2015 1:59:59:423AM while dump was from Nov 3 2015 1:59:59:296AM.
Procedure
-
On the Sybase Agent host, run the qlogin command to log on to the CommServe computer.
-
Download the create_subclient_template.xml file to the computer where you will run the command.
For information on supported subclient XML parameters, see Available XML Parameters for Sybase Subclient Configuration.
-
On the command line, go to Software_Installation_Directory/Base and type the following command.
qoperation execute -af $[xml_path]\create_subclient_template.xml -appName '$[Sybase]' -clientName '$[client_name]' -instanceName '$[instance_name]' -subclientName '$[subclient_name]' -dataBackupStoragePolicy/storagePolicyName '$[storage_policy_name]' -onDemandSubClient $[true]
Examples
Create the subclient
qoperation execute -af $[xml_path]\create_subclient_template.xml appName '$[Sybase Database]' -instanceName $[S155syb6] -clientName $[sybserver6] -subclientName $[ondemand_sub] -dataBackupStoragePolicy/storagePolicyName $[sybase_sp] -onDemandSubClient $[true]
Perform the backup
qoperation execute -af $[xml_path]\backup_template.xml -appName '$[Sybase Database]' -clientName $[sybserver6] -instanceName $[S155syb6] -subclientName $[ondemand_sub] -ondemandinputfile $[/BOL/ondemand/list.txt] -backupLevel $[FULL]