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 |
---|---|---|
|
TT_VARCHAR(10) NOT NULL |
Specifies the policy used to determine when the TimesTen cache agent for the database should run. Valid values are:
|
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.