CREATE TABLE SYS.SYSREMOTEUSER ( 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 NUMERIC(20,0) NOT NULL, time_sent TIMESTAMP, log_sent NUMERIC(20,0) NOT NULL, confirm_sent NUMERIC(20,0) NOT NULL, send_count INTEGER NOT NULL, resend_count INTEGER NOT NULL, time_received TIMESTAMP, log_received NUMERIC(20,0) NOT NULL, confirm_received NUMERIC(20,0), receive_count INTEGER NOT NULL, rereceive_count INTEGER NOT NULL, PRIMARY KEY (user_id), FOREIGN KEY REFERENCES SYS.SYSUSERPERM )
Each row describes a user ID with REMOTE permissions (a subscriber), together with the status of SQL Remote messages sent to and from that user.
user_id ID of the user with REMOTE permissions.
consolidate Contains either an N to indicate a user granted REMOTE permissions, or a Y to indicate a user granted CONSOLIDATE permissions.
type_id Identifies which of the of the message systems supported by SQL Remote is to be 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.
log_send Messages are sent only to subscribers for whom log_send is greater than log_sent.
time_sent Time the most recent message was sent to this subscriber.
log_sent Log offset for the most recently sent operation.
confirm_sent Log offset for the most recently confirmed operation from this subscriber.
send_count Number of SQL Remote messages that have been sent.
resend_count Counter to ensure messages are applied only once at the subscriber database.
time_received Time the most recent message was received from this subscriber.
log_received 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 Number of messages received.
rereceive_count Counter to ensure messages are applied only once at the current database.
