inc=number[ K | M ]; ...

Increment=number[ K | M ]; ...

The value of this option specifies, very approximately, the size of each upload part in bytes. Use the suffix k or m to specify units of kilobytes or megabytes, respectively.

When this option is set to a non-zero value, uploads are sent to MobiLink in one or more parts. This could be useful if dbmlsync has difficulty maintaining a connection to the MobiLink server for long enough to complete the full upload. the default is 0.

The value of the option controls the size of each upload part as follows. Dbmlsync builds the upload by scanning the database transaction log. When this option is set, dbmlsync scans the number of bytes that are set in the option, and then continues scanning to the first point at which there are no outstanding partial transactions—the next point at which all transactions have either been committed or rolled back. It then sends what it has scanned as an upload part and resumes scanning the log from where it left off.

You cannot use the Increment extended option with scripted upload or transactional upload.

The following dbmlsync command line illustrates how you can set this option when you start dbmlsync:

dbmlsync -e "inc=32000"

The following SQL statement illustrates how you can store this option in the database:

CREATE SYNCHRONIZATION SUBSCRIPTION
   TO sales_publication
   FOR ml_user1
   OPTION inc='32k';