rs_databases

Stores database names known at a Replication Server site.

Column

Datatype

Description

dsname

varchar(30)

Data server name

dbname

varchar(30)

Database name

dbid

int

Unique identifier for the database

conn_id

int

Unique identifier for a database connection. For:
  • Default connections – connid is equal to dbid
  • Alternate connections – connid is not equal to dbid

dist_status

cs_int

Status of the connection. Can be:

  • 0x1 – valid

  • 0x2 – suspended

  • 0x4 – suspended by a standby-related action

  • 0x8 – waiting for a marker

  • 0x10 – will issue dbcc ('ltm', 'ignore')

  • 0x20 – waiting for dump marker to initialize a standby database

  • 0x40 – switching related duplicate detection when ltype is equal to ‘P’

  • 0x40 – allow switching when ltype is equal to ‘L’

  • 0x80 – temporarily not doing any grouping

  • 0x100 – waiting for a resync marker

src_status

cs_int

Status of the source:

  • 0x1 – valid

  • 0x2 – suspended

  • 0x4 – suspended by a standby-related action

  • 0x10 – DIST thread is suspended

attributes

tinyint

One of these values:

  • 1 – distribution

  • 2 – source

errorclassid

rs_id

Error class for this database

funcclassid

rs_id

Function-string class for this database

prsid

int

ID of Replication Server managing this database

rowtype

tinyint

Indicates the row type:

  • 1 – row is replicated

  • 0 – row not replicated

sorto_status

tinyint

Indicates if the sort order check has been completed. One of the following values:

  • 0 – not checked

  • 1 – checked

ltype

char(1)

The type of database this row represents. One of these:

  • P – physical database

  • L – logical database connection

ptype

char(1)

The type of database in a warm standby application. One of these values:

  • A – the active database

  • S – the standby database

  • L – the logical database connection

ldbid

int

The dbid for the logical connection the database is associated with. If there is no logical connection, ldbid is the same as dbid.

enable_seq

int

The sequence number used during an active database switch or the creation of a standby database.

rs_errorclassid

rs_id

Replication Server error class for this database

Indexes

  • Unique clustered index on (dsname, dbname, ltype)

  • Unique index on (ptype, ldbid)

  • Unique index on (dbid, ltype)

  • Unique index on (dsname, dbname, ptype)