ttRepPolicyGet

This procedure returns the replication restart policy used to determine when the TimesTen for the connected database should run. The policy can be always, manual, or norestart.

Required Privilege

This procedure requires no privilege.

Related Views

This procedure has no related views.

Syntax

ttRepPolicyGet()

Parameters

ttRepPolicyGet has no parameters.

Result Set

ttRepPolicyGet returns the results:

Column Type Description

repPolicy

TT_VARCHAR (10)

The policy used to determine when the TimesTen replication agent for the database should run. Valid values are:

always - Specifies that the replication agent for the database 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 database is not to be restarted after a failure.

Examples

To set the policy for TimesTen replication agent to always, use:

CALL ttRepPolicyGet();

See Also