User's Manual

Column Data type Description
frequency CHAR(1) How frequently SQL Remote mes-
sages are to be sent.
send_time DATETIME The next time messages are to be sent
to this user.
log_send NU-
MERIC(20, 0)
Messages are sent only to subscribers
for whom log_send is greater than
log_sent.
time_sent DATETIME The time the most recent message
was sent to this subscriber.
log_sent NU-
MERIC(20, 0)
The log offset for the most recently
sent operation.
confirm_sent NU-
MERIC(20, 0)
The log offset for the most recently
confirmed operation from this sub-
scriber.
send_count INT How many SQL Remote messages
have been sent.
resend_count INT Counter to ensure messages are ap-
plied only once at the subscriber
database.
time_received DATETIME The time the most recent message
was received from this subscriber.
log_received NU-
MERIC(20, 0)
The log offset in the subscriber’s
database for the operation most
recently received at the current
database.
confirm_-
received
NU-
MERIC(20, 0)
The log offset in the subscriber’s
database for the most recent op-
eration for which a confirmation
message has been sent.
receive_count INT How many messages have been
received from this subscriber.
rereceive_count INT Counter to ensure messages are
applied only once at the current
database.
filler1 CHAR(255) Reserved
344