Command Line Interface for the Server Manager

Back Next

set scn

Sets the Sync Point values for the mapped target tables in a replication configuration.

For DB2 and Microsoft SQL Server sources, the Sync Point value is an LSN.

For MySQL sources, the Sync Point value is a log coordinate that represents the binary log file index and offset position.

For Oracle sources, the Sync Point value is an SCN.

set scn configuration_name [connection_name] SyncPoint_value_list

The following short form is acceptable:

sscn configuration_name [connection_name] SyncPoint_value_list

The following table describes the command parameters:

Parameter	Description
configuration_name	The name of the configuration for which to set the Sync Point values.
connection_name	The name of the connection for the target database that contains the tables for which to set the Sync Point values for the Applier. Include this parameter if you use connections that are defined on the Server Manager tab > Connections view to connect to the target.
SyncPoint_value_list	The list of the Sync Point values for the mapped target tables that the get scn command generated. For example, for Oracle, the list has the following format: '`objectID_1` `scn_1` `low_scn_1`' '`objectID_2` `scn_2` `low_scn_2`'...

The following example command sets the Sync Point values in the Ora2Ora_config configuration:

set scn Ora2Ora_config '74599 26572854 0' '74597 26572854 0' '74586 26572852 0'

The following example command sets the Sync Point values for a target that uses the Ora_tgt2 connection in the Ora2Ora_config configuration:

sscn Ora2Ora_config Ora_tgt2 '74599 26572854 0' '74597 26572854 0' '74586 26572852 0'