Re: SE kill safe ?
Posted in 1999
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration
[cutting]
>Maybe there are better ways to kick to users out ?
>In the ESQL/C program i can program an alarm, but what about the SQL
>form ?
>
>
> NEVER KILL SQLEXEC processes. Even if it is not active it may be
> part way through a tranaction which will not get rollbacked back.
>
> Kill -1 the parent process i.e. the .4ge, isql and dbaccess.
>
> The parent process get the hangup signal, shutdown cleanly and
> disconnect from the database, cleanly shutting down the sqlexec
> process.
Remember to be patient it might take a while
Paul Watson
WF Software Ltd
Tel: +44 1436 674729
Fax: +44 1436 678729
www.wfsoftware.com/informix
# If you broke it, hide the evidence
**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.
This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************