ttCacheStop

Description

Stops the TimesTen cache agent for the connected data store.

Required privilege

This procedure requires the CACHE_MANAGER privilege.

Syntax

ttCacheStop(timeout)

Parameters

ttCacheStop has the parameter:

Parameter	Type	Description
`timeout`	TT_INTEGER	Specifies that the TimesTen daemon should kill the cache agent if it doesn't stop within `timeout` seconds. If set to 0, the daemon waits forever for the cache agent. The default value is 100 seconds.

Result set

ttCacheStop returns no results.

Examples

To stop the TimesTen cache agent, use:

CALL ttCacheStop();

Notes

This procedure is available only for IMDB Cache.

Do not shut down the cache agent immediately after dropping or altering a cache group. Instead, wait for at least two minutes. Otherwise, the cache agent may not get a chance to clean up the Oracle objects that were used by the AUTOREFRESH feature.

When using this procedure, no application, including the application making the call, can be holding a connection that specifies data store-level locking (LockLevel=1).