Set optional parameters

Edit online

Optional parameters follow the set command and positional parameters.

/CONFIGfile=configfilename
The /configfile parameter specifies the name of the IBM Storage Protect Snapshot configuration file, which contains the values for the IBM Storage Protect Snapshot configurable options.
Considerations:
  • configfilename can include a fully qualified path. If configfilename does not include a path, it uses the directory where IBM Storage Protect Snapshot is installed.
  • If configfilename includes spaces, place it in double quotation marks.
  • If you do not specify configfile, the default value is tdpsql.cfg.
  • If you specify configfile but not configfilename, the default value tdpsql.cfg is used.
/MOUNTRW=Yes|No

You can mount a read/write copy of your IBM Storage Protect backup so that you can modify the copy without invalidating the backup. You use this option to indicate whether a snapshot backup is mounted as read/write. The default value is as specified in the configuration file with the /MOUNTRW parameter. If a default value is not specified in the configuration file, the default value is No. By specifying the /MOUNTRW option, you override the default value.

The following values are available:
No
Perform a read-only mount operation.
Yes
Perform a read/write mount operation. The behavior of the read/write mount is controlled by the USESNAPOFASNAPTOMount parameter in the configuration file.
  • If USESNAPOFASNAPTOMount is set to No, you can mount only COPY backups as read/write. After mounting, the original backup is modified and can no longer be used as a restore point in future database restore operations (on the VSS Options properties page, the Mount read/write (modifies backup, applies to COPY backups only) check box is selected).
  • If USESNAPOFASNAPTOMount is set to Yes, you can mount both FULL and COPY backup types as read/write (on the VSS Options properties page, the Mount read/write (without modifying backup) check box is selected). In this instance, the backups are not modified and can be used in future restore operations.
    Important:
    This mount option is only available for the following devices:
    • SAN Volume Controller (SVC) devices, which require IBM® System Storage® Support for Microsoft Virtual Disk and Volume Shadow Copy Services version 4.12 or later. Dynamic target allocation is not supported.

    • XIV system devices, which require IBM Storage Accelerate Family Provider for Microsoft Windows Volume Shadow Copy Service version 2.9 or later.

    You must allocate more target volumes on your storage device to accommodate the number of concurrent read/write mounts you want to do. An extra target volume that matches the size of the volume to be mounted, is needed for each concurrent read/write mount of that volume.
SQLCHECKSum=Yes | No
The SQLCHECKSum parameter specifies whether SQL checksum processing is set for all legacy database backups. If you do not specify a value of Yes for this parameter, the value that is specified in the tdpsql.cfg file is used. If no value is specified in the tdpsql.cfg file, the default value of No is used.

The SQLCHECKSum parameter is only available with legacy backups.

/SQLCOMPression=Yes | No
The /sqlcompression parameter specifies whether SQL compression is applied. If you do not specify /sqlcompression, the default value No is used.

This parameter is only applicable on systems that run SQL Server 2008 or later versions. For SQL Server 2008, you can run backup compression only on Enterprise Edition. For SQL Server 2008 R2, backup compression is supported on Standard, Enterprise, and Datacenter editions.