Goldengate merge application process

When the goldengate application process is split itself, it is best to split it according to the business, otherwise it may cause the application to read data into business confusion. Now merge multiple application processes into one application process. The following steps are for reference only:

Merge replicate application processes:

1. Original process:

GGSCI (data) 142 > info all

Program Status Group Lag at Chkpt Time Since Chkpt

MANAGER RUNNING

REPLICAT RUNNING REP1 00:00:00 00:00:03

REPLICAT RUNNING REP2 00:00:00 00:00:02

REPLICAT RUNNING REP3 00:00:00 00:00:02

REPLICAT RUNNING REP4 00:00:00 00:00:01

two。 Now you need to merge the REP process into one process and add a new application process:

Add replicat rep,exttrail. / dirdat/aa, checkpointtable goldengate.checkpoint

Add all the tables that need to be merged to the new process:

Edit params rep

3. Stop the pump process:

Stop p_data

4. Observe the seqno and rba of the application process to make it consistent:

GGSCI (data) 156 > info rep1

REPLICAT R_WMSJQ Last Started 2018-11-21 11:18 Status RUNNING

Checkpoint Lag 00:00:00 (updated 00:00:08 ago)

Process ID 45169

Log Read Checkpoint File. / dirdat/bb000012890

2018-11-21 11 purl 32 purl 30.999468 RBA 340450388

5. Stop the application process:

Stop rep1

Stop rep2

Stop rep3

Stop rep4

6. Modify the seqno and rba of the new application process:

Alter rep, extseqno 12890, extrba 340450388

Start rep

7. Delete the previous sub-process:

Dblogin userid goldengate,password goldengate

Stop rep1

Delete replicat rep1