The SYSREMOTEUSER system table contains two columns that manage resending messages:
resend_count column A counter that keeps track of the number of times that the subscriber database has lost messages.
rereceive_count column A counter that keeps track of the number of times the Message Agent (dbremote) has determined that messages from a publisher user have been lost.
When messages are received in the proper order at a subscriber database:
The subscriber Message Agent (dbremote) applies the messages in the correct order and updates its SYSREMOTEUSER system table.
The subscriber Message Agent (dbremote) sends a confirmation message to the publisher.
When the publisher receives the confirmation, its Message Agent (dbremote) updates its SYSREMOTEUSER system table.
When messages are not received in the proper order:
The subscriber Message Agent (dbremote) sends a resend request and increments the rereceive_count value in its SYSREMOTEUSER system table.
When the publisher receives the resend request, it increments the resend_count value in its SYSREMOTEUSER system table for the subscriber.
In the publisher's SYSREMOTEUSER system table, the log_sent value is set to the value in the confirm_sent column. Resetting of the log_sent value causes operations to be resent.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |