subname
|
varchar(255)
|
Name of the subscription, trigger, or fragment.
|
subid
|
rs_id
|
ID for this subscription or fragment.
|
type
|
int
|
Object type:
-
0x00 – Subscription
-
0x01 – Range subscription
-
0x02 – Equality subscription
-
0x04 – Entire table
-
0x08 – Subscription for publication
-
0x40 – Database subscription
-
0x80 – Subscription for article
|
objid
|
rs_id
|
ID for the table replication definition, function replication
definition, article, or publication for this subscription. Or, ID for fragment, or
event for this trigger.
|
dbid
|
int
|
ID of the database this object belongs to.
|
pdbid
|
int
|
For system table replication and publication or article
subscriptions, the value of pdbid is the ID of
the primary database for the replication definition. Otherwise, value is 0.
|
requestdate
|
datetime
|
Date and time the last DDL request (create, drop, alter) was entered.
|
pownerid
|
rs_id
|
User ID at the primary Replication Server.
|
rownerid
|
rs_id
|
User ID at the replicate Replication Server.
|
status
|
int
|
-
Byte 1 holds the replicate database materialization
status: -
0x01 – Subscription is new
-
0x02 – Bulk subscription is activating or
atomic/non-atomic subscription has completed building materialization
queue
-
0x04 – Bulk/non-atomic subscription is active
-
0x08 – Bulk subscription is validating or non-atomic
has materialized
-
0x10 – Subscription is valid
-
0x40 – Subscription is valid at the standby
-
0x80 – Subscription removed at standby
-
Byte 2 holds the primary database dematerialization
status: -
0x100 – New
-
0x0200 – Activating
-
0x0400 – Active
-
0x0800 – Valid
-
Byte 3 holds the replicate database dematerialization
status: -
0x00010000 – Dematerializing at replicate
-
0x00020000 – Removing at replicate
-
0x00100000 – Dematerializing at primary
-
Byte 4 holds suspect or rematerialization status for a
publication subscription: -
0x02000000 – Suspect because of switch active
-
0x04000000 – Suspect on drop at standby
-
0x10000000 – The article subscriptions within this
publication subscription are materializing one at a time
-
0x20000000 – In the process of creating new article
subscriptions
-
0x40000000 – include truncate table
-
0x80000
– Subscription is being dropped
-
0x800000 – DSI has seen the VALID marker for the
subscription
-
0x1000 – Subscription has an error
|
recovering
|
int
|
Subscription recovery status: -
0x0 – Subscription is OK
-
0x1 – Recovering
-
0x2 – Pending
|
error_flag
|
int
|
If set, subscription is unrecoverable
|
materializing
|
int
|
If set, subscription is materializing
|
dematerializing
|
int
|
If set, subscription is dematerializing
|
primary_sre
|
int
|
If set, the subscription should be included in the subscription
resolution engine at the primary Replication Server
|
replicate_sre
|
int
|
If set, the subscription should be included in the subscription
resolution engine at the replicate Replication Server
|
released |
int |
Status of a table subscription with database materialization
|
materialization_try
|
int
|
Number of times this atomic materialization has been tried
|
method
|
int
|
Method for materializing the subscription:
Note:
For function replication definitions, this column is always
set to 0x02 (bulk)
|
generation
|
binary(4)
|
Generation number for the origin queue ID of the materialization
queue
|
parentid
|
rs_id
|
ID for the subscription for a publication if the current
subscription is for an article.
|
security
|
int
|
Security settings:
-
0x001 – unified_login is “required”
-
0x002 – mutual_auth is “required”
-
0x004 – msg_confidentiality is “required”
-
0x08 – msg_integrity is “required”
-
0x10 – msg_origin_check is “required”
-
0x20 – msg_reply_detection is “required”
-
0x40 – msg_sequence_check is “required”
|
mechanism
|
varchar(30)
|
Name
of the security mechanism
Default: empty string
|
tableowner
|
varchar(30)
|
Name
of the table owner. |
tablename
|
varchar(255)
|
Table
name. |
prsid
|
int
|
Primary SAP Replication Server ID
The prsid value in the rs_subscriptions system
table is always the prsid value in the
rs_dbsubsets table
|
num_selects
|
int
|
Number of select threads used with the direct load option.
|