ttCachePolicySet

This procedure defines the policy used to determine when the TimesTen cache agent for the connected database should run. The policy can be either always or manual.

Required Privilege

This procedure requires the CACHE_MANAGER 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

ttCachePolicySet('cachePolicy')

Parameters

ttCachePolicySet has these parameters:

Parameter Type Description

Parameter	Type	Description
`cachePolicy`	TT_VARCHAR(10) NOT NULL	Specifies the policy used to determine when the TimesTen cache agent for the database should run. Valid values are: `always` - Specifies that the agent for the database is always running. This option immediately starts the TimesTen cache agent. When the TimesTen daemon restarts, TimesTen automatically restarts the cache agent. `manual` (default) - Specifies that you must manually start the cache agent using either the `ttCacheStart` built-in procedure or the `ttAdmin` `-cacheStart` command. You must explicitly stop the cache agent using either the `ttCacheStop` built-in procedure or the `ttAdmin` `-cacheStop` command. `norestart` - Specifies that the cache agent for the database is not to be restarted after a failure.

cachePolicy

TT_VARCHAR(10)
NOT NULL

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

always - Specifies that the agent for the database is always running. This option immediately starts the TimesTen cache agent. When the TimesTen daemon restarts, TimesTen automatically restarts the cache agent.

manual (default) - Specifies that you must manually start the cache agent using either the ttCacheStart built-in procedure or the ttAdmin -cacheStart command. You must explicitly stop the cache agent using either the ttCacheStop built-in procedure or the ttAdmin -cacheStop command.

norestart - Specifies that the cache agent for the database is not to be restarted after a failure.

Result Set

ttCachePolicySet returns no results.

Examples

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

CALL ttCachePolicySet ('always');

Notes

This procedure is available only for cache operations.
Always specify the TimesTen database location as a full path. If a relative path is specified, TimesTen would look relative to the working directory of the daemon, timesten_home/info.
Successfully setting the policy to always automatically starts the cache agent if it was stopped.