STRDTAMIR - Describe source tables to target tables

Use this command when you have updated the definition of your source table.

Applies To—Source

Parameters

Table 1. Supported keywords
Keyword Description Choices Notes
TARGET Subscription name Name, generic*, *ALL Required
IDLE Idle format *WAIT, *END Optional
FORMAT Update format *NO, *ONLY Optional
BLOCKING Blocking describe *NO, *YES 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.

Idle format (IDLE)

Specifies the action that CDC Replication will take when it determines that all definitions have been sent to the subscription.
*WAIT
CDC Replication will remain active after all source tables have been described.
This is the default setting.
*END
CDC Replication will end after all source tables have been described.

Update format (FORMAT)

Specifies the format used to updated the definition of tables.
*NO
Indicates that CDC Replication will start mirroring without sending the updated source table definition to the target.
This is the default setting.
*ONLY
Indicates CDC Replication will send the updated source table definition to the target but will not start mirroring.

Blocking describe (BLOCKING)

Indicates whether the STRDTAMIR command will block until the initiated describe completes.
*YES
The STRDTAMIR command will not be executed until the describe is complete.
*NO
The STRDTAMIR command will not wait until the describe is complete before being executed.
This is the default setting.

Result

None.

Examples

STRDTAMIR TARGET(SUB1) IDLE(*END) FORMAT(*ONLY)

Sends definitions of all source tables selected to subscription SUB1. After the transfer has been completed, all CDC Replication jobs end.

STRDTAMIR TARGET(*ALL) IDLE(*END) FORMAT(*ONLY)

Sends definitions of all source tables selected to all subscriptions. After the transfer has been completed, all CDC Replication jobs end.