enterprise replication send q query
Posted in 2012
IBM Informix Dynamic Server Version 11.50.FC6 HP-UX wuasp132 B.11.23 U 9000/800 Hoping someone can help we use enterprise replication. I have two reps with data in q as follows ------------------------------ REPLICATE: ec_accept_ec_cert_text STATE: Active ON:ec_ap_uat_wlg CONFLICT: Timestamp FREQUENCY: immediate QUEUE SIZE: 846 PARTICIPANT: ec_accept:paqis.ec_cert_text REPLICATE: ec_accept_ec_arch_cert_text STATE: Active ON:ec_ap_uat_wlg CONFLICT: Timestamp FREQUENCY: immediate QUEUE SIZE: 306 PARTICIPANT: ec_accept:paqis.ec_arch_cert_text I have done a check on the table and they both check out ok as follows Node Rows Extra Missing Mismatch Processed ---------------- --------- --------- --------- --------- --------- ec_ap_uat_wlg 76 0 0 0 0 ec_ap_uat_akl 76 0 0 0 0 Feb 09 2012 09:52:05 ------ Table scan for ec_accept_ec_arch_cert_text end --------- Feb 09 2012 09:52:06 ------ Table scan for ec_accept_ec_cert_text start -------- Node Rows Extra Missing Mismatch Processed ---------------- --------- --------- --------- --------- --------- ec_ap_uat_wlg 198 0 0 0 0 ec_ap_uat_akl 198 0 0 0 0 Feb 09 2012 09:52:07 ------ Table scan for ec_accept_ec_cert_text end --------- So is it a problem ? how do I clear the q ? Only these 2 tables have qs that dont clear