When it appears that Dbvisit Replicate does not replicate the changes please check the following:
...
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> show interface MINE1.MINE_LISTEN_INTERFACE = 0.0.0.0:7903
*.MINE_REMOTE_INTERFACE = localhost:7890
APPLY.APPLY_LISTEN_INTERFACE = 0.0.0.0:7902
APPLY.APPLY_REMOTE_INTERFACE = xxx:7902
MINE.MINE_LISTEN_INTERFACE = 0.0.0.0:7901
APPLY1.APPLY_REMOTE_INTERFACE = xxx:7904
*.APPLY_REMOTE_INTERFACE = localhost:7891
APPLY1.APPLY_LISTEN_INTERFACE = 0.0.0.0:7904
*.FETCHER_REMOTE_INTERFACE = localhost:7889
*.MINE_LISTEN_INTERFACE = localhost:7890
MINE.MINE_REMOTE_INTERFACE = xxx:7901
*.APPLY_LISTEN_INTERFACE = localhost:7891
*.FETCHER_LISTEN_INTERFACE = localhost:7889
MINE1.MINE_REMOTE_INTERFACE = xxx.cr:7903 |
|
|
3) Find out the internal tables have been replicated. The Applied records should match the Mine records and show 100%
| Section |
|---|
| Column |
|---|
| | Panel |
|---|
| dbvrep> list progress all
Progress of replication d112F: total/this execution
--------------------------------------------------------------------------------------------------------------------------------------------
DBVREP.DBRSOBJ$:
100% 100% Mine:75679/ 75679 75679 Unrecov:0/ 0 0 Applied:75679/75679 Conflicts:0/ 0 0 Last:25/11/2013 21:48:37/OK
DBVREP.DBRSUSER$: 100% 100% Mine:103/ 103 103 Unrecov:0/ 0 0 Applied:103/ 103 103 Conflicts:0/ 0 0 Last:25/11/2013 11:41:01/OK
-------------------------------------------------------------------------------------------------------------------------------------------- |
|
|
4) Use the "list prepare" command in the Dbvisit Replicate command console
...