ttRepPolicySet

Description

Defines the replication restart policy used to determine when the TimesTen Replication Agent for the connected data store should run. The policy can be either always, manual, or norestart.

Required privilege

This procedure requires the ADMIN privilege.

Syntax

ttRepPolicySet('repPolicy')

Parameters

ttRepPolicySet has this parameter:

Parameter Type Description

Parameter	Type	Description
`repPolicy`	TT_VARCHAR (10) NOT NULL	Specifies the policy used to determine when the TimesTen Replication Agent for the data store should run. Valid values are: `always` - specifies that the replication agent for the data store is always running. This option immediately starts the TimesTen Replication Agent. When the TimesTen daemon restarts, TimesTen automatically restarts the Replication Agent. `manual` - specifies that you must manually start the Replication Agent using either the ttRepStart built-in procedure or the ttAdmin `-repStart` command. You must explicitly stop the Replication Agent using either the ttRepStop built-in procedure or the ttAdmin `-repStop` command. `norestart` - specifies that the replication agent for the data store is not to be restarted after a failure.

repPolicy

TT_VARCHAR (10) NOT NULL

Specifies the policy used to determine when the TimesTen Replication Agent for the data store should run. Valid values are:

always - specifies that the replication agent for the data store is always running. This option immediately starts the TimesTen Replication Agent. When the TimesTen daemon restarts, TimesTen automatically restarts the Replication Agent.

manual - specifies that you must manually start the Replication Agent using either the ttRepStart built-in procedure or the ttAdmin -repStart command. You must explicitly stop the Replication Agent using either the ttRepStop built-in procedure or the ttAdmin -repStop command.

norestart - specifies that the replication agent for the data store is not to be restarted after a failure.

Result set

ttRepPolicySet returns no results.

Examples

To set the policy for TimesTen Replication Agent to always, use:

CALL ttRepPolicySet('always');