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. repserver.diag is located in the bin directory by default.
  2. Forward the output to the standard output or to the errorlog:
    • 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
    It logs the commands in the form:
    Command sent to ‘RDS.RDB’ : command