Removing Grid Members from a Cache Grid

The steps below show how you can remove a grid member cachedb1_1122 from a cache grid. A cache grid can be dropped from the system, only when no databases are associated or attached to it.

The steps below must be performed as the cache manager user in the cache database. Log in to ttIsql as the cache manager user cacheadm, passing in both the TimesTen and Oracle passwords.

ttisql

connect "dsn=cachedb1_1122; uid=cacheadm; pwd=cacheadm; oraclepwd=cacheadm";


1. Detach the Grid Member from the Cache Grid
     (required only if the cache database is still attached to the cache grid)

  1. Use the procedure ttGridDetach to detach the current database from the cache grid. This step is required only if the current database is still attached to the cache grid.

    call ttgriddetach;


  2. Use the procedure ttGridNodeStatus to verify that cachedb1 is no longer attached to the cache grid.

    call ttgridnodestatus;


2. Stop the Replication Agent

  1. Use the built-in procedure ttRepStop to stop the replication agent, if it has not already been stopped.

    call ttrepstop;


3. Remove the Cache Groups

The example below shows how you can remove the two cache groups that were created in the earlier section.

  1. Enter the following DROP CACHE GROUP statements in ttIsql, to remove the cache groups cacheadm.g_awt and cacheadm.ro, and their corresponding cache tables.

    drop cache group g_awt;
    drop cache group ro;


  2. Use the ttIsql command cachegroups to verify the removal of both cache groups from the cache database.

    cachegroups;

    cachegroups after drop


4. Stop the Cache Agent

  1. Use the built-in procedure ttCacheStop to stop the cache agent process.

    call ttcachestop;


Removing a Cache Grid

  1. A cache grid can only be removed when it has no members , i.e. when no cache database is associated with it. Use the procedure ttGridDestroy to remove the specified cache grid from the system.

    call ttgriddestroy ('samplegrid');


  For more information on removing grid members from a cache grid, refer to the documentation here