Cancelling A query

Posted in 1997

Peter Wages — 7 Nov 1997 17:38:32 -0500 — source: Informix-list mailing list archive (1991-1998)

We have a reoccurring situation where a user in dbaccess submits a query against several large tables , changes his mind and cancels it with control-c. This has brought down the database. We're using 7.14 UD1 on an HP K460/T6600. Is there any way to prevent this? We have an 80 gigabyte database. Currently the policy is to not have the user cancel the query. But have get a DBA to kill the session id. However the user may not obey instructions and this is a very cumbersome way to approach this problem. We have users at 4 sites. Thanks ciao p ****************************************************************************** Peter Wages EDS Arlington, Virginia pmwages@cais.com Work: (703) 741-7436 Home: (202) 244-3511 Anywhere is walking distance, if you have the time ******************************************************************************