Use this command to refresh the specified subscriptions. When you refresh a subscription, IBM InfoSphere CDC ensures that the target tables are synchronized with the source tables. Typically, you would refresh target tables when you have set the replication method to “Refresh” on your tables.
However, you can also refresh target tables that have a replication method set to “Mirror” and a status of “Active” or “Refresh”. When you refresh a table configured for mirroring, IBM InfoSphere CDC refreshes the target table so that it is synchronized with the source table and then marks a table capture point as the starting point for mirroring.
This command exits after it has successfully refreshed the specified subscriptions. If you terminate this program while it is still running, IBM InfoSphere CDC ends replication immediately for the specified subscriptions.
Specifies the IBM InfoSphere CDC instance for which you want to refresh one or more subscriptions. Alternatively, you can specify the TSINSTANCE environment variable in place of this value.
-a
Specifies that IBM InfoSphere CDC refreshes all target tables in the subscription.
-f
Specifies that IBM InfoSphere CDC refreshes only target tables that are flagged for refresh. If you omit both the -a and -f options, IBM InfoSphere CDC assumes -f by default.
-A
Specifies that IBM InfoSphere CDC refreshes all subscriptions.
-s <subscription_names>
Specifies that IBM InfoSphere CDC refreshes the indicated subscription. To specify multiple subscriptions, list the subscriptions separated by a space.
-L <locale>
The name of the locale used for the IBM InfoSphere CDC instance. The default is the locale of the machine where IBM InfoSphere CDC is installed.
Result
This command returns a value of 0 if the command was successful and a non-zero value if the command fails.
Examples
dmrefresh -I new_instance -a -s Finance
IBM InfoSphere CDC refreshes all target tables in the Finance subscription.