|
Each row in the SYSREMOTEUSER system view describes a user ID with REMOTE permissions (a subscriber), together with the status of SQL Remote messages that were sent to and from that user. The underlying system table for this view is ISYSREMOTEUSER.
| Column name | Column type | Column constraint |
|---|---|---|
| user_id | UNSIGNED INT | NOT NULL |
| consolidate | CHAR(1) | NOT NULL |
| type_id | SMALLINT | NOT NULL |
| address | LONG VARCHAR | NOT NULL |
| frequency | CHAR(1) | NOT NULL |
| send_time | TIME | |
| log_send | UNSIGNED BIGINT | NOT NULL |
| time_sent | TIMESTAMP | |
| log_sent | UNSIGNED BIGINT | NOT NULL |
| confirm_sent | UNSIGNED BIGINT | NOT NULL |
| send_count | INTEGER | NOT NULL |
| resend_count | INTEGER | NOT NULL |
| time_received | TIMESTAMP | |
| log_received | UNSIGNED BIGINT | NOT NULL |
| confirm_received | UNSIGNED BIGINT | |
| receive_count | INTEGER | NOT NULL |
| rereceive_count | INTEGER | NOT NULL |
user_id The user number of the user with REMOTE permissions.
consolidate (Y/N) Indicates whether the user was granted CONSOLIDATE permissions (Y) or REMOTE permissions (N).
type_id Identifies which of the message systems supported by SQL Remote is used to send messages to the 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 sent.
send_time The next time messages are to be sent to this user.
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 that messages are applied only once at the subscriber database.
time_received The time when the most recent message was received from this subscriber.
log_received The log offset in the subscriber's database for the operation that was 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 that messages are applied only once at the current database.
PRIMARY KEY (user_id)
FOREIGN KEY (user_id) references SYS.ISYSUSER (user_id)
FOREIGN KEY (type_id) references SYS.ISYSREMOTETYPE (type_id)