> I´m using sqldetach to close all database connections after a fork and
> before spawning a new application. However sometimes sqldetach doesn´t
[quoted text clipped - 5 lines]
> like to solve the problem within the main application. Maybe setting a
> timer could help?
Sounds like there might be a problem...which o/s are you using, and
which version of CSDK?
Getting lost in the SQL libraries while debugging is normal. :(

Signature
Jonathan Leffler #include <disclaimer.h>
Email: jleffler@earthlink.net, jleffler@us.ibm.com
Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/
"Blessed are we who can laugh at ourselves, for we shall never cease
to be amused."
NB: Please do not use this email for correspondence.
I don't necessarily read it every week, even.
david@smooth1.co.uk - 27 Nov 2008 01:49 GMT
> On Wed, Nov 26, 2008 at 6:04 AM, Joerg.Spil...@googlemail.com
>
[quoted text clipped - 22 lines]
> NB: Please do not use this email for correspondence.
> I don't necessarily read it every week, even.
What is the stack for the thread calling sqldetach and the output of
onstat -g stk <tid> for the corresponding IDS thread?
Joerg.Spilker@googlemail.com - 03 Dec 2008 11:12 GMT
> What is the stack for the thread calling sqldetach and the output of
> onstat -g stk <tid> for the corresponding IDS thread?
i´ll try to collect this information when the problem happens again.
Joerg.Spilker@googlemail.com - 03 Dec 2008 11:04 GMT
> Sounds like there might be a problem...which o/s are you using, and
> which version of CSDK?
O/S:
ei93253.gll.ads.niedersachsen.de >uname -a
OSF1 ei93253.gll.ads.niedersachsen.d V5.1 2650 alpha
CSDK:
ei93253.gll.ads.niedersachsen.de >c4gl -V
IBM INFORMIX-4GL Version 7.32.FC2
Software Serial Number RDS#N000000
ei93253.gll.ads.niedersachsen.de >esql -V
IBM Informix CSDK Version 2.81, IBM Informix-ESQL Version 9.53.FC2
Software Serial Number RDS#N000000
Database:
ei93253.gll.ads.niedersachsen.de >onstat -
V
IBM Informix Dynamic Server Version 9.40.FC9 Software Serial
Number AAA#B000000