Using Traces to Print Commands

Set traces to print the actual commands sent to replicate databases.

The outbound queue for the replicate database contains default commands. If you have created function strings in addition to the defaults, use a special Data Server Interface (DSI) trace flag to print the actual commands that are being sent to replicate databases.

  1. Run the debug replication server, repserver.diag, to set traces.
    By default, repserver.diag is located in the bin directory.
  2. Forward the output to the standard output or to the error log:
    • Standard output:
      trace=GEN,TRC_STDERR
    • Error log:
      trace=GEN,TRC_ERRLOG

  3. Dump the commands that are sent to the replicate site:
    trace=DSI,DSI_CMD_DUMP
    Commands are logged in this form:
    Command sent to ‘RDS.RDB’ : command