Cloudsync Properties
Page 12 of 17

cloudscape.synchronization.workUnitOnly

Function

The cloudscape.synchronization.workUnitOnly property determines whether targets subscribing to a given publication are forced to use work units to update data. If cloudscape.synchronization.workUnitOnly is set to true, the targets accept only data changes (INSERTs, UPDATEs, and DELETEs) made within a work unit, and the refresh operation rejects any data changes not made using a work unit. Normally this property does not cause a refresh operation to fail, because the target rejects any non-work-unit (changed value) updates before they can participate in the refresh cycle.

You cannot set the cloudscape.synchronization.workUnitOnly property at the source or target; to set it, you must include it in a CREATE PUBLICATION or ALTER PUBLICATION statement.

Be careful when adding the cloudscape.synchronization.workUnitOnly property to an ALTER PUBLICATION command. If the target accepts non-work-unit updates, and it sends such an update to the source in the same refresh operation that sets the property to true, the refresh fails and the target can no longer be refreshed. This may be acceptable, since it is easy to create a new target. But to make sure that targets are not disabled by the cloudscape.synchronization.workUnitOnly property in an ALTER PUBLICATION statement, update the targets' applications to allow only work unit updates before running the refresh operation that sets the cloudscape.synchronization.workUnitOnly property to true at the target.

Syntax

CREATE PUBLICATION pubname
...
ADD TARGET DATABASE PROPERTY
    cloudscape.synchronization.workUnitOnly=Boolean_value

Default

false

Example

CREATE PUBLICATION myPub
...
ADD TARGET DATABASE PROPERTY
    cloudscape.synchronization.workUnitOnly='true'

Scope

Database-wide