ttCacheStart

This procedure starts the TimesTen cache agent for the connected database.

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

ttCacheStart()

Parameters

ttCacheStart has no parameters.

Result Set

ttCacheStart returns no results.

Examples

To start the cache agent, use:

CALL ttCacheStart ();

Notes

This procedure is available only for cache operations.
The cache administration user ID and password must be set with the ttCacheUidPwdSet built-in procedure before starting the cache agent when there are or might be autorefresh or asynchronous writethrough cache groups in the database.
If you attempt to start the cache agent (by changing the policy from manual to always) for a database with a relative path, TimesTen looks for the database relative to where the TimesTen Data Manager is running, and fails. For example, on Windows, if you specify the path for the database as DataStore=./payroll and attempt to start the cache agent with this built-in procedure, the agent is not started because TimesTen Data Manager looks for the database in the \srv directory.
When using this procedure, no application, including the application making the call, can be holding a connection that specifies database-level locking (LockLevel=1).