home clear 64x64
en blue 200x116 de orange 200x116 info letter User
suche 36x36
Latest versionsfixlist
14.10.xC11 FixList
12.10.xC16.X5 FixList
11.70.xC9.XB FixList
11.50.xC9.X2 FixList
11.10.xC3.W5 FixList
Have problems? - contact us.
Register for free anmeldung-x26
Contact form kontakt-x26

Informix - Problem description

Problem IT45413 Status: Closed

A PRIMARY & RSS CAN STOP TRANSMITTING DATA AND STATUS SHOWS BLOCKED OR
BLOCKLOGXMIT

product:
INFORMIX SERVER / 5725A3900 / E10 - 
Problem description:
After the RSS has been running for a time, it is possible to
see, on the primary, that the buffers are no longer advancing
and you will see a status of either Blocked or BlockLogXmit ...

An onstat -g rss verbose report will show something like the
following ...

Local server type: Primary
Index page logging status: Enabled
Index page logging was enabled at: 2023/10/10 12:41:31
Number of RSS servers: 1

RSS Server information:

RSS Server control block: 0x700040000411028
RSS server name: name
RSS server status: Active
RSS connection status: Connected
RSS flow control:0/0
Log transmission status: Blocked
Next log page to send(log id,page): 98933,1620
Last log page acked(log id,page): 98926,1658
Last log page applied(log id,page): 98926,1657
Time of Last Acknowledgement: 2024-02-05.16:12:00
Pending Log Pages to be ACKed: 13961
Approximate Log Page Backlog:15077
Sequence number of next buffer to send: 21789
Sequence number of last buffer acked: 15388
Supports Proxy Writes: N
Total number of delay(s): 0
Time of last delay: N/A

The gap between buffers send and acked will be 6401.

or an onstat -g rss report will show something like the
following ...

RSS Srv      RSS Srv      Connection     Next LPG to send
Supports
name         status       status           (log id,page)
Proxy Writes
name          BlockLogXmit Connected           98933,1620
N

The RSS node needs to be bounced.
Problem Summary:
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC11.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC11.                       *
****************************************************************
Local Fix:
Solution
Workaround
****************************************************************
* USERS AFFECTED:                                              *
* Users of Informix Server prior to 14.10.xC11.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* See Error Description                                        *
****************************************************************
* RECOMMENDATION:                                              *
* Upgrade to Informix Server 14.10.xC11.                       *
****************************************************************
Comment
Fixed in Informix Server 14.10.xC11.
Timestamps
Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :
05.02.2024
07.06.2024
07.06.2024
Problem solved at the following versions (IBM BugInfos)
Problem solved according to the fixlist(s) of the following version(s)