[comp.databases] Informix sqlexec won't go away

jwas@PacBell.COM (Joe Wasik) (11/15/90)

I have been told that this is where the Informix gurus spend their
time.  So, here goes...

We run a Informix-4GL application that helps the user find files, then it
starts a child process to UUCP those files to the user.  When the user hangs
up the Informix-4GL application, the child processes and sqlexec are still
running.

The child processes properly detached themselves from the tty port (using sys
V setpgrp) and they are not a problem.  However, sqlexec remains attached to
the tty port and appears to be waiting for these children to finish.  The
result: there is no way to cleanly log off.  Users who come in through login,
go back to the login prompt.  Users who came in through remote execution
facilities (such as those provided by datakit) simply hang until sqlexec is
finished.

Please, does anyone in Informix-Land have a good solution to this?  How
can we make sqlexec go away?  How can sqlexec be detached from its tty port?

Thanks.

-- 
Joe Wasik - PacBell, 2600 Camino Ramon, 4e750, San Ramon, CA 94583  415-823-2422
jwas@PacBell.COM or {att,bellcore,sun,ames,pyramid}!pacbell!pbhyf!jwas
#define POINTS_OF_LIGHT 1000