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.
Original Message:
Sent: Wed February 18, 2026 01:56 PM
From: Jaco Loots
Subject: Replication not replicating
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
Original Message:
Sent: Wed February 18, 2026 01:42 PM
From: Paul Watson
Subject: Replication not replicating
With TX scope, then AFAIK, you should get a ATS file
I think that looks good though, check all the others servers ?
On 2/18/2026 12:33 PM, Jaco Loots via IBM TechXchange Community wrote:
0100019c72070d85-0af582a6-6f18-494b-bb25-34dc7f39eda8-000000@email.amazonses.com"> there is only ris files RRH Row:1 / Replicate Id: 536111 / Table:
warms@dwafdba.wes_session / DbOp:Update RRH CDR:3 (Warning: Update exception,... -posted to the "Informix" group
Original Message:Sent: 2/18/2026 1:33:00 PMFrom: Jaco LootsSubject: RE: Replication not replicatingthere is only ris files
RRH Row:1 / Replicate Id: 536111 / Table: warms@dwafdba.wes_session / DbOp:UpdateRRH 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
Original Message:Sent: Wed February 18, 2026 01:13 PMFrom: Paul WatsonSubject: Replication not replicatingwhat 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 On 2/18/2026 11:44 AM, Jaco Loots via IBM TechXchange Community wrote:
0100019c71da32b6-e745a032-5570-49a2-90ff-d55560f50872-000000@email.amazonses.com"> 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... -posted to the "Informix" group
Original Message:Sent: 2/18/2026 12:44:00 PMFrom: Jaco LootsSubject: RE: Replication not replicatingData 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 LootsOriginal Message:Sent: Wed February 18, 2026 12:27 PMFrom: Andreas LegnerSubject: Replication not replicatingSo 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 LegnerInformix DevHCL SoftwareOriginal Message:Sent: Wed February 18, 2026 12:22 PMFrom: Jaco LootsSubject: Replication not replicatingThe queue clear over time when i checked now the queue was smaller
The table was not changed
dwafcen250 {informix} <bq>nbsp; onstat -g cat A_wes_session_A1</bq>
IBM Informix Dynamic Server Version 11.70.FC7W2 -- On-Line -- Up 1 days 23:26:57 -- 10649600 Kbytes
GLOBAL-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 Kbytes
GLOBAL-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
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 LegnerInformix DevHCL SoftwareOriginal Message:Sent: Wed February 18, 2026 11:43 AMFrom: Jaco LootsSubject: Replication not replicatingserver 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
for the 'problem' replicant turn on ats/ris and post the definition (cdr list repl <replname> and cdr list repl brief <replname> On 2/18/2026 9:45 AM, Jaco Loots via IBM TechXchange Community wrote:
0100019c716d5cd0-05438624-b4b0-49c8-863e-159dfd2b3e2a-000000@email.amazonses.com"> Sorry let me know info you need and i will provide it output for cdr list server server 1 SERVER ID STATE STATUS QUEUE... -posted to the "Informix" group
Original Message:
Sent: 2/18/2026 10:45:00 AM
From: Jaco Loots
Subject: RE: Replication not replicating
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
Original Message:
Sent: Wed February 18, 2026 10:22 AM
From: Art Kagel
Subject: Replication not replicating
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
Original Message:
Sent: Wed February 18, 2026 10:09 AM
From: Jaco Loots
Subject: 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
------------------------------