INFORMIX SERVER / 5725A3900 / C10 - IDS 12.10

When two or more IDS instances execute remote SQL on a central
IDS server the potential exists for the connection attempt from
at least one of the client servers to hang and then timeout with
a 908 error. A subsequent connection attempt will frequently
succeed.

An example error:

  908: Attempt to connect to database server (remoteifxsvr,
conerr=-27001, oserr=0) failed.

For the time period that the client server is trying to connect
the command onstat -u on the remote server will show a thread
waiting on a transaction:

Userthreads
address          flags   sessid   user     tty      wait
tout locks nreads   nwrites
44e83638         T--P--- 87       informix 2        44ec8618
0    0     0        0

The stack for the associated srvinfx thread will show:

yield_processor_svp
mt_yield
tx_txwait
isattach
initdistrib
init_sqscb
sqmain
spawn_thread
th_init_initgls
startup

This problem results from the local IDS instances using the same
values for DBSERVERNAME and SERVERNUM. One workaround is to
ensure each IDS instance uses a unique combination of these two
parameters.

****************************************************************
* USERS AFFECTED:                                              *
* Users of IDS 12.10.xC11 and earlier versions.                *
****************************************************************
* PROBLEM DESCRIPTION:                                         *
* Sporadic 908 errors may occur when multiple Informix servers *
* execute remote SQL on a central server.                      *
****************************************************************
* RECOMMENDATION:                                              *
****************************************************************

keiner bekannt / siehe Local-Fix

Datum - Problem gemeldet    :
Datum - Problem geschlossen :
Datum - der letzten Änderung:

26.12.2018
07.10.2019
07.10.2019

12.10.xC12