rs_threads

Replication Server uses the information in the rs_threads table to detect deadlocks and to perform transaction serialization between parallel DSI threads. An entry is updated in this table each time a transaction is started and more than one DSI thread is defined for a connection.

The rs_threads table is stored in each user database, not in the RSSD.

Column

Datatype

Description

id

int

The entry ID number. There are two entries for each parallel DSI thread.

seq

int

The sequence number of the last update made to this entry. The sequence number starts at 0 each time the connection is restarted.

pad1

char(255)

Filler to pad the row so that only one row fits on a database page.

pad2

char(255)

Filler to pad the row so that only one row fits on a database page.

pad3

char(255)

Filler to pad the row so that only one row fits on a database page.

pad4

char(255)

Filler to pad the row so that only one row fits on a database page.

Indexes

Unique clustered index on (id)