ttCachePolicyGet

This procedure returns the current 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 no 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

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

cachePolicy

TT_VARCHAR(10)

Specifies the policy used to determine when the 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 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.

Examples

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

CALL ttCachePolicyGet ();

This procedure is available only for cache operations.