Database Replication Detail (PD_RD)
- Organization of this page
Function
The Database Replication Detail (PD_RD) record indicates the replication information of a particular database. One record is created for each replication of the database.
This is a multi-instance record.
As indicated in the following table, the fields that can be acquired for this record differ depending on the database type.
Field |
Database type |
||
---|---|---|---|
Publisher |
Distributor |
Subscriber and others |
|
Articles |
Yes |
No |
No |
Publications |
Yes |
No |
No |
Subscriptions |
Yes |
No |
No |
None of the above |
Yes |
Yes |
Yes |
When a field cannot be acquired, the value is 0.
Default and changeable values
Item |
Default value |
Changeable |
---|---|---|
Collection Interval |
60 |
Y |
Collection Offset |
0 |
Y |
Log |
No |
Y |
LOGIF |
(Blank) |
Y |
Over 10 Sec Collection Time |
No |
N |
ODBC key fields
PD_RD_DBID
Lifetime
From the creation until deletion of a database
Record size
-
Fixed part: 681 bytes
-
Variable part: 273 bytes
Fields
View name (Manager name) |
Description |
Summary |
Format |
Delta |
Data source |
|
---|---|---|---|---|---|---|
Microsoft SQL Server version 2014 or earlier |
Microsoft SQL Server version 2016 or later |
|||||
Articles (ARTICLES) |
Number of articles published by the database |
-- |
ulong |
No |
Each publication database's sysarticle s table |
|
DB Name (DB_NAME) |
Database name |
-- |
string(257) |
No |
master..sysdatabases.name |
sys.databases.name |
DBID (DBID) |
Database ID |
-- |
ulong |
No |
master..sysdatabases.dbid |
sys.databases.database_id |
Publications (PUBLICATIONS) |
Number of publications posted by the publishing server |
-- |
ulong |
No |
Each publication database's syspublications table |
|
Record Time (RECORD_TIME) |
Interval end time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Record Type (INPUT_RECORD_TYPE) |
Record type (always RD) |
-- |
char(8) |
No |
Agent Collector |
|
Start Time (START_TIME) |
Interval start time (GMT format) |
-- |
time_t |
No |
Agent Collector |
|
Subscriptions (SUBSCRIPTIONS) |
Number of database subscriptions |
-- |
ulong |
No |
Each publication database's syssubscriptions table |