Contents Index VERIFY_ALL_COLUMNS option [replication] WAIT_FOR_COMMIT option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

VERIFY_THRESHOLD option [replication]


Function 

Controls which columns are verified when updates are replicated.

Allowed values 

Integer, in bytes

Default 

1 000

Description 

This option is used by SQL Remote only. If the data type of a column is longer than the threshold, old values for the column are not verified when an UPDATE is replicated. This keeps the size of SQL Remote messages down, but has the disadvantage that conflicting updates of long values are not detected.


Contents Index VERIFY_ALL_COLUMNS option [replication] WAIT_FOR_COMMIT option [database]