SQL Remote User's Guide
  SQL Remote Administration
    Running the Message Agent

Troubleshooting errors at remote sites

There are obvious obstacles for an administrator who has access only to the consolidated site to troubleshoot errors that occur at remote sites. To assist with this task, you can set up SQL Remote so that portions of the output log from remote sites are delivered to the consolidated site and written to a file. This one file contains logging information from some or all sites in the system.

To set up SQL Remote to collect log information, you must configure both the remote and the consolidated sites.

To configure a remote database to send log information to the consolidated database

1. Set a link option to send log information when an error is encountered.

   Execute the following command against the remote database:

   SET REMOTE link-name OPTION
   PUBLIC.OUTPUT_LOG_SEND_ON_ERROR = 'YES'

   With this option set, any message that starts with the error indicator 'E' causes SQL Remote to send log information to the consolidated site.

   For more information, see SET REMOTE OPTION statement [SQL Remote].

2. Set a link option to limit the amount of information sent to the consolidated site. This step is optional.

   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 nnnK 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

• Use either the -ro or the -rt Message Agent option.

  For more information, see The Message Agent.