APAR status
Closed as program error.
Error description
Source server sendq has nnn transactions. All these txns are waiting for ack from server id xx(subhost_xyz). Source server sendq xxx table shows txns are acknowledged for replicate id 0x123(sync replicate on badge table). Target server subhost_xyz receive queue is empty. It's xxx table shows txns received for replicate id 0x123. But ack point is not updated. But looks like txns are applied. part of onstat -g rcv full output at subhost_xyz for replicate id 65576/0x123 65576 22851 457020 0 0 2011/06/02 11:50:25 (apply time at target server) 2011/06/02 11:50:04 (source server commit time) receive queue xxx table: 1 0x10028 84544980 efffffff/efffffff/efffffff/efffffff (last txn acked, nothing acked) - 1/32/259f670/13 (last received txn id) Source xxx table: 0x10028 17234155 1/32/259f670/0 (last txn acked from server xx) - 1/32/259f670/0 (last txn queued to server xx) During this time, network connection lost between source and target server and connection re-established. Message log file at source server: 11:50:05 CDR NIF ASF SEND failed asfcode -25580 oserr 0 11:50:05 CDR connection to server lost, id xx, name <subhost_xyz> Reason: error detected 11:50:19 CDR: Re-connected to server, id xx, name <subhost_xyz> Source server thinks that txns are not acknowledged by server xx even though ack is received. Due to this reason txns are not deleted from sendq. Sync task hung due to this reason as we temporarily suspend queuing txns to sendq if sendq spooling is required.
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: * * All platforms * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description * **************************************************************** * RECOMMENDATION: * * Update to IBM Informix Server 11.50.xC9 * ****************************************************************
Problem conclusion
Problem Fixed In IBM Informix Server 11.50.xC9
Temporary fix
Comments
APAR Information
APAR number
IC77048
Reported component name
INFORMIX SERVER
Reported component ID
5725A3900
Reported release
B50
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2011-06-17
Closed date
2017-06-19
Last modified date
2017-06-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
INFORMIX SERVER
Fixed component ID
5725A3900
Applicable component levels
RB50 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSGU8G","label":"Informix Servers"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"B50","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 June 2017