ttCachePolicyGet

Description

Returns the current 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 no privilege.

Syntax

ttCachePolicyGet()

Parameters

ttCachePolicyGet has no parameters.

Result set

ttCachePolicyGet returns the result:

Column Type Value

Column	Type	Value
`cachePolicy`	TT_VARCHAR(10)	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)

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.

Examples

To get the current policy for the TimesTen cache agent, use:

CALL ttCachePolicyGet ();

Notes

This procedure is available only for IMDB Cache.