Anna Fong writes: > > What we've noticed is that when we kill the web app PID, the database query > process still remains active. Yet, when we directly kill the database > query PID, the web app PID is automagically killed. > > Is there any way through DBI to do this? In other words, do I really need > to get the DBA involved?
This isn't going to be directly relevant, because it's a Sybase solution, but it might give some ideas: Sybase OpenClient supports a "timeout" feature that is handled by the client library, much like a SIGALRM. When the timeout is hit a handler is called and the client app can decide to cancel the query at that point. DBD::Sybase supports this feature, and I've used it successfully to limit the amount of time a CGI spends in waiting for SQL results. Michael -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] *or* [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Inter. Sybase User Group: http://www.isug.com
