The syscdrrepl table contains replicate information.
| Column | Type | Description |
|---|---|---|
| replname | lvarchar | Replicate name |
| replstate | char(50) | Replicate state
For possible values, refer to The STATE Column. |
| freqtype | char(1) |
Type of replication frequency: C = continuous I = interval T = time based M = day of month W = day of week |
| freqmin | smallint |
Minute (after the hour) refresh should occur Null if continuous |
| freqhour | smallint |
Hour refresh should occur Null if continuous |
| freqday | smallint | Day of week or month refresh should occur |
| scope | char(1) |
Replication scope: T = transaction R = row-by-row |
| invokerowspool | char(1) |
Y = row spooling is invoked N = no row spooling is invoked |
| invoke transpool | char(1) |
Y = transaction spooling is invoked N = no transaction spooling is invoked |
| primresolution | char(1) |
Type of primary conflict resolution: I = ignore T = time stamp S = SPL routine |
| secresolution | char(1) |
Type of secondary conflict resolution: S = SPL routine Null = not configured |
| storedprocname | lvarchar |
Name of SPL routine for secondary conflict resolution Null if not defined. |
| floattype | char(1) | C= converts floating point numbers to canonical format
I= converts floating point numbers to IEEE format N = does not convert floating point numbers (sends in native format) |
| istriggerfire | char(1) |
Y = triggers are invoked N = triggers are not invoked |
| isfullrow | char(1) |
Y = sends the full row and enables upserts N = sends only changed columns and disables upserts. |