Hi, *
I wonder if you guys have a standard way of dealing with the
following problem which is not very likely to happen but
gives you problems in batch jobs running on a regular basis:
With Informix (tested on Versions up to 9.2 - I suppose its
the same with newer versions because it is due to the
client db data exchange protocol - please correct me if I am
wrong) the following can happen:
1. client connencts
2. client sends select to server which will take lets say
a second to get the result
3. client starts waiting for server to answer
4. server dies / connection breaks
Result: client waits forever.
One way to deal with this is to kill the statement if there
is no result after some defined amout of time.
Is there a better way?
Thanks,
Dirk
--
--
-- Dirk Gunsthoevel IT Systemanalyse phone: +49 (0)251 28446-0
-- Hammer Str. 13 fax: +49 (0)251 28446-55
-- D-48153 Muenster http://www.GunCon.de/
-- "It ain't over 'til it's over."
