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