The CREATE SYNC BOOKMARK statement creates a bookmark in a master database. The statement is valid only in solidDB® advanced replication setups.
A bookmark represents a user-defined version of the database. It is a persistent snapshot of a solidDB® database, which provides a reference for performing specific synchronization tasks. Bookmarks are used typically to export data from a master for import into a replica using the EXPORT SUBSCRIPTION command. Exporting and importing data allows you to create a replica from a master more efficiently if you have databases larger than 2 GB.
To create a bookmark, you must have administrative DBA privileges or SYS_SYNC_ADMIN_ROLE. There is no limit to the number of bookmarks you can create in a database. A bookmark is created only in a master database. The system issues an error if you attempt to create a bookmark in a replica database.
If a table is set up for synchronization history with the ALTER TABLE ... SET SYNCHISTORY command, a bookmark retains history information for the table. For this reason, use the DROP SYNC BOOKMARK statement to drop bookmarks when they are not longer needed. Otherwise, extra history data will increase disk space usage.
When you create a new bookmark, the system associates other attributes, such as creator of the bookmark, creation data and time, and a unique bookmark ID. This metadata is maintained in the system table SYS_SYNC_BOOKMARKS.
Usage in master
Use the CREATE SYNC BOOKMARK statement to create a bookmark in a master database.
Usage in replica
The CREATE SYNC BOOKMARK statement cannot be used in a replica database.