Controls the size of value that the Message Agent treats as a long object (BLOB).
Integer, in bytes
|PUBLIC role||For current user||For other users|
|Allowed to set permanently?||Yes, with SET ANY USER DEFINED OPTION||Yes||Yes, with SET ANY USER DEFINED OPTION|
|Allowed to set temporarily?||No||No||No|
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 do not set the value of this option to a size larger than your message size (50 KB by default).