1999 幎以æ¥ãåœéè¡ã¯ããã¯ãªãã£ã¹ã«ãµãŒãã¹ãæäŸããããã«ãéèã»ã¯ã¿ãŒãå«ãäžçäžã§åºã䜿çšãããŠãã Progress OpenEdge ãã©ãããã©ãŒã äžã®çµ±åãã³ãã³ã° ã·ã¹ãã BISKVIT ã䜿çšããŠããŸãã ãã® DBMS ã®ããã©ãŒãã³ã¹ã«ããã1,5 ã€ã®ããŒã¿ããŒã¹ (DB) 㧠22,2 ç§ãããæ倧 XNUMX äžä»¶ä»¥äžã®ã¬ã³ãŒããèªã¿åãããšãã§ããŸãã åœç€Ÿã® Progress OpenEdge ã¯ãçŽ XNUMX äžä»¶ã®å人é éãšã¢ã¯ãã£ãåå (èªåè»ããŒã³ãäœå® ããŒã³) ã®çŽ XNUMX äžä»¶ã®å¥çŽã«ãµãŒãã¹ãæäŸããŠãããèŠå¶åœå± (äžå€®éè¡) ããã³ SWIFT ãšã®ãã¹ãŠã®æ±ºæžãæ åœããŠããŸãã
Progress OpenEdge ã䜿çšããããšã§ãããã Oracle DBMS ãšé£æºãããå¿
èŠæ§ã«çŽé¢ããŸããã åœåãPro2 CDC (Progress DBMS ãã Oracle DBMS ã«çŽæ¥ãªã³ã©ã€ã³ã§ããŒã¿ãéä¿¡ã§ããããã«ãã Progress 補å) ãã€ã³ã¹ããŒã«ããŠæ§æãããŸã§ã¯ããã®ãã³ãã«ãã€ã³ãã©ã¹ãã©ã¯ãã£ã®ããã«ããã¯ã§ããã ãã®èšäºã§ã¯ãOpenEdge ãš Oracle ã®éã§å¹æçã«åéãäœãæ¹æ³ããèœãšãç©Žãå«ããŠè©³ãã説æããŸãã
çµç·¯: ãã¡ã€ã«å ±æçµç±ã§ QCD ã«ããŒã¿ãã¢ããããŒã
ãŸããã€ã³ãã©ã¹ãã©ã¯ãã£ã«é¢ããããã€ãã®äºå®ã«ã€ããŠèª¬æããŸãã ããŒã¿ããŒã¹ã®ã¢ã¯ãã£ã ãŠãŒã¶ãŒæ°ã¯çŽ 15 人ã§ãã ã¬ããªã«ãšã¹ã¿ã³ãã€ãå«ããã¹ãŠã®æ¬çšŒåããŒã¿ããŒã¹ã®ããªã¥ãŒã 㯠600 TB ã§ãæ倧ã®ããŒã¿ããŒã¹ã¯ 16,5 TB ã§ãã åæã«ãããŒã¿ããŒã¹ã¯åžžã«è£å ãããŠãããæšå¹Žã ãã§çŽ 120 TB ã®çç£çãªããŒã¿ãè¿œå ãããŸããã ãã®ã·ã¹ãã ã¯ãx150 ãã©ãããã©ãŒã äžã® 86 å°ã®ããã³ã ãµãŒããŒã«ãã£ãŠçšŒåããŸãã ããŒã¿ããŒã¹ã¯ 21 å°ã® IBM ãã©ãããã©ãŒã ãµãŒããŒã§ãã¹ããããŠããŸãã
ããã³ããšã³ã ã·ã¹ãã ãããŸããŸãªã³ã¢ ãã³ãã³ã° ã·ã¹ãã ããã³ãã³ã° ãµãŒãã¹ã¯ãSonic ESB ãã¹ãä»ã㊠OpenEdge Progress (BISCUIT IBS) ãšçµ±åãããŠããŸãã QCD ãžã®ããŒã¿ã®ã¢ããããŒãã¯ããã¡ã€ã«äº€æãéããŠè¡ãããŸãã ããæç¹ãŸã§ããã®ãããªãœãªã¥ãŒã·ã§ã³ã«ã¯ãäŒæ¥ããŒã¿ ãŠã§ã¢ããŠã¹ (CDW) ãžã®æ
å ±ã¢ããããŒãã®ããã©ãŒãã³ã¹ãäœãããšãšãä»ã®ã·ã¹ãã ãšã®ããŒã¿èª¿æŽ (調æŽ) ã®å®è¡ã«æéãããããšãã XNUMX ã€ã®å€§ããªåé¡ãåæã«ãããŸããã
ããã§ããããã®ããã»ã¹ãé«éåã§ããããŒã«ãæ¢ãå§ããŸããã äž¡æ¹ã®åé¡ã«å¯Ÿãã解決çã¯ãæ°ãã Progress OpenEdge 補åã§ãã Pro2 CDC (Change Data Capture) ã§ããã ããã§ã¯ãå§ããŸãããã
OpenEdge ãš Pro2Oracle ã®ã€ã³ã¹ããŒã«ã®é²è¡ç¶æ³
管çè
ã® Windows ã³ã³ãã¥ãŒã¿ã§ Pro2 Oracle ãå®è¡ããã«ã¯ãProgress OpenEdge Developer Kit Classroom Edition ãã€ã³ã¹ããŒã«ããã ãã§ååã§ãã
DLC: C:ProgressOpenEdge
WRK: C:OpenEdgeWRK
ETL ããã»ã¹ã«ã¯ãProgress OpenEdge ã©ã€ã»ã³ã¹ ããŒãžã§ã³ 11.7 以éãã€ãŸã OE DataServer for Oracle ããã³ 4GL Development System ãå¿ èŠã§ãã ãããã®ã©ã€ã»ã³ã¹ã¯ Pro2 ã«å«ãŸããŠããŸãã ãªã¢ãŒã Oracle ããŒã¿ããŒã¹ã䜿çšã㊠DataServer for Oracle ãå®å šã«æäœããã«ã¯ãå®å šãª Oracle ã¯ã©ã€ã¢ã³ããã€ã³ã¹ããŒã«ãããŸãã
Oracle ãµãŒããŒã§ã¯ãOracle Database 12+ ãã€ã³ã¹ããŒã«ãã空ã®ããŒã¿ããŒã¹ãäœæãããŠãŒã¶ãŒ (ããã§ã¯ãŠãŒã¶ãŒãšåŒã³ãŸã) ãè¿œå ããå¿ èŠããããŸãã CDC).
Pro2Oracle ãã€ã³ã¹ããŒã«ããã«ã¯ãããŠã³ããŒã ã»ã³ã¿ãŒããææ°ã®ãã£ã¹ããªãã¥ãŒã·ã§ã³ãããŠã³ããŒãããŸãã
CDC ã¬ããªã±ãŒã·ã§ã³ ããŒã¿ããŒã¹ã®äœæ
ã¬ããªã±ãŒã·ã§ã³ããŒã¿ããŒã¹ CDC (ã¬ããªã«) Pro2 ã¯ãã¬ããªã±ãŒã·ã§ã³ ããããã¬ããªã±ãŒããããããŒã¿ããŒã¹ã®ååãããã³ãã®ããŒãã«ãªã©ã®æ§ææ å ±ãä¿åããããã«äœ¿çšãããŸãã ãŸãããœãŒã¹ ããŒã¿ããŒã¹ã®ããŒãã«è¡ãå€æŽããããšããäºå®ã«é¢ããã¡ã¢ã§æ§æãããã¬ããªã±ãŒã·ã§ã³ ãã¥ãŒãå«ãŸããŠããŸãã ã¬ããªã±ãŒã·ã§ã³ ãã¥ãŒã®ããŒã¿ã¯ããœãŒã¹ ããŒã¿ããŒã¹ãã Oracle ã«ã³ããŒããå¿ èŠãããè¡ãèå¥ããããã« ETL ããã»ã¹ã«ãã£ãŠäœ¿çšãããŸãã
å¥ã® cdc ããŒã¿ããŒã¹ãäœæããŠããŸãã
ããŒã¿ããŒã¹ã®äœææé
- ããŒã¿ããŒã¹ ãµãŒããŒäžã«ãcdc ããŒã¿ããŒã¹çšã®ãã£ã¬ã¯ããªãäœæããŸããããšãã°ã /ããŒã¿ããŒã¹/cdc/.
- cdc ããŒã¿ããŒã¹ã®ãããŒãäœæããŸãã ããã³ã㌠$DLC/空㮠CDC
- 倧ããªãã¡ã€ã«ã®ãµããŒããæå¹ã«ããŸãã proutil cdc -C EnableLargeFiles
- cdcããŒã¿ããŒã¹ãèµ·åããã¹ã¯ãªãããçšæããŸãã éå§ãã©ã¡ãŒã¿ã¯ãã¬ããªã±ãŒããããããŒã¿ããŒã¹ã®éå§ãã©ã¡ãŒã¿ãšåæ§ã§ããå¿ èŠããããŸãã
- cdc ããŒã¿ããŒã¹ãèµ·åããŸãã
- cdc ããŒã¿ããŒã¹ã«æ¥ç¶ãããã¡ã€ã«ãã Pro2 ã¹ããŒããããŒãããŸãã cdc.dfãPro2ã«å«ãŸããŠããŸãã
- cdc ããŒã¿ããŒã¹ã«æ¬¡ã®ãŠãŒã¶ãŒãäœæããŸãã
pro2adm â Pro2 管çããã«ããã®æ¥ç¶çšã
pro2etl â ETL ããã»ã¹ãæ¥ç¶ãããã (ReplBatch)ã
pro2cdc â CDC ããã»ã¹ (CDCBatch) ãæ¥ç¶ããããã
OpenEdge å€æŽããŒã¿ ãã£ããã£ã®ã¢ã¯ãã£ãå
次ã«ãCDC ã¡ã«ããºã èªäœãæå¹ã«ããŠãããŒã¿ãè¿œå ã®ãã¯ãããžãŒé åã«è€è£œãããããã«ããŸãããã Progress OpenEdge ãœãŒã¹ ããŒã¿ããŒã¹ããšã«ããœãŒã¹ ããŒã¿ãè€è£œãããåå¥ã®ã¹ãã¬ãŒãžé åãè¿œå ããã³ãã³ãã䜿çšããŠã¡ã«ããºã èªäœãã¢ã¯ãã£ãã«ããå¿ èŠããããŸãã ãã«ãŒãŠ.
ãã¹ã±ããããŒã¿ããŒã¹ã®æé äŸ
- ã«ã¿ãã°ããã®ã³ã㌠C:ãã2db Ñайл cdcadd.st bisquit ãœãŒã¹ ããŒã¿ããŒã¹ ãã£ã¬ã¯ããªã«ã³ããŒããŸãã
- ã§èª¬æããŸã cdcadd.st é åã®åºå®ãµã€ãºã®ãšã¯ã¹ãã³ã ãReplCDCãšãªã¢ã О ãReplCDCArea_IDXãã æ°ããã¹ãã¬ãŒãžé åããªã³ã©ã€ã³ã§è¿œå ã§ããŸãã prostrct ã¢ããªã³ã©ã€ã³ ãã¹ã±ãã cdcadd.st
- OpenEdge CDC ãã¢ã¯ãã£ãåããŸãã
proutil bisquit -C Enablecdc area "ReplCDCArea" Indexarea "ReplCDCArea_IDX" - å®è¡äžã®ããã»ã¹ãèå¥ããã«ã¯ããœãŒã¹ ããŒã¿ããŒã¹ã«æ¬¡ã®ãŠãŒã¶ãŒãäœæããå¿
èŠããããŸãã
ïœïŒ pro2adm â Pro2 管çããã«ããã®æ¥ç¶çšã
b. pro2etl â ETL ããã»ã¹ (ReplBatch) ãæ¥ç¶ããããã
c. pro2cdc â CDC ããã»ã¹ (CDCBatch) ãæ¥ç¶ããããã
DataServer for Oracle ã®ã¹ããŒã ãã«ããŒã®äœæ
次ã«ãProgress DBMS ããã®ããŒã¿ã Oracle DBMS ã«ã¬ããªã±ãŒãããããµãŒããŒäžã«ã¹ããŒã ãã«ã㌠ããŒã¿ããŒã¹ãäœæããå¿ èŠããããŸãã DataServer Schema Holder ã¯ããŠãŒã¶ãŒãã¢ããªã±ãŒã·ã§ã³ ããŒã¿ã®ãªã空㮠Progress OpenEdge ããŒã¿ããŒã¹ã§ããœãŒã¹ ããŒãã«ãšå€éš Oracle ããŒãã«éã®å¯Ÿå¿ããããå«ãŸããŠããŸãã
Pro2 çšã® Progress OpenEdge DataServer for Oracle ã®ã¹ããŒã ãã«ã㌠ããŒã¿ããŒã¹ã¯ãETL ããã»ã¹ ãµãŒããŒäžã«é 眮ããå¿ èŠãããããã©ã³ãããšã«åå¥ã«äœæãããŸãã
ã¹ããŒããã«ããŒã®äœææ¹æ³
- Pro2 ãã£ã¹ããªãã¥ãŒã·ã§ã³ããã£ã¬ã¯ããªã«è§£åããŸãã /ãã2
- ãã£ã¬ã¯ããªãäœæããŠç§»åããŸã /pro2/dbsh
- ã³ãã³ãã䜿çšããŠã¹ããŒããã«ããŒããŒã¿ããŒã¹ãäœæããŸãã $DLC/空ã®ãã¹ã±ãããã³ããŒ
- å€æãå®è¡ãã ãã¹ã±ãã å¿ èŠãªãšã³ã³ãŒãã£ã³ã°ã«å€æããŸããããšãã°ãOracle ããŒã¿ããŒã¹ã« UTF-8 ãšã³ã³ãŒãã£ã³ã°ãããå Žåã¯ãUTF-8 ã«å€æããŸãã proutil bisquitsh -C convchar Convert UTF-8
- 空ã®ããŒã¿ããŒã¹ãäœæããåŸ ãã¹ã±ãã ã·ã³ã°ã«ãŠãŒã¶ãŒ ã¢ãŒãã§æ¥ç¶ããŸãã ãããã¹ã±ãã
- ããŒã¿ãã£ã¯ã·ã§ããªã«è¡ããŸããã: [ããŒã«] -> [ããŒã¿ ãã£ã¯ã·ã§ããª] -> [DataServer] -> [ORACLE ãŠãŒãã£ãªãã£] -> [DataServer ã¹ããŒãã®äœæ]
- ã¹ããŒããã«ããŒã®èµ·å
- Oracle DataServer ãããŒã«ãŒã®ã»ããã¢ãã:
ïœïŒ 管çãµãŒããŒãèµ·åããŸãã
proadsv -start
b. Oracle DataServer ãããŒã«ãŒã®éå§
oraman -name orabroker1 -start
管çããã«ãšã¬ããªã±ãŒã·ã§ã³ã¹ããŒã ã®ã»ããã¢ãã
Pro2 管çããã«ã䜿çšããŠãã¬ããªã±ãŒã·ã§ã³ ã¹ããŒã ã®ã»ããã¢ãããETL ããã»ã¹ (ããã»ããµ ã©ã€ãã©ãª)ããã©ã€ããªåæããã°ã©ã (ãã«ã¯ ã³ã㌠ããã»ããµ)ãã¬ããªã±ãŒã·ã§ã³ ããªã¬ãŒãOpenEdge CDC ããªã·ãŒã®çæãªã©ãPro2 ãã©ã¡ãŒã¿ãèšå®ããŸãã ETL ããã³ CDC ããã»ã¹ãç£èŠããã³ç®¡çããããã®äž»èŠãªããŒã«ããããŸãã ãŸãæåã«ãã©ã¡ãŒã¿ãã¡ã€ã«ãèšå®ããŸãã
ãã©ã¡ãŒã¿ãã¡ã€ã«ã®èšå®æ¹æ³
- ã«ã¿ãã°ãžè¡ã C:Pro2bpreplScripts
- ç·šéããããã«ãã¡ã€ã«ãéããŸã replProc.pf
- æ¥ç¶ãã©ã¡ãŒã¿ã cdc ã¬ããªã±ãŒã·ã§ã³ ããŒã¿ããŒã¹ã«è¿œå ããŸãã
# ã¬ããªã±ãŒã·ã§ã³ããŒã¿ããŒã¹
-db cdc -ld repl -H <ã¡ã€ã³ ããŒã¿ããŒã¹ ãã¹ãå> -S <ããŒã¿ããŒã¹ ãããŒã«ãŒ ããŒã cdc>
-U pro2admin -P <ãã¹ã¯ãŒã> - ã«è¿œå replProc.pf ãœãŒã¹ ããŒã¿ããŒã¹ããã³ã¹ããŒã ãã«ããŒãžã®æ¥ç¶ãã©ã¡ãŒã¿ããã©ã¡ãŒã¿ ãã¡ã€ã«ã®åœ¢åŒã§ä¿åããŸãã ãã©ã¡ãŒã¿ ãã¡ã€ã«ã®ååã¯ãæ¥ç¶ãããŠãããœãŒã¹ ããŒã¿ããŒã¹ã®ååãšäžèŽããå¿
èŠããããŸãã
# ã¬ããªã±ãŒãããããã¹ãŠã®ãœãŒã¹ã«æ¥ç¶ããŸã BISQUIT
-pf bpreplscriptsbisquit.pf - ã«è¿œå replProc.pf ã¹ããŒããã«ããŒã«æ¥ç¶ããããã®ãã©ã¡ãŒã¿ã
#Target Pro DB ã¹ããŒã ãã«ããŒ
-db ãã¹ããã -ld ãã¹ããã
-H <ETL ããã»ã¹ã®ãã¹ãå>
-S <biskuitsh ãããŒã«ãŒ ããŒã>
-db ãã¹ãããSQL
-ld ãã¹ã±ããSQL
-dt ãªã©ã¯ã«
-S 5162 -H <Oracle ãããŒã«ãŒã®ãã¹ãå>
-DataService orabroker1 - ãã©ã¡ãŒã¿ãã¡ã€ã«ãä¿åããŸã replProc.pf
- 次ã«ããã£ã¬ã¯ããªå
ã®æ¥ç¶ãããŠãããœãŒã¹ããŒã¿ããŒã¹ããšã«ãã©ã¡ãŒã¿ãã¡ã€ã«ãäœæããéããŠç·šéããå¿
èŠããããŸãã C:Pro2bpreplScripts: bisquit.pfã å pf ãã¡ã€ã«ã«ã¯ã察å¿ããããŒã¿ããŒã¹ã«æ¥ç¶ããããã®ãã©ã¡ãŒã¿ãå«ãŸããŠããŸãã次ã«äŸã瀺ããŸãã
-db bisquit -ld bisquit -H <ãã¹ãå> -S <ãããŒã«ãŒ ããŒã>
-U pro2admin -P <ãã¹ã¯ãŒã>
Windows ã·ã§ãŒãã«ãããèšå®ããã«ã¯ã次ã®ãã£ã¬ã¯ããªã«ç§»åããå¿ èŠããããŸãã C:Pro2bpreplScripts ãPro2 â 管çãã·ã§ãŒãã«ãããç·šéããŸãã ãããè¡ãã«ã¯ãã·ã§ãŒãã«ããã®ããããã£ãéãã ã§éå§ Pro2 ã®ã€ã³ã¹ããŒã« ãã£ã¬ã¯ããªã瀺ããŸãã ãPro2 â Editorãããã³ãRunBulkLoaderãã·ã§ãŒãã«ããã«ã€ããŠãåæ§ã®æäœãè¡ãå¿ èŠããããŸãã
Pro2 管çã»ããã¢ãã: åææ§æã®ããŒã
ã³ã³ãœãŒã«ãèµ·åããŸãããã
ãDBãããããžé²ã¿ãŸãã
Pro2 â 管çã§ããŒã¿ããŒã¹ããªã³ã¯ããã«ã¯ãã¿ãã«ç§»åããŸã DBãããã ãœãŒã¹ããŒã¿ããŒã¹ã®ãããã³ã°ãè¿œå - ã¹ããŒããã«ã㌠- Oracle.
ã¿ãã«ç§»å ãããã³ã°. äžå Ž ãœãŒã¹ããŒã¿ããŒã¹ ããã©ã«ãã§ã¯ãæåã«æ¥ç¶ããããœãŒã¹ ããŒã¿ããŒã¹ãéžæãããŸãã ãªã¹ãã®å³åŽã«ç¢æãããã¯ãã§ã ãã¹ãŠã®ããŒã¿ããŒã¹ãæ¥ç¶ãããŸãã â éžæããããŒã¿ããŒã¹ãæ¥ç¶ãããŠããŸãã å·ŠåŽã®äžã«ã¯ãbisquit ã®é²æããŒãã«ã®ãªã¹ãã衚瀺ãããŸãã å³åŽã«ã¯ãOracle ããŒã¿ããŒã¹ã®ããŒãã«ã®ãªã¹ãããããŸãã
Oracle ã§ã® SQL ã¹ããŒããšããŒã¿ããŒã¹ã®äœæ
ã¬ããªã±ãŒã·ã§ã³ ããããäœæããã«ã¯ããŸãã SQLã¹ããŒã ãªã©ã¯ã«ã§ã Pro2 Administration ã§ã¯ãã¡ãã¥ãŒé ç®ãå®è¡ããŸãã ããŒã« -> ã³ãŒãã®çæ -> ã¿ãŒã²ããã¹ããŒãããã€ã¢ãã°ããã¯ã¹ã§ ããŒã¿ããŒã¹ãéžæ XNUMX ã€ä»¥äžã®ãœãŒã¹ ããŒã¿ããŒã¹ãéžæããå³ã«ç§»åããŸãã
ãOKããã¯ãªãã¯ããSQL ã¹ããŒããä¿åãããã£ã¬ã¯ããªãéžæããŸãã
次ã«ããŒã¹ãäœæããŠãããŸãã ããã¯ãããšãã°æ¬¡ã®ããã«ããŠå®è¡ã§ããŸãã Oracle SQL éçºè ã ãããè¡ãã«ã¯ãOracle ããŒã¿ããŒã¹ã«æ¥ç¶ããããŒãã«ãè¿œå ããããã®ã¹ããŒããããŒãããŸãã Oracle ããŒãã«ã®æ§æãå€æŽããåŸãã¹ããŒã ãã«ããŒå ã® SQL ã¹ããŒããæŽæ°ããå¿ èŠããããŸãã
ããŠã³ããŒããæ£åžžã«å®äºããããbisquitsh ããŒã¿ããŒã¹ãçµäºããPro2 管çããã«ãéããŸãã Oracle ããŒã¿ããŒã¹ã®ããŒãã«ãå³åŽã® [ãããã³ã°] ã¿ãã«è¡šç€ºãããŸãã
ããŒãã«ãããã³ã°
ã¬ããªã±ãŒã·ã§ã³ ããããäœæããã«ã¯ãPro2 管çããã«ã§ [ãããã³ã°] ã¿ãã«ç§»åãããœãŒã¹ ããŒã¿ããŒã¹ãéžæããŸãã ãããŒãã«ã®ãããããã¯ãªãã¯ããOracle ã§ã¬ããªã±ãŒãããããŒãã«ã®å·ŠåŽã«ãããå€æŽã®éžæããéžæããããŒãã«ãå³åŽã«ç§»åããŠéžæã確èªããŸãã éžæããããŒãã«ã®ããããèªåçã«äœæãããŸãã ãã®æäœãç¹°ãè¿ããŠãä»ã®ãœãŒã¹ ããŒã¿ããŒã¹ã®ã¬ããªã±ãŒã·ã§ã³ ããããäœæããŸãã
Pro2 ã¬ããªã±ãŒã·ã§ã³ ããã»ããµ ã©ã€ãã©ãªãšäžæ¬ã³ã㌠ããã»ããµ ããã°ã©ã ã®çæ
ã¬ããªã±ãŒã·ã§ã³ ããã»ããµ ã©ã€ãã©ãªã¯ãPro2 ã¬ããªã±ãŒã·ã§ã³ ãã¥ãŒãåŠçããå€æŽã Oracle ããŒã¿ããŒã¹ã«ããã·ã¥ããã«ã¹ã¿ã ã¬ããªã±ãŒã·ã§ã³ ããã»ã¹ (ETL) çšã«èšèšãããŠããŸãã ã¬ããªã±ãŒã·ã§ã³ ããã»ããµ ã©ã€ãã©ãª ããã°ã©ã ã¯çæåŸã«èªåçã«ãã£ã¬ã¯ããªã«ä¿åãããŸã bprepl/repl_proc (PROC_DIRECTORY ãã©ã¡ãŒã¿ãŒ)ã ã¬ããªã±ãŒã·ã§ã³ ããã»ããµ ã©ã€ãã©ãªãçæããã«ã¯ã次ã®å Žæã«ç§»åããŸãã [ããŒã«] -> [ã³ãŒãã®çæ] -> [ããã»ããµ ã©ã€ãã©ãª]ã çæãå®äºãããšãããã°ã©ã ããã£ã¬ã¯ããªã«è¡šç€ºãããŸãã bprepl/repl_proc.
Bulk Load Processor ããã°ã©ã ã¯ãProgress ABL (4GL) ããã°ã©ãã³ã°èšèªã«åºã¥ããŠããœãŒã¹ Progress ããŒã¿ããŒã¹ãã¿ãŒã²ãã Oracle ããŒã¿ããŒã¹ãšåæããããã«äœ¿çšãããŸãã ããããçæããã«ã¯ãã¡ãã¥ãŒé ç®ã«ç§»åããŸã [ããŒã«] -> [ã³ãŒãã®çæ] -> [äžæ¬ã³ã㌠ããã»ããµ]ã [ããŒã¿ããŒã¹ã®éžæ] ãã€ã¢ãã° ããã¯ã¹ã§ããœãŒã¹ ããŒã¿ããŒã¹ãéžæãããŠã£ã³ããŠã®å³åŽã«ç§»åããŠã OKã çæãå®äºãããšãããã°ã©ã ããã£ã¬ã¯ããªã«è¡šç€ºãããŸãã bpreplrepl_mproc.
Pro2 ã§ã®ã¬ããªã±ãŒã·ã§ã³ ããã»ã¹ã®ã»ããã¢ãã
ããŒãã«ãå¥ã®ã¬ããªã±ãŒã·ã§ã³ ã¹ã¬ããã«ãã£ãŠæäŸãããã»ããã«åå²ãããšãPro2 Oracle ã®ããã©ãŒãã³ã¹ãšå¹çãåäžããŸãã ããã©ã«ãã§ã¯ãæ°ããã¬ããªã±ãŒã·ã§ã³ ããŒãã«ã®ã¬ããªã±ãŒã·ã§ã³ ãããã§äœæããããã¹ãŠã®æ¥ç¶ã¯ãã¹ã¬ããçªå· 1 ã«é¢é£ä»ããããŸããããŒãã«ãç°ãªãã¹ã¬ããã«åå²ããããšããå§ãããŸãã
ã¬ããªã±ãŒã·ã§ã³ ã¹ã¬ããã®ã¹ããŒã¿ã¹ã«é¢ããæ å ±ã¯ãPro2 管çç»é¢ã® [ç£èŠ] ã¿ãã® [ã¬ããªã±ãŒã·ã§ã³ ã¹ããŒã¿ã¹] ã»ã¯ã·ã§ã³ã«è¡šç€ºãããŸãã ãã©ã¡ãŒã¿å€ã®è©³çŽ°ãªèª¬æã¯ãPro2 ããã¥ã¡ã³ã (ãã£ã¬ã¯ã㪠C:Pro2Docs) ã«ãããŸãã
CDC ããªã·ãŒãäœæããŠã¢ã¯ãã£ãåãã
ããªã·ãŒã¯ãOpenEdge CDC ãšã³ãžã³ãããŒãã«ãžã®å€æŽãç£èŠããããã®äžé£ã®ã«ãŒã«ã§ãã å·çæç¹ã§ã¯ãPro2 ã¯ã¬ãã« 0 ã® CDC ããªã·ãŒã®ã¿ããµããŒãããŠããŸããã€ãŸãããã¡ã¯ãã®ã¿ãç£èŠãããŸãã å€æŽãèšé²ãã.
CDC ããªã·ãŒãäœæããã«ã¯ã管çããã«ã§ [ãããã³ã°] ã¿ãã«ç§»åãããœãŒã¹ ããŒã¿ããŒã¹ãéžæã㊠[ããªã·ãŒã®è¿œå /åé€] ãã¿ã³ãã¯ãªãã¯ããŸãã éãããå€æŽã®éžæããŠã£ã³ããŠã§ãCDC ããªã·ãŒãäœæãŸãã¯åé€ããå¿ èŠãããããŒãã«ãå·ŠåŽã§éžæããå³åŽã«ç§»åããŸãã
æå¹ã«ããã«ã¯ã[ãããã³ã°] ã¿ããå床éãããœãŒã¹ ããŒã¿ããŒã¹ãéžæããŠããã¿ã³ãã¯ãªãã¯ããŸãã (ã€ã³)ã¢ã¯ãã£ãåããªã·ãŒã ã¢ã¯ãã£ãåããããªã·ãŒãéžæããŠããŒãã«ã®å³åŽã«ç§»åãããOKããã¯ãªãã¯ããŸãã ãã®åŸããããã¯ç·è²ã§ããŒã¯ãããŸãã ã䜿çšããããšã§ (ã€ã³)ã¢ã¯ãã£ãåããªã·ãŒ CDC ããªã·ãŒãéã¢ã¯ãã£ãåããããšãã§ããŸãã ãã¹ãŠã®ååŒã¯ãªã³ã©ã€ã³ã§è¡ãããŸãã
CDC ããªã·ãŒãã¢ã¯ãã£ãåããããšãå€æŽãããã¬ã³ãŒãã«é¢ããã¡ã¢ãã¹ãã¬ãŒãžé åã«ä¿åãããŸãã ãReplCDCãšãªã¢ã ãœãŒã¹ããŒã¿ããŒã¹ã«ãããšã ãããã®ã¡ã¢ã¯ç¹å¥ãªããã»ã¹ãéããŠåŠçãããŸã CDCBatchããããã«åºã¥ããŠãããŒã¿ããŒã¹å
ã® Pro2 ã¬ããªã±ãŒã·ã§ã³ ãã¥ãŒã«ã¡ã¢ãäœæãããŸãã CDC (ã¬ããªã«).
ãããã£ãŠãã¬ããªã±ãŒã·ã§ã³çšã®ãã¥ãŒã XNUMX ã€ãããŸãã æåã®ã¹ããŒãžã¯ CDCBatch ã§ããããŒã¿ã¯ããœãŒã¹ ããŒã¿ããŒã¹ãããŸãäžé CDC ããŒã¿ããŒã¹ã«éãããŸãã 第 XNUMX 段éã¯ãããŒã¿ã CDC ããŒã¿ããŒã¹ãã Oracle ã«è»¢éããããšãã§ãã ããã¯çŸåšã®ã¢ãŒããã¯ãã£ãšè£œåèªäœã®æ©èœã§ãããããŸã§ã®ãšãããéçºè ã¯çŽæ¥ã¬ããªã±ãŒã·ã§ã³ã確ç«ã§ããŠããŸããã
ãã©ã€ããªåæ
CDC ã¡ã«ããºã ãæå¹ã«ããPro2 ã¬ããªã±ãŒã·ã§ã³ ãµãŒããŒãèšå®ããåŸãåæåæãéå§ããå¿ èŠããããŸãã åæåæã³ãã³ã:
/pro2/bprepl/Script/replLoad.sh ãã¹ããã ããŒãã«å
åæåæãå®äºããããã¬ããªã±ãŒã·ã§ã³ ããã»ã¹ãéå§ã§ããŸãã
ã¬ããªã±ãŒã·ã§ã³ããã»ã¹ã®éå§
ã¬ããªã±ãŒã·ã§ã³ããã»ã¹ãéå§ããã«ã¯ãã¹ã¯ãªãããå®è¡ããå¿ èŠããããŸã replbatch.shã éå§ããåã«ããã¹ãŠã®ã¹ã¬ãã (replbatch1ãreplbatch2 ãªã©) ã« replbatch ã¹ã¯ãªãããããããšã確èªããŠãã ããã ãã¹ãŠãæŽã£ãŠããå Žåã¯ãã³ãã³ã ã©ã€ã³ãéããŸã (ããšãã°ã ç°å¢)ããã£ã¬ã¯ããªã«ç§»åããŸã /bprepl/ã¹ã¯ãªãã ãããŠã¹ã¯ãªãããéå§ããŸãã 管çããã«ã§ã察å¿ããããã»ã¹ã RUNNING ã¹ããŒã¿ã¹ãåãåã£ãããšã確èªããŸãã
çµæ
å°å
¥åŸã¯ãäŒæ¥ããŒã¿ ãŠã§ã¢ããŠã¹ãžã®æ
å ±ã®ã¢ããããŒãã倧å¹
ã«é«éåãããŸããã ããŒã¿ã¯èªåçã«ãªã³ã©ã€ã³ã§ Oracle ã«åã蟌ãŸããŸãã ããŸããŸãªã·ã¹ãã ããããŒã¿ãåéããããã«ãé·æéå®è¡ãããã¯ãšãªãå®è¡ããŠæéãç¡é§ã«ããå¿
èŠã¯ãããŸããã ããã«ããã®ãœãªã¥ãŒã·ã§ã³ã§ã¯ã¬ããªã±ãŒã·ã§ã³ ããã»ã¹ã§ããŒã¿ãå§çž®ã§ãããããé床ã«ããã©ã¹ã®åœ±é¿ãåãŒããŸãã çŸåšãBISKVIT ã·ã¹ãã ãšä»ã®ã·ã¹ãã ãšã®æ¯æ¥ã®èª¿æŽã«ã¯ 15 ïœ 20 æéã§ã¯ãªã 2 ïœ 2,5 åãããããã«ãªããå®å
šãªèª¿æŽã«ã¯ XNUMX æ¥ã§ã¯ãªãæ°æéããããŸããã
åºæïŒ habr.com