Forum Stats

  • 3,769,837 Users
  • 2,253,027 Discussions
  • 7,875,220 Comments

Discussions

Local extract with replicat and userexit library

user9130018
user9130018 Member Posts: 77 Blue Ribbon

Hello


I would like to use GoldenGate to process transaction logs and then launch CUSEREXIT function to send them using third party protocol. First I used my custom library with 'extract' process but I need to be able to use multiple threads and reprocess previously stored transaction logs. So I removed my CUSEREXIT call from extract and created simple replicat process:


-- ADD REPLICAT repl exttrail ./dirdat/xx coordinated

REPLICAT repl

TARGETDB syscdcv1 USERIDALIAS gguser

MAP db.user.table TARGET db.user.target THREADRANGE(1-10);

CUSEREXIT mylibrary.so CUSEREXIT, INCLUDEUPDATEBEFORES


It works but at the end of processing it updates row (because of MAP/TARGET line). I don't need this update, it actually goes into transaction logs, is taken by 'extract' process and goes into 'replicat' again. How can I configure 'replicat' to just use my USEREXIT and finish processing?


My environment/configuration is: Golden Gate 12.2.0.1.1 with Informix database on Aix


Best Regards

Best Answer

Answers