User's Manual

Chapter 10. SQL Remote Administration
Execute the following command against the remote database:
SET REMOTE link-name OPTION
PUBLIC.OUTPUT_LOG_SEND_LIMIT = ’nnn’
The value of this option is the number of bytes at the tail of the output log
(that is, the most recent entries) which are sent to the consolidated site.
You can use nnn K to indicate kilobytes. The default setting is ’5K’.
If you supply a value that is too large to fit in the maximum message size,
SQL Remote overrides the option value and sends only what will fit in
the message.
You can also send log information even in the absence of errors by setting
the OUTPUT_LOG_SEND_NOW option to YES. SQL Remote then sends
the output log information on the next poll and resets the option to ‘NO’
after the log is sent.
❖ To configure a consolidated site to receive log information
1. Use either the -ro or the -rt Message Agent option.
☞ For more information, see “The Message Agent” on page 292.
227