You are here

Replications Check Sync

 

Replications Check / Sync in einen 4Node Informix Enterprise Verbund.

 

-- Es gibt unterschiedliche möglichkeite um zu Prüfen ob die Replicate in sync sind.

-- cdr check vom einzelnen Replikat, wobei der –m tgx04_grp der Master ist und tgx03_grp Target ist, durch ER Mittel.  

tgxrf03@informix[tgxrf03]: cdr check repl -m tgx04_grp -r PFMA_tgx03_1_21_trpauto tgx03_grp  

------ Statistics for PFMA_tgx03_1_21_trpauto ------  
 Node Rows Extra Missing Mismatch Processed  
---------------- --------- --------- --------- --------- ---------
tgx04_grp 26 0 0 0 0
tgx03_grp 26 0 0 0 0

 

-- Oder : -a es werden alle Replicate in den ReplocatSet “VVMAN” überprüft, von den master „tgx04_grp“ aus.  

tgx04@informix[ tgx04]: cdr check replset -m tgx04_grp -s VVMAN -a

 Processing VVMAN_tgx04_8_3_tesid with 1 rows group 1 
------ Statistics for VVMAN_tgx04_8_3_tesid ------ 
 Node Rows Extra Missing Mismatch Processed  
---------------- --------- --------- --------- --------- ---------
tgx04_grp 1 0 0 0 0
tgx03_grp 1 0 0 0 0
tgx03_grp 1 0 0 0 0
tgx04_grp 1 0 0 0 0
Processing VVMAN_tgx04_41_2_blockorder with 434 rows group 2 ------ Statistics for VVMAN_tgx04_41_2_blockorder ------ Node Rows Extra Missing Mismatch Processed
---------------- --------- --------- --------- --------- ---------
tgx04_grp 434 0 0 0 0
tgx03_grp 439 6 1 3 0
tgx03_grp 439 6 1 3 0
tgx04_grp 439 6 1 3 0
WARNING: replicate is not in sync
Processing VVMAN_tgx04_41_1_saldokorr with 28436 rows group 3 ------ Statistics for VVMAN_tgx04_41_1_saldokorr ------ Node Rows Extra Missing Mismatch Processed
---------------- --------- --------- --------- --------- ---------
tgx04_grp 28436 0 0 0 0
tgx03_grp 28436 0 0 0 0
tgx03_grp 28436 0 0 0 0
tgx04_grp 28436 0 0 0 0

   

-- Oder :

tgx04@informix[tgx04]: cdr check replicate -m tgx04_grp -r VVMAN_tgx04_8_3_tesid –a

------ Statistics for VVMAN_tgx04_41_2_blockorder ------  
 Node Rows Extra Missing Mismatch Processed  
---------------- --------- --------- --------- --------- ---------
tgx04_grp 436 0 0 0 0
tgx03_grp 436 0 0 0 0
tgx03_grp 436 0 0 0 0
tgx04_grp 436 0 0 0 0



 

 

-- Um die Inkonsistenz des Replicas zu beseitigen, sync durchführen.

tgx04@informix[tgx04]: cdr sync repl -m tgx04_grp -r VVMAN_tgx04_41_2_blockorder tgx03_grp tgx04_grp tgx03_grp

 Creating Shadow Repl sync_565440_655622862_1221122755:1:655622862:10004:10002:10003:10001
Starting synchronization scan for replicate
VVMAN_tgx04_41_2_blockorder
marking completed on tgx04_grp status 0
Ending synchronization scan for replicate
VVMAN_tgx04_41_2_blockorder