Policy commands for IBM Storage Protect Snapshot for SQL

Edit online

Create Policy

This command is used to create a policy.

TDPSQLC command: CREATE POLicy

TDPSQLCCREATE POLicypolicy_name/FCMOPTFile=dsm.opt?=dsmoptfilename/VERSretain=2numberNOLimit/DAYSretain=30numberNOLimit

Parameters:

policy_name (required): Specifies the name of the policy that is being created. To create a policy, the policy name must be unique.
VERSretain: Specifies the number of snapshot versions to retain (1 - 9999). You can also specify NOLimit to represent an unlimited number of snapshot versions to retain.
DAYSretain: Specifies the number of days to retain a snapshot (0 - 9999). You can also specify NOLimit to represent an unlimited number of days to retain snapshot versions.

Update Policy

This command is used to update or modify the retention parameters of an existing policy.

TDPSQLC command: UPDATE POLicy

TDPSQLCUPDATE POLicypolicy_name/NEWname=string/FCMOPTFile=dsm.opt?=dsmoptfilename/VERSretain=numberNOLimit/DAYSretain=numberNOLimit

Parameters:

NEWname: Specifies the new name of the policy, if the name is being updated. The policy name must be unique.
policy_name (required): Specifies the name of the policy that is being updated.
VERSretain: Specifies the number of snapshot versions to retain (1 - 9999). You can also specify NOLimit to represent an unlimited number of snapshot versions to retain.
DAYSretain: Specifies the number of days to retain a snapshot (0 - 9999). You can also specify NOLimit to represent an unlimited number of days to retain snapshot versions.

Copy Policy

This command is used to copy an existing policy to a new policy.

TDPSQLC command: COPY POLicy

TDPSQLCCOPY POLicyexisting_policy_namenew_policy_name/FCMOPTFile=dsm.opt?=dsmoptfilename

Parameters:

existing_policy_name (required): Specifies the name of the policy that is being copied.
new_policy_name (required): Specifies the name of the new policy. The policy name must be unique.

Query Policy

This command is used to list the attributes of a policy.

TDPSQLC command: Query POLicy

TDPSQLCQuery POLicy*

Parameters: * (required) Specifies all policies are to be queried. The results of the query are displayed as follows:


                   Connecting to SQL Server, please wait...

Policy      Number of snapshots to keep    Days to keep a snapshot

--------    --------------------------     ----------

FCMPOL                      3               60

STANDARD                    2               30

Delete Policy

This command is used to delete a policy.

TDPSQLC command: DELete POLicy

TDPSQLCDELete POLicypolicy_name/FCMOPTFile=dsm.opt?=dsmoptfilename

Parameter:

policy_name (required): Specifies the name of the policy that is being deleted.