rs_databases

dsname

varchar(30)

Data server name

dbname

varchar(30)

Database name

dbid

int

Unique identifier for the database

dist_status

tinyint

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

src_status

tinyint

Status of the source:

• 0x1 – valid

• 0x2 – suspended

• 0x4 – suspended by a standby-related action

• 0x10 – DIST thread is suspended

attributes

tinyint

One of the following 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 the following values:

• P – physical database

• L – logical database connection

ptype

char(1)

The type of database in a warm standby application. One of the following 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