ttCachePolicySet

Description

Defines the policy used to determine when the TimesTen cache agent for the connected data store should run. The policy can be either always or manual.

Required privilege

This procedure requires the CACHE_MANAGER privilege.

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 data store should run. Valid values are: `always` - specifies that the agent for the data store is always running. This option immediately starts the TimesTen cache agent. When the TimesTen daemon restarts, TimesTen automatically restarts the cache agent `manual` - (the 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.

cachePolicy

TT_VARCHAR(10) NOT NULL

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

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

manual - (the 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.

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 IMDB Cache.

If you attempt to start the TimesTen cache agent (by changing the policy from manual to always) for a data store with a relative path, TimesTen looks for the data store relative to where TimesTen Data Manager is running, and fails. For example, on Windows, if you specify the path for the data store as DataStore=./payroll and attempt to start the TimesTen cache agent with this built-in procedure, the agent is not started because TimesTen Data Manager looks for the data store in the install_dir\srv directory. On UNIX, TimesTen Data Manager looks in the /var/TimesTen/instance directory.

Successfully setting the policy to always automatically starts the cache agent if it was stopped.