User's Manual

Chapter 16. System Objects for Adaptive Server Enterprise

Column Data type Description

marker DATETIME The most recent incoming mes-

sage that has been scanned into

the stable queue. When a mes-

sage is applied to the Adaptive

Server Enterprise server, it sets

the time_received column in sr_-

remoteuser. When the transaction

log is scanned and the transactions

from that message are scanned

into the stable queue, it sets the

time_received column of sr_-

queue_state.

The purpose of the column is co-

ordination between one Message

Agent that is scanning the transac-

tion log continuously and another

Message Agent that is receiving

messages and sending messages

in batch mode. When in batch

mode, the Message Agent receives

messages, waits for those mes-

sages to be scanned into the stable

queue, and then sends messages.

The waiting is done through the

database by looking at the time_-

received column of sr_queue_-

state.

conﬁrmed_id NUMERIC(20,0) The sending thread deletes rows

with conﬁrmed_id less than

this value from sr_conﬁrmed_-

transaction.

sr_transaction table

Function This table has one row for each transaction in the stable queue.

Columns

351