Debug LTL

LTL (Log Transfer Language) is the syntax used to communicate or distribute replication data to Replication Server. It is the principal output from a Mirror Replication Agent. For more details about LTL syntax, see the Replication Server Design Guide.

StepsDebugging LTL

  1. Log in to the running Mirror Replication Agent instance using the administrator login.

  2. Verify that the Mirror Replication Agent instance is in Admin state:

    ra_status
    
  3. Set the values of the following Mirror Replication Agent configuration parameters for the primary database:

    ra_config LITTRACELTL, true
    
  4. Change the Mirror Replication Agent state to Replicating:

    resume
    
  5. When new replication activity is generated, check the LTITRACELTL.log file in the log directory to debug your problem.

By default, the LTL generated by the Mirror Replication Agent is compressed to reduce the amount of data sent to Replication Server. If you require more verbose output to help debug a problem, change the following configuration parameters.

StepsProducing more verbose LTL

  1. Log in to the running Mirror Replication Agent instance using the administrator login.

  2. Verify that the Mirror Replication Agent instance is in Admin state:

    ra_status
    
  3. Set the values of the following Mirror Replication Agent configuration parameters for the primary database:

    ra_config column_compression, false
    
    ra_config compress_ltl_syntax, false
    
    ra_config structured_tokens, false
    
  4. When new replication activity is generated, check the LTITRACELTL.log file in the log directory to debug your problem.