Note Applies to only solidDB Advanced Replication configurations.
DROPSYNCBOOKMARKbookmark‑name
Access requirements
In master database: DBA or SYS_SYNC_ADMIN_ROLE role
Usage
Use the DROP SYNC BOOKMARK statement to drop a bookmark that is defined on a master database.
Bookmarks are typically used when exporting data to a file. After a file is successfully imported to a replica database from the master database, it is recommended that you drop the bookmark that you used to export the data to a file.
The DROP SYNC BOOKMARK statement cannot be used in a replica database.
If a bookmark remains, all subsequent changes to data on the master database including deletes and updates are tracked on the master database for each bookmark to facilitate incremental refreshes.
If you do not drop bookmarks, the history information takes up disk space and unnecessary disk I/O is incurred for each bookmark that is registered in the master database. This can result in performance degradation.
Note Bookmarks should be dropped only after exported data is imported into all intended replica databases and all the replica databases have synchronized with the master database at least one time.
When dropping bookmarks, solidDB uses the following rules to delete history records:
▪ Find the oldest REFRESH that was delivered to any replica database.
▪ Find the oldest bookmark.
▪ Delete all rows from the history that are older than both the oldest REFRESH and the oldest bookmark.