User's Manual

Chapter 16. System Objects for Adaptive Server Enterprise
Column Description
log_sent The log offset for the most recently sent operation.
confirm_sent The log offset for the most recently confirmed opera-
tion from this subscriber.
send_count How many SQL Remote messages have been sent.
resend_count Counter to ensure messages are applied only once at
the subscriber database.
time_received The time the most recent message was received from
this subscriber.
log_received The log offset in the subscriber’s database for the op-
eration most recently received at the current database.
confirm_received The log offset in the subscriber’s database for the most
recent operation for which a confirmation message has
been sent.
receive_count How many messages have been received.
rereceive_count Counter to ensure messages are applied only once at
the current database.
sr_subscriptions view
Function Each row lists information about a subscription.
Columns
Column Description
publication_name The name of the publication to which the user ID is
subscribed.
user_name The user ID that is subscribed to the publication.
subscribe_by For publications with a SUBSCRIBE BY expres-
sion, this column holds the matching value for this
subscription.
created The offset in the transaction log at which the subscrip-
tion was created.
started The offset in the transaction log at which the subscrip-
tion was started.
349