Defragmentation with the ttMigrate Utility

Using ttMigrate is an offline process that copies data to a new database while removing any fragmented rows, thereby reclaiming space and improving performance.

During migration, the database undergoes a period of downtime to ensure consistency and data integrity. Once the migration is complete, the new database has reduced fragmentation and improved overall performance.

The following procedures show you how to use ttMigrate to achieve database defragmentation:

• Offline Defragmentation of a TimesTen Database

• Online Defragmentation of TimesTen Databases in a Non Active Standby Pair Replication Scheme

• Online Defragmentation of TimesTen Databases in an Active Standby Pair Replication Scheme