Cloudsync System Tables
Page 4 of 4

SYSSYNCINSTANTS

Saves the instant of the last interesting event processed from another database. In the source, this table contains one row for each target that has performed a refresh. In a target, this table contains exactly one row, which represents the source.

Cloudscape synchronization uses this table to ensure that events (such as transactions) apply exactly once, even if a refresh fails to complete successfully.

Column Name

Type

Length

Nullable

Contents

DBID

CHAR

36

false

ID of the database being synchronized with

INSTANT

COM.cloudscape.types.
DatabaseInstant


false

An "instant" in a database

TRUNCGUARD

COM.cloudscape.types.
DatabaseInstant


false

A past instant used for deleting unneeded SysSyncInstant rows

SYNCID

CHAR

36

false

ID of the event to which the instant refers

Indexes

Unique index SYSSYNCINSTANTS_INDEX1 on (DBID)