ttRepStateSave

This procedure saves the state of a remote peer database in an active standby pair to the currently connected database. Currently, may only be used to indicate to the active database that the standby database, storeName on hostName, has failed, and that all updates on the active database should be replicated directly to the read-only subscribers.

Required Privilege

This procedure requires the ADMIN privilege.

Usage in TimesTen Scaleout and TimesTen Classic

This procedure is supported in TimesTen Classic but not supported in TimesTen Scaleout.

Related Views

This procedure has no related views.

Syntax

ttRepStateSave('state', 'storeName', 'hostName')

Parameters

ttRepStateSave has these parameters:

Parameter	Type	Description
`state`	`TT_VARCHAR (20) NOT NULL`	The replication state of the indicated database. May only be specified as `FAILED` in this release. Recording that a standby database has failed indicates that all replicated updates are to be sent directly from the active database to the read-only subscribers.
`storeName`	`TT_VARCHAR (200) NOT NULL`	Name of the database for which the state is indicated.
`hostName`	`TT_VARCHAR (200)`	Name of the host where the database resides.

Result Set

ttRepStateSave returns no results.

Examples

To indicate to the active database that the standby database standby on host backup1 has failed, use:

ttRepStateSave('FAILED', 'standby', 'backup1');