Replication not replicating

Good day All In need of assistance. I have this issue on replication. Replication not replicating from server 1 to server 2. both server is connected and active. if i check replication queue it clears but the data is not replicating from the one server to the other server. Replicates is active and setup correctly. Maybe i'm missing something any advice would be appreciated where to start looking for the issue ------------------------------ Jaco Loots ------------------------------

Jaco: What type of replication have you set up? Enterprise Replication (ER)? High Availability Data Replication (HDR), or Remote Secondary Server (RSS) replication? If HDR post the output from "onstat -g dri" If RSS post the output from "onstat -g rss" If ER post the output from: cdr list server <servername> (for both servers) cdr list repl -c <servername> full We can try to help, but you have not provided enough detail about the problem. Art ------------------------------ Art S. Kagel, President and Principal Consultant ASK Database Management Corp. www.askdbmgt.com ------------------------------

| view attached Sorry let me know info you need and i will provide it output for cdr list server server 1 SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ------------------------------ grp_05_iwqs 5 Active Connected 0 Feb 18 15:12:31 grp_08_headq 8 Active Local 0 grp_108_headq 108 Active Connected 0 Feb 18 15:12:29 grp_120_nwest 120 Active Connected 0 Feb 18 15:12:29 grp_121_mpum 121 Active Connected 0 Feb 18 15:12:30 grp_125_ncape 125 Active Connected 0 Feb 18 15:12:29 grp_126_ecape 126 Active Connected 0 Feb 18 15:12:29 grp_15_gaut 15 Active Connected 58403 Feb 18 16:31:46 grp_20_nwest 20 Active Connected 58403 Feb 18 15:12:34 grp_21_mpum 21 Active Connected 58403 Feb 18 15:12:30 grp_22_fs 22 Active Connected 58403 Feb 18 15:12:29 grp_23_north 23 Active Connected 58403 Feb 18 15:12:29 grp_24_kzn 24 Active Connected 58403 Feb 18 15:12:29 grp_25_ncape 25 Active Connected 58403 Feb 18 15:12:29 grp_26_ecape 26 Active Connected 58403 Feb 18 15:12:29 server 2 SERVER ID STATE STATUS QUEUE CONNECTION CHANGED ------------------------------ grp_05_iwqs 5 Active Connected 0 Feb 18 06:16:17 grp_08_headq 8 Active Connected 3718 Feb 18 16:31:58 grp_108_headq 108 Active Connected 0 Feb 18 06:16:17 grp_120_nwest 120 Active Connected 0 Feb 18 06:16:17 grp_121_mpum 121 Active Connected 0 Feb 18 06:16:18 grp_125_ncape 125 Active Connected 0 Feb 18 06:16:18 grp_126_ecape 126 Active Connected 0 Feb 18 06:16:17 grp_15_gaut 15 Active Local 0 grp_20_nwest 20 Active Connected 858 Feb 18 06:16:17 grp_21_mpum 21 Active Connected 858 Feb 18 06:16:17 grp_22_fs 22 Active Connected 858 Feb 18 06:16:17 grp_23_north 23 Active Connected 858 Feb 18 06:16:17 grp_24_kzn 24 Active Connected 858 Feb 18 08:39:27 grp_25_ncape 25 Active Connected 858 Feb 18 06:16:17 grp_26_ecape 26 Active Connected 858 Feb 18 08:39:59 do you need the output for both the servers ------------------------------ Jaco Loots ------------------------------

for the 'problem' replicant turn on ats/ris and post the definition (cdr list repl <replname> and cdr list repl brief <replname>

server 1 informix@dwsuxhqwrm:/informix_backups/jaco$ cdr list repl brief A_wes_session_A1 REPLICATE TABLE SELECT ------------------------------ A_wes_session_A1 warms@grp_08_headq:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_15_gaut:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_20_nwest:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_21_mpum:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_22_fs:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_23_north:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_24_kzn:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_25_ncape:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_26_ecape:dwafdba.wes_session select * from wes_session informix@dwsuxhqwrm:/informix_backups/jaco$ cdr list repl A_wes_session_A1 DEFINED REPLICATES ATTRIBUTES ------------------------------ REPLICATE: A_wes_session_A1 STATE: Active ON:grp_08_headq CONFLICT: Timestamp FREQUENCY: immediate QUEUE SIZE: 7293 PARTICIPANT: warms:dwafdba.wes_session OPTIONS: transaction,ris,ats,fullrow REPLID: 536111 / 0x82e2f REPLMODE: PRIMARY ON:grp_08_headq APPLY-AS: INFORMIX ON:grp_08_headq server 2 dwafcen250 {informix} $ cdr list repl brief A_wes_session_A1 REPLICATE TABLE SELECT ------------------------------ A_wes_session_A1 warms@grp_08_headq:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_15_gaut:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_20_nwest:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_21_mpum:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_22_fs:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_23_north:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_24_kzn:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_25_ncape:dwafdba.wes_session select * from wes_session A_wes_session_A1 warms@grp_26_ecape:dwafdba.wes_session select * from wes_session dwafcen250 {informix} $ cdr list repl A_wes_session_A1 DEFINED REPLICATES ATTRIBUTES ------------------------------ REPLICATE: A_wes_session_A1 STATE: Active ON:grp_15_gaut CONFLICT: Timestamp FREQUENCY: immediate QUEUE SIZE: 7722 PARTICIPANT: warms:dwafdba.wes_session OPTIONS: transaction,ris,ats,fullrow REPLID: 525407 / 0x8045f REPLMODE: PRIMARY ON:grp_15_gaut APPLY-AS: INFORMIX ON:grp_15_gaut ------------------------------ Jaco Loots ------------------------------

Hi Jaco, on each of the two sites the replicate has a couple of bytes queued - is this stable over time, or even increasing? Any chance you recently altered this table ( wes_session) and the replicate still is in alter mode? Can you post the output of "onstat -g cat A_wes_session_A1" on each of these two servers? BR, Andreas ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------

The queue clear over time when i checked now the queue was smaller The table was not changed dwafcen250 {informix} $ onstat -g cat A_wes_session_A1 IBM Informix Dynamic Server Version 11.70.FC7W2 -- On-Line -- Up 1 days 23:26:57 -- 10649600 KbytesGLOBAL-CATALOG CACHE STATISTICS REPLICATES ------------------- Name: A_wes_session_A1, Id: 525407 State: ACTIVE Flags: 0 use 0 lastexec Thu Jan 1 02:00:00 1970 Local Participant: warms:dwafdba.wes_session Attributes: TXN scope, Enable ATS, Enable RIS, all columns sent in updates Conflict resolution[Prim::Sec]: [TIMESTAMP] Delete shadow table: cdr_deltab_000229 Column Mapping: ON, columns INORDER, offset 8, uncomp_len 91 No Replicated UDT Columns informix@dwsuxhqwrm:~$ onstat -g cat A_wes_session_A1 IBM Informix Dynamic Server Version 11.70.FC8W1 -- On-Line -- Up 118 days 09:21:46 -- 12222464 KbytesGLOBAL-CATALOG CACHE STATISTICS REPLICATES ------------------- Name: A_wes_session_A1, Id: 536111 State: ACTIVE Flags: 0 use 0 lastexec Thu Jan 1 02:00:00 1970 Local Participant: warms:dwafdba.wes_session Attributes: TXN scope, Enable ATS, Enable RIS, all columns sent in updates Conflict resolution[Prim::Sec]: [TIMESTAMP] Delete shadow table: cdr_deltab_000746 Column Mapping: ON, columns INORDER, offset 8, uncomp_len 91 No Replicated UDT Columns ------------------------------ Jaco Loots ------------------------------

So how are you telling replication doesn't work - for this particular table, between those two servers, ... ? What exactly are you seeing as not working? ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------

Data entered on the one server does not replicate to the other server. If you check the table on the other server the data is not the same as the first one. ------------------------------ Jaco Loots ------------------------------

what is in the ATS/RIS files ? If this is non-prod change scope to row and see if anything get replicated ? At the moment I suspect the whole Tx is rolling back Not sure if still the case but if the ATS/RIS directories don't exist it used to silently fail on the ats/ris generation

there is only ris files RRH Row:1 / Replicate Id: 536111 / Table: warms@dwafdba.wes_session / DbOp:Update RRH CDR:3 (Warning: Update exception, row does not exist in target table, converted to insert) / SQL:0 / ISAM:0 it is in the prod systems ------------------------------ Jaco Loots ------------------------------

With TX scope, then AFAIK, you should get a ATS file I think that looks good though, check all the others servers ?

That server (grp_15_gaut) does not replicate to any of the other servers. and on that replicate there is no ATS files ------------------------------ Jaco Loots ------------------------------

If the replicate is shown with a variable, non-zero queue on grp_15_gaut, this means the transactions do get sent to all the targets and must be failing/dismissed there which in turn would result in ats/ris files on those targets -> have you checked there? The one ris file you showed is not for a failure, but rather an information about an update turned into an insert which then did get applied. Unfortunately you didn't post the source and target info at the top of the file. ------------------------------ Andreas Legner Informix Dev HCL Software ------------------------------

The is no ATS/RIS files on any server for it ------------------------------ Jaco Loots ------------------------------