Task 5: Start 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.

Note:

The ttRepStart connects to the Oracle database using the credentials that were registered with the ttCacheUidPwdSet built-in procedure back in Register the Cache Administration User Name and Password. Since you set CacheAdminWallet=1 in the DSN, the credentials are passed within an Oracle Wallet that contains the cache administration user name and the passwords for both cache administration users.

After you have created an AWT cache group, start the replication agent on the TimesTen database. Exit ttIsql.

Command> CALL ttRepStart;
Command> exit;
Disconnecting...
Done.