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 Replication Agent. For more details about LTL syntax, see the Replication Server Design Guide.

StepsDebugging LTL

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

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

    ra_status
    

    If the Replication Agent instance is not in the Admin state, quiesce the Replication Agent:

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

    ra_config LITTRACELTL, true
    
  4. Change the 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 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 Replication Agent instance using the administrator login.

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

    ra_status
    

    If the Replication Agent instance is not in the Admin state, quiesce the Replication Agent:

    quiesce
    
  3. Set the values of the following 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.