Data Server Interface Problems

The Data Server Interface (DSI) applies transactions from a Replication Server stable queue to a data server, which can be an Adaptive Server or another data server with an interface to the Replication Server. Before a transaction is applied, Replication Server uses function strings to convert the commands to the format specified for the data server. If the data server does not receive updates, the DSI may be suspended or down.

A down or suspended DSI can be caused by:

A suspended DSI always results in a message being sent to the Replication Server error log. Analyze the message to solve the problem. After correcting the error, restart the DSI.

If the DSI is active, unique transactions might be incorrectly resolved as duplicates, or the transactions might be failing on the data server. Manually resolve the data inconsistency between the primary and replicate databases or reapply the transactions.

To investigate the DSI, find out which databases are controlled by the Replication Server and check the DSI status for all database connections on a Replication Server. Use the select, admin who, and admin who, dsi commands to extract the information you need and to determine the exact cause of the problem.

Note: These problems also apply to parallel DSI threads. For more information specific about parallel DSI threads, see Replication Server Administration Guide Volume 2.
Related concepts
Common Error Messages
Troubleshooting Overview