The SYSSYNC system view contains information relating to synchronization. Some columns in this view contain potentially sensitive data. For that reason, access to this view is restricted to users with DBA authority. The SYSSYNC2 view provides public access to the data in this view except for the potentially sensitive columns. The underlying system table for this view is ISYSSYNC.
| Column name | Data type | Description |
|---|---|---|
| sync_id | UNSIGNED INT | A number that uniquely identifies the row. |
| type | CHAR(1) | This value is always D. |
| publication_id | UNSIGNED INT | A publication_id found in the SYSPUBLICATION system view. |
| progress | UNSIGNED BIGINT | The log offset of the last successful upload. |
| site_name | CHAR(128) | A user name. |
| "option" | LONG VARCHAR | Synchronization options. |
| server_connect | LONG VARCHAR | The address or URL of the server. |
| server_conn_type | LONG VARCHAR | The communication protocol, such as TCP/IP, to use when synchronizing. |
| last_download_time | TIMESTAMP | Indicates the last time a download stream was received from the server. |
| last_upload_time | TIMESTAMP | Indicates the last time (measured at the server) that information was successfully uploaded. The default is jan-1-1900. |
| created | UNSIGNED BIGINT | The log offset at which the subscription was created. |
| log_sent | UNSIGNED BIGINT | The log progress up to which information has been uploaded. It is not necessary that an acknowledgement of the upload be received for the entry in this column to be updated. |
| generation_number | INTEGER | For file-base downloads, the last generation number received for this subscription. The default is 0. |
| extended_state | VARCHAR(1024) | For internal use only. |
| script_version | CHAR(128) | Indicates the script version used by the CREATE and ALTER SYNCHRONIZATION SUBSCRIPTION statements and the START SYNCHRONIZATION SCHEMA CHANGE statement. |
| subscription_name | CHAR (128) | The name of the subscription. |
PRIMARY KEY (sync_id)
FOREIGN KEY (publication_id) references SYS.ISYSPUBLICATION (publication_id)
UNIQUE Index (publication_id, site_name)
UNIQUE Index (subscription_name)