STRDTARSH - Start data refresh

Use this command to start a refresh on a subscription.

Depending on the value set for the Allow Refresh While Active system parameter, CDC Replication can allocate and exclude source tables until it completes a refresh operation. This ensures complete synchronization between the source and target tables. As a result, you should schedule a refresh so as not to interfere with normal operations.

Parameters

Table 1. Supported keywords
Keyword	Description	Choices	Notes
TARGET	Subscription name	`Name`, generic, ALL	Required
TABLES	Tables to refresh	FLAG, ALL	Optional

Subscription name (TARGET)

Specifies the name of the subscription.

This is a required parameter.

Name: Specify the name of a subscription. This must be the same name defined in Management Console.
generic*: Generic names may be used for subscriptions, by adding an asterisk (*) after one or more characters that are common to the group of subscriptions names. For example, 'abc*' specifies all subscriptions starting with the characters 'abc'.
*ALL: Specifies all subscriptions.

Tables to refresh (TABLES)

Specifies which tables will be refreshed.

*ALL: All source tables selected to the subscriptions will be refreshed.
*FLAG: Only tables that have a status of Refresh will be refreshed.; This is the default setting.

Result

Messages are placed in the Event Log.

Examples

STRDTARSH TARGET(SUB1)

CDC Replication refreshes all target tables that have a status of Refresh on subscription SUB1.

STRDTARSH
TARGET(SUB1) TABLES(*ALL)

CDC Replication refreshes all target tables on subscription SUB1.

STRDTARSH TARGET(*ALL)
TABLES(*FLAG)

CDC Replication refreshes all target tables flagged for a refresh on all subscriptions.