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
-
0x400
– waiting for a user database to upgrade
|
src_status
|
cs_int
|
Status of the source:
|
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:
|
ptype
|
char(1)
|
The type of database in
a warm standby application. One of these values:
|
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
|