Kai Shen <kai_shen@ccmail.acer.de> wrote:
:Hi all,
:we have an Informix 7.22 server running on SCO Unix System V
What version?
There are many known problems in SCO TCP/IP in the differen versions
of the OS. These may cause exactly the type of problems you have. If
you use anything prior to SCO Unix 3.2.4.2 you have to upgrade as far
as I know. If you are using ver. 3.2.4.2, 5.0.0d or 5.0.2 you have to
make shure you have got the latest patches to the TCP/IP library. You
can find these at their ftp server at ftp.sco.com. I don't know in
what directory as I normaly leave these things to my supplier of SCO
Unix.
Be aware the SCO Unix 3.2.4.2 is no longer supported by SCO (although
you can easily get the needed patches) so you should plan for an
upgrade to 5.0.2. They will also soon release their even newer version
which I think is what has been called Gemini, but from earlier
experience with such upgrades from SCO I wouldn't use this until quite
some time after the initial release. (Not uncommon with other OS
suppliers as well of course.)
: and try to
:connect to a second server via TCP/IP. The sqlhosts entry, onconfig
:parameter seem to be correct, since the connection can be established
:and works find then. Only once in a while, usually during heavy user
:load, we either get the error -25588 (cannot connect to database server)
:or CANNOT ATTACH TO TRANSACTION (without error number). We use
:4GL-programs to connect to the remote server, and the 25588 error comes
:in the MAIN line, the transaction error does not show a line number.
:Any ideas?
:This is a very important point to us, and I am running mad since.
:
:TIA and regards,
:Kai
Nils.Myklebust@idg.no
NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway
My opinions are those of my company
The Informix FAQ is at http://www.iiug.org