blob_threshold option [SQL Remote]

Controls the size of value that the Message Agent treats as a long object (BLOB).

Allowed values

Integer, in bytes

Default

256

Remarks

Any value longer than the blob_threshold option is replicated as a BLOB. That is, it is broken into pieces and replicated in chunks before being reconstituted using a SQL variable and concatenating the pieces at the recipient site.

Each SQL statement must fit within a message, so you should not set the value of this option to a size larger than your message size (50 KB by default).

See also