Create or modify a replication request - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

Usage

Creates or modifies a request for change-based replication.

Syntax
  CREATE REPLICATION REQUEST name AT [DISTRIBUTION] distname
Or   ALTER REPLICATION REQUEST name AT [DISTRIBUTION] distname TO
  [PATHGROUP name]
  [SCHEDULE START {NOW | ON month/day/year [AT hours:minutes:seconds]}
  [DURATION n {HOUR[S]|MINUTE[S]|SECOND[S]|DAY[S]|MONTH[S]}]
  [STOP ON month/day/year [AT hours:minutes:seconds] ]
  [EVERY n {HOUR[S]|MINUTE[S]|SECOND[S]|DAY[S]|MONTH[S]}]
      ]
      [CONNECT TO [SERVER] server-name USING username] ...
      [ON_ERROR {CONTINUE | IGNORE | SHUTDOWN }]
      [PROTECTED_RESOLUTION {AUTOMATIC | MANUAL}]
      [UNPROTECTED_RESOLUTION FOR { {INSERT | UPDATE     
         | DELETE} {NONE | TARGET_CORRECT | SOURCE_CORRECT}, ... }]
   s1
            JOB_SEQUENCER s2 [NOT] ACTIVE] …
      [FILES_ON_START {DELETE | RETAIN}]
      [DESCRIPTION ‘descriptive text’]
      ;

Parameters

Parameter

Description

CREATE

Establish a new replication request in a previously defined distribution.

ALTER

Modify a previously established replication request. Specify the distribution for this request.

PATHGROUP

Specify the path group (if any) to use for this request.

SCHEDULE...

Set replication request times:

  • Start

  • Stop

  • Duration

  • Pattern of repetition every n seconds, minutes, hours, days, or months.

CONNECT

Specify a username for a server connection.

ON_ERROR

Specify error handling: continue, ignore, or shutdown.

PROTECTED_RESOLUTION

Specify automatic or manual full collision resolution by shadow table.

UNPROTECTED_RESOLUTION

Specify unprotected collision resolution:

  • insert, update, or delete

  • none, target_correct, or source_correct

FILES_ON_START

The FILES_ON_START clause indicates whether existing files at a FileSystem target server should be deleted or retained when the request starts.

Description

User-defined text.

Example
-- RSL REQUEST flatfile definition
 
CREATE REPLICATION REQUEST flatfile AT DISTRIBUTION FLATFILE
   ON_ERROR SHUTDOWN
   INTEGRITY STANDARD
   PROTECTED_RESOLUTION AUTOMATIC
   UNPROTECTED_RESOLUTION FOR INSERT NONE, UPDATE NONE, DELETE NONE
   FILES_ON_START RETAIN
   "qatest.dbo.JOR_DATATYPES_1"
          CATEGORY JC_M   SSS_mikey JOB_SEQUENCER JS_MSSS_mikey ACTIVE"qatest.dbo.JOR_DATATYPES_2"
         CATEGORY JC_MSSS_matty JOB_SEQUENCER JS_MSSS_matty ACTIVE
   MODIFY LEVEL NONE
;