User's Manual

Stable Queue tables

This section describes the database tables used by SQL Remote to deﬁne and

manage the stable queue information. The stable queue may be kept in the

same database as the SQL Remote database, or in a separate database.

The stable queue is used only by SQL Remote for Adaptive Server

Enterprise.

sr_queue_state table

Function A single row table that stores persistent global information about the state of

the stable queue.

Columns

Column Data type Description

version INT The stable queue version number

page_id INT Transaction log page_id of the

last entry scanned.

row_id INT Transaction log row_id of the last

entry scanned.

conﬁrm_offset NUMERIC(20,0) The minimum value of the conﬁr-

mation offsets received from all

remote users. This value is used

by the Message Agent to decide

which transactions can be deleted

from the stable queue.

commit_offset NUMERIC(20,0) The transaction log offset of the

most recent transaction completed

before the oldest incomplete trans-

action.

backup_offset NUMERIC(20,0) The transaction log offset of the

last dump database or dump

transaction command.

This information is used when the

Message Agent is run with the -u

option (replicate only backed up

transactions).

350