Destroy and Re-Create a Database

Destroy and recreate the TimesTen database in the replication scheme that has not yet been defragmented using ttRepAdmin -duplicate.

During these steps, application processing can continue on the defragmented database.

  1. Destroy the database:
    ttDestroy ttdb1
  2. Recreate the new TimesTen database (ttdb1) by duplicating the previously defragmented TimesTen database (ttdb2) involved in the replication scheme.
    ttRepAdmin -duplicate -from ttdb2 -host ttsrv2 –setMasterRepStart -UID ttadmin -PWD ttadminpwd ttdb1
  3. Start the replication agent on the new standby database ttdb1:
    ttAdmin –repStart ttdb1

This process defragments both of the TimesTen databases involved in either a unidirectional or bidirectional replication scheme with only a few seconds of service interruption.