|
Apply: Review Generated Replication Script |
Scroll |
Review the generated replication script. The Job, including the engine script includes two (2) Job steps; a parser step that compiles the script and a step that executes the Apply Engine.
The apply engine contains some (OUTMSG) trace displays that enable you to verify that the captured data is flowing properly. You can remove or comment these lines out before running high volume changes through the Engine.
Before submitting this job:
1.If you have a use case for replicating identical source to target tables, make sure that the target table(s) have been created.
2.Otherwise, comment out the REPLICATE statement to avoid trying to replicate. Keep the OUTMSG traces on for now.
; ------------------------------------------------- -- Main Section - Script Execution Entry Point ------------------------------------------------- PROCESS INTO TARGET_TABLES SELECT { -- OUTMSG(0,STRING(' TABLE=',CDC_TBNAME(CDCIN) -- ,' CHGOP=',CDCOP(CDCIN) -- ,' TIME=' ,CDCTSTMP(CDCIN)))
-- REPLICATE(TARGET_TABLES) } FROM CDCIN; /* |
Final Steps:
1.Submit this job
2.Make some changes on the Db2 source side
3.Browse the Engine SYSPRINT for the outmsgs
4.View the Db2 Capture/Publisher progress via option 3.
