The syscdrrepl Table

The syscdrrepl table contains replicate information.

Column Type Description
replname lvarchar Replicate name.
replstate char(50) Replicate state.

For possible values, refer to cdr list server.
freqtype char(1) Type of replication frequency:
  • C = continuous
  • I = interval
  • T = time based
  • M = day of month
  • W = day of week
freqmin smallint The time for replication by minute:
  • Minutes after the hour that replication should occur.
  • Null if continuous.
freqhour smallint The time for replication by hour:
  • Hour that replication should occur.
  • Null if continuous.
freqday smallint Day of week or month replication should occur.
scope char(1) Replication scope:
  • T = transaction
  • R = row-by-row
invokerowspool char(1) Whether Row Information Spooling is enabled:
  • Y = row spooling is enabled.
  • N = row spooling is disabled.
invoke transpool char(1) Whether Aborted Transaction Spooling is enabled:
  • Y = transaction spooling is enabled.
  • N = transaction spooling is disabled.
primresolution char(1) Type of primary conflict resolution:
  • A = always apply
  • D = delete wins
  • I = ignore
  • T = timestamp.
  • S = SPL routine
secresolution char(1) Type of secondary conflict resolution:
  • S = SPL routine
  • Null = not configured
storedprocname lvarchar SPL routine:
  • Name of SPL routine for secondary conflict resolution.
  • Null if not defined.
floattype char(1) Type of floating point number conversion:
  • 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) Whether triggers are enabled:
  • Y = triggers are enabled.
  • N = triggers are disabled.
isfullrow char(1) Whether to replicate full rows or only the changed columns:
  • Y = sends the full row and enables upserts.
  • N = sends only changed columns and disables upserts.
isgrid char(1) Whether the replicate belongs to a grid replicate set:
  • Y = the replicate belongs to a grid replicate set.
  • N = the replicate does not belong to a grid replicate set.