Command Line Interface for the Server Manager

Back Next

get scn

Lists the Sync Point values for the mapped target tables in a replication configuration. Use this command with the

set scn

command to update the Sync Point values in a configuration based on another configuration that maps the same tables.

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.

The output from the get scn command includes a row for each mapped target table. Each row contains an object ID, SCN

/log coordinate

/LSN value, low SCN

/log coordinate

/LSN value, and table name.

Use this output to create input for the

set scn

command.

get scn configuration_name [connection_name]

The following short form is acceptable:

gscn configuration_name [connection_name]

The following table describes the command parameters:

Parameter	Description
configuration_name	The name of the configuration for which to list Sync Point values.
connection_name	The name of the connection to the target database that contains the tables for which to get 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.

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

get scn Ora2Ora_config

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

gscn Ora2Ora_config Ora_tgt2

id     scn       scn_low  name
75110  26584040  0        TABLE1
76710  26584040  0        TABLE2