Starting and Stopping the Replication Agent
Performing asynchronous writethrough operations requires that the replication agent be running on the TimesTen database that contains AWT cache groups.
Running a CREATE ASYNCHRONOUS WRITETHROUGH CACHE GROUP
statement creates a replication scheme that enables committed changes on the TimesTen
cache tables to be asynchronously propagated to the cached Oracle Database tables.
After you have created AWT cache groups, start the replication agent on the TimesTen database by calling the ttRepStart
built-in procedure as the cache administration user. This connects using an Oracle Wallet that contains the passwords for both cache administration users.
Connect as the TimesTen cache administration user and provide credentials in the Oracle Wallet.
% ttIsql "DSN=cache1;UID=cacheadmin;PwdWallet=/wallets/cacheadminwallet" Command> call ttRepStart;
It can also be started from a command line by running a ttAdmin
-repStart
utility command as a TimesTen external user with the
CACHE_MANAGER
privilege:
% ttAdmin -repStart cache1
The replication agent does not start unless there is at least one AWT cache group or replication scheme in the TimesTen database.
If the replication agent is running, it must be stopped before you can issue another CREATE ASYNCHRONOUS WRITETHROUGH CACHE GROUP
statement or a DROP CACHE GROUP
statement on an AWT cache group.
You can stop the replication agent by calling the ttRepStop
built-in procedure as the cache administration user:
Command> call ttRepStop;
You can also stop the replication agent from a command line with the ttAdmin -repStop
utility command as a TimesTen external user with the CACHE_MANAGER
privilege:
% ttAdmin -repStop cache1