Filter
Top Products
ID specified in the Message Agent command. They can also be set for
general public use.
The options are as follows:
Blob_threshold option 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 by using a SQL variable and
concatenating the pieces at the recipient site.
If you are replicating blobs in an installation with Adaptive Server
Enterprise, you must ensure that Blob_threshold is set to a value larger the
largest blob being replicated.
☞ For information on blob replication and Adaptive Server Enterprise, see
“Replication of blobs” on page 83.
Compression option Set the level of compression for messages. Values
can be from -1 to 9, and have the following meanings:
♦ -1 Send messages in Version 5 format. Message Agents (both
dbremote
and
ssremote
) from previous versions of SQL Remote cannot read
messages sent in Version 6 format. You should ensure that
COMPRESSION is set to -1 until all Message Agents in your system are
upgraded to Version 6.
♦ 0 No compression.
♦ 1 to 9 Increasing degrees of compression. Creating messages with high
compression can take longer than creating messages with low
compression.
Delete_old_logs option This option is used by SQL Remote and by the
Adaptive Server Anywhere Replication Agent. The default setting is OFF.
When set to ON, the Message Agent (DBREMOTE) deletes each old
transaction log when all the changes it contains have been sent and
confirmed as received.
External_remote_options This option is used by SQL Remote to indicate
whether the message link parameters should be stored in the database (OFF)
or externally (ON). By default, the setting is OFF.
Qualify_owners option Controls whether SQL statements being replicated
by SQL Remote should use qualified object names. The default in Adaptive
Server Anywhere is ON and the default in Adaptive Server Enterprise is
OFF.
Qualifying owners in Adaptive Server Enterprise setups is rarely needed
because it is common for objects to be owned by dbo. When qualification is
316