Subscriber Database Operations

Use this form of ttRepAdmin to check the status or reset the state of a subscriber (receiver) database.

ttRepAdmin -receiver [-name receiverName]
[-host receiverHostName] 
       [-state receiverState] [-reset]
       [-list] [-scheme [owner.]schemeName]
       {DSN | -connStr connection_string}

Options

ttRepAdmin -receiver has the options:

Option	Description
`DSN`	Data source name of the master database.
`-connStr` `connection_string`	Connection string of the master database, an ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings.
`-receiver`	Subscriber databases receiving updates from the master. Use `-name` and `-host` to specify a specific subscriber database.
`-name` `receiverName`	A specific subscriber (receiving) database. The `receiverName` is the last component in the database path name.
`-host` `receiverHostName`	Host name or TCP/IP address of the subscriber host.
`-state start` `-state stop` `-state pause`	Sets the state of replication for the subscriber. `start` (default) - Starts replication to the subscriber. `stop` - Stops replication to the subscriber, discarding updates. `pause` - Pauses the replication agent, preserving updates. See Set the Replication State of Subscribers in Oracle TimesTen In-Memory Database Replication Guide for more information.
`-reset`	Clears the bookmark in the master database log for the latest transaction to be sent to a given subscriber. This option should only be used when the transaction numbering of the master database is changed, such as when the database is re-created using `ttMigrate` or `ttBackup`. If the master database is saved and restored using `ttBackup` and `ttRestore`, transaction numbering is preserved and this option should not be used.
`-list`	Lists information about a replication definition.
`-scheme` [`owner`.]`schemeName`]	Specifies the replication scheme name when there is more than one scheme.

Examples

% ttRepAdmin -receiver -list my_dsn

The above syntax lists replication information for all the subscribers of the master database, my_dsn.

% ttRepAdmin -receiver -name rep_dsn -list my_dsn

The above syntax lists replication information for the rep_dsn subscriber of the master database, my_dsn.

% ttRepAdmin -receiver -name rep_dsn -reset my_dsn

The above syntax resets the replication bookmark with respect to the rep_dsn subscriber of the master database. Should only be used when migrating a replicated database with ttMigrate or ttBulkCp.

% ttRepAdmin -receiver -name rep_dsn -state Start my_dsn

The above syntax resets the replication state of the rep_dsn subscriber database to the Start state with respect to the master database, my_dsn.