-->
Initial load
On the source:
ADD EXTRACT EINI01, SOURCEISTABLE
EXTRACT EINI01
USERID GGSOURCE, PASSWORD GGSOURCE
RMTHOST localhost, PORT 7809
RMTTASK REPLICAT, GROUP RINI01
TABLE GGSOURCE.OBJT;
On target:
ADD REPLICAT RINI01, SPECIALRUN
REPLICAT RINI01
ASSUMETARGETDEFS
OVERRIDEDUPS
INSERTAPPEND
BATCHSQL
USERID GGDEST, PASSWORD GGDEST
DISCARDFILE ./dirrpt/RINI01.DSC, PURGE
MAP GGSOURCE.OBJT, TARGET GGDEST.OBJT;
START EINI01
Simplest replication
On the source:
DBLOGIN USERID GGSOURCE, PASSWORD GGSOURCE
ADD TRANDATA owner.table
ADD EXTRACT EORA01, TRANLOG, BEGIN NOW, THREADS 1
ADD RMTTRAIL ./dirdat/st, EXTRACT EORA01
EXTRACT EORA01
USERID ggsource, PASSWORD ggsource
RMTHOST localhost, MGRPORT 7809
RMTTRAIL ./dirdat/st
TABLE GGSOURCE.OBJT;
On target:
EDIT PARAMS ./GLOBALS
CHECKPOINTTABLE GGDEST.ggschkpt
Выйти из консоли и войти
DBLOGIN USERID GGDEST, PASSWORD GGDEST
ADD CHECKPOINTTABLE
ADD REPLICAT RORA01, EXTTRAIL ./dirdat/st
REPLICAT RORA01
USERID GGDEST, PASSWORD GGDEST
HANDLECOLLISIONS
ASSUMETARGETDEFS
DISCARDFILE ./dirrpt/RORA01.DSC, PURGE
MAP GGSOURCE.OBJT, TARGET GGDEST.OBJT;
