exceptions
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| exceptions [2016/05/31 11:36] – z0hpvk | exceptions [2025/03/08 22:24] (current) – external edit 127.0.0.1 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ===== Exception Handling Setup ===== | ===== Exception Handling Setup ===== | ||
| + | An Exception table will hold the details of all Conflicts that have occured within GoldenGate.\\ | ||
| + | This is neccessary because Conflict Detection and Resolution (CDR) will be in place. \\ | ||
| ==== Create Exception Table ==== | ==== Create Exception Table ==== | ||
| + | As the GGATE user create the EXCEPTIONS table ...\\ | ||
| < | < | ||
| EXCP_DATE | EXCP_DATE | ||
| Line 22: | Line 25: | ||
| ==== Macro ==== | ==== Macro ==== | ||
| + | Now create a macro that will convert GoldenGate environment variables into values for inserting.\\ | ||
| + | Save this macro as a file called exceptions.inc in $GGHOME/ | ||
| < | < | ||
| BEGIN | BEGIN | ||
| Line 45: | Line 50: | ||
| ==== Replicat Parameter File ==== | ==== Replicat Parameter File ==== | ||
| + | Within all 4 replicat parameter files add an " | ||
| + | Also after every table involved in CDR, place the " | ||
| < | < | ||
| .... | .... | ||
| MAP MAILONLINE.USER_TRANSFER_ITEM, | MAP MAILONLINE.USER_TRANSFER_ITEM, | ||
| EXCEPTIONSONLY, | EXCEPTIONSONLY, | ||
exceptions.1464694565.txt.gz · Last modified: (external edit)