Long running queries
Hello All, I am looking for a script/sql which will display user details who have been running queries(current sql statement) for over 5 minutes. I need to terminate all user sessions running for over 5 minutes. Thanks in advance. Lloyd
Informix version? OS version? Bob ----- Original Message ----- From: "Lloyd S" <lloyd_s@rediffmail.com> To: ids@iiug.org Sent: Friday, May 21, 2010 2:09:05 PM GMT -05:00 US/Canada Eastern Subject: Long running queries [20202] Hello All, I am looking for a script/sql which will display user details who have been running queries(current sql statement) for over 5 minutes. I need to terminate all user sessions running for over 5 minutes. Thanks in advance. Lloyd ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.
Hello, Lloyd. In case you're using IDS 11.X, you could enable a task on the database scheduller. You can get a task source code provided by Mr. Knutsen, that was presented on the IIUG 2010 Conference, that kills old database sessions. Unfortunately I've searched for it on my downloads, and couldn't find. Must be here "somewhere"..... sorry. Hope it helps. Regards! Em Sex, 2010-05-21 Ã s 14:09 -0400, Lloyd S escreveu: > Hello All, > > I am looking for a script/sql which will display user details who have been > running queries(current sql statement) for over 5 minutes. I need to terminate > all user sessions running for over 5 minutes. > > Thanks in advance. > > Lloyd > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > Alexandre Marini Especialista DBA msn: alexandre_marini@hotmail.com SEFAZ-MS / SGI-UGSGR / Sistemas IBM-Informix IBM Certified Professional - Informix Dynamic Server v.10 / v.11 --=-+Y0223SIa1MfiJF/b+BJ