SQL Remote User's Guide
System Objects for Adaptive Server Enterprise
SQL Remote system views
Lists information about remote users and their status.
Column | Description |
---|---|
user_name | The user ID of the user with REMOTE permissions. |
consolidate | The column contains either an N to indicate a user granted REMOTE permissions, or a Y to indicate a user granted CONSOLIDATE permissions. |
type_name | The name of the message system used to send messages to this user. |
address | The address to which SQL Remote messages are to be sent. The address must be appropriate for the address_type. |
frequency | How frequently SQL Remote messages are to be sent. |
send_time | The next time messages are to be sent to this user. |
next_send | The next time messages are to be sent to this user, in a more comprehensible format. |
log_send | Messages are sent only to subscribers for whom log_send is greater than log_sent. |
time_sent | The time the most recent message was sent to this subscriber. |
log_sent | The log offset for the most recently sent operation. |
confirm_sent | The log offset for the most recently confirmed operation 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 operation 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. |