rs_recovery

Logs actions that must be performed by Replication Server upon recovery, if there is a failure.

Column

Datatype

Description

action

int

Represents the recoverable actions:

  • 1 – create_route

  • 2 – drop_route

  • 3 – standalone mode

  • 4 – rebuild queues

  • 5 – log recovery

  • 6 – restart LTM at the top of the log

  • 7 – create standby

  • 8 – switch active

  • 9 – strict save interval for DSI or materialization queue

  • 10 – quit DSI secondary duplicate detection after switch active

  • 11 – drop standby

  • 12 – alter distributor locater

  • 13 – delete segments with replication definitions

  • 14 – drop pending replication definitions

  • 15 – drop pending table or function replication definition with reference counter

  • 16 – create schema replication definition (for auto-generating schema replication definition)

id

rs_id

Each row is assigned a unique ID.

seqnum

int

For actions with multiple rows, this column stores the sequence number of each row.

state

int

Contains the current state for recoverable actions that move through a finite number of states.

text

binary(255)

Data required to complete the action.

textlen

int

Length of the text data.

Indexes

Unique index on (id)