rs_segments

Holds information about the allocation of each segment. Replication Server uses raw disk space to store message data.

Column

Datatype

Description

partition_id

int

Unique ID for the partition

q_number

int

Queue that this partition belongs to

q_type

int

Type of this queue

partition_offset

int

Offset of segment within partition

logical_seg

int

Offset of segment within queue

used_flag

int

Current status of segment:

  • 0 – inactive

  • 1 – active

  • n – save interval: n indicates the actual time (measured in seconds from a base date) when this segment can be deleted

version

int

Current version of the segment. The version number increases after each use.

flags

int

Set to 1 on the last segment of the DSI queue after switch active

Indexes

Unique clustered index on (partition_id, partition_offset)