ttCacheConfig

Description

For all cache groups that cache data from the same Oracle instance, this procedure specifies a timeout value and recovery policies in the case that the Oracle Server is unreachable and the cache agent or data store is considered dead.

The automatic refresh state of the data store and cache groups can be determined from the procedure ttCacheDbCgStatus.

Required privilege

This procedure requires the CACHE_MANAGER privilege.

Syntax

ttCacheConfig(Param, tblOwner, tblName, Value)

Parameters

ttCacheConfig has these parameters:

Parameter	Type	Description
`Param`	VARCHAR2(50) NOT NULL	Specifies the parameter to be set by `Value`: `AgentTimeout` - Number of seconds before a data store is declared dead if the cache agent cannot connect to the Oracle server. `DeadDbRecovery` - Specifies the type of autorefresh recovery when the cache agent restarts. `TblSpaceFullRecovery` - Specifies the action that TimesTen takes when the cached Oracle table is updated and the cache administration user's tablespace is full. `TblSpaceThreshold` - Specifies the cache administration user's tablespace usage warning threshold as a percentage.
`tblOwner`	VARCHAR2(30)	Specifies the owner of the cached Oracle table. This parameter is required if `Param` is set `TblspaceFullRecovery`. Do not specify `tblOwner` for other values of `Param`.
`tblName`	VARCHAR2(30)	Specifies the name of the cached Oracle table. This parameter is required if `Param` is set `TblspaceFullRecovery`. Do not specify `tblOwner` for other values of `Param`.
`Value`	VARCHAR2(200)	Specifies the value to be set for `Param`. When `Param` is `AgentTimeout`, it specifies the number of seconds before a data store is declared dead if the cache agent cannot connect to the Oracle server. The default is 0, which means that the data store is never declared dead. When `Param` is `DeadDbRecovery`, the value can be `Normal` or `Manual`. `Normal` specifies a full automatic refresh. `Manual` specifies that REFRESH CACHE GROUP statement must be issued. The default is `Normal`. When `Param` is `TblSpaceFullRecovery`, the value can be `Reload` or `None`. `Reload` specifies that rows are deleted from the change log table and a full automatic refresh is performed. `None` specifies that an Oracle error is returned when the cached Oracle table is updated. The default is `Reload`. When `Param` is `TblSpaceThreshold`, the value can be 0 to 100. The default is 0, which means no warning is returned regardless of the tablespace usage.

Result set

ttCacheConfig returns no results when it is used to set parameter values. When it is used to return parameter settings, it returns these results:

Column	Type	Value
`Param`	VARCHAR2(50)	Parameter name: `AgentTimeout` `DeadDbRecovery` `TblSpaceFullRecovery` `TblSpaceThreshold`
`tblOwner`	VARCHAR2(30)	Owner of the cached Oracle table.
`tblName`	VARCHAR2(30)	Name of the cached oracle table.
`Value`	VARCHAR2(200)	Specifies the value set for `Param`. When `Param` is `AgentTimeout`, it specifies the number of seconds before a data store is declared dead if the cache agent cannot connect to the Oracle server. When `Param` is `DeadDbRecovery`, the value can be `Normal` or `Manual`. When `Param` is `TblSpaceFullRecovery`, the value can be `Reload` or `None`. When `Param` is `TblSpaceThreshold`, the value can be 0 to 100.

Examples

To set the cache agent timeout to 600 seconds (10 minutes), enter:

CALL ttCacheConfig('AgentTimeout',,,'600');

To determine the current cache agent timeout setting, enter:

CALL ttCacheConfig('AgentTimeout');
< AgentTimeout, <NULL>, <NULL>, 600 >
1 row found.

To set the recovery method to Manual for cache groups whose automatic refresh status is dead, enter:

CALL ttCacheconfig('DeadDbRecovery',,,'Manual');

Configure the IMDB cache to prevent an automatic full refresh and receive an Oracle error when there is an update on a cached Oracle table while the cache administration user's tablespace is full. The Oracle table is terry.customer.

CALL ttCacheConfig('TblSpaceFullRecovery','terry','customer','None');

To determine the current setting for TblSpaceFullRecovery on the terry.customer cached Oracle table, enter:

CALL ttCacheConfig('TblSpaceFullRecovery','terry','customer');
< TblSpaceFullRecovery, TERRY, CUSTOMER, none >
1 row found.

To configure a warning to be returned when the cache administration user's tablespace is 85 percent full and an update operation occurs on the cached Oracle table, enter:

CALL ttCacheConfig('TblSpaceThreshold',,,'85');

Notes

This procedure is available only for IMDB Cache.