Troubleshooting non-Sybase heartbeat and latency

To trace the heartbeat processes in RSM Server, activate the trace option RSML HBEATS. Use the trace options EVE GENERAL_1 and EVE GENERAL_2 to trace the latency process.

In Replication Server, you can use the DSI_BUF_DUMP trace flag to display the commands sent to the DSI connection, which is the DirectConnect database gateway for a non-Sybase data server. You do not need the diagnostic version of Replication Server to use this trace flag. Refer to the Replication Server Troubleshooting Guide for more information about Replication Server traces.

For latency calculations to work correctly, the DirectConnect gateways used to access non-Sybase databases must have the value of the DateTimeResults configuration parameter set to datetime. In addition, any Sybase Replication Agent must have the value of the ltl_origin_time_required configuration parameter set to true.

Removing heartbeat objects when the heartbeat is not running

The first time a heartbeat is started, a replication definition and a subscription are created. They remain defined unless you click Remove in the Heartbeat dialog box while the heartbeat is running.

StepsTo remove the replication definition and subscription when the heartbeat is not running

  1. From the Sybase Central desktop, right-click a Replication Server icon and choose Properties.

  2. Select the Catalog tab of the Replication Server Properties dialog box.

  3. Select Subscriptions as the object type and find the subscription named rsm_heartbeat.

  4. Delete the subscription by right-clicking the name and choosing Delete.

  5. In the Drop Subscription Information dialog box, select Without Purge in the Method box.

  6. Choose OK.

  7. Once the subscription is removed, select Replication Definitions from the Object type box and find the heartbeat replication definition named heartbeat_XXX, where XXX is the 3-digit database ID of the primary database.

  8. Right-click the replication definition name and choose Delete.

  9. In the Database Connection Properties dialog box, the function-string class should be set to the appropriate type (for example, rs_informix_function_class for an Informix database).

  10. Under the Advanced tab of the Database Connection Properties dialog box: