Identify long-running SQL statements in IDS 10.00

Posted in 2009

Jonathan — Wed, 13 May 2009 18:02:48 — source: IIUG Forums & Mailing Lists

I don't presently have any monitoring tools like Sentinel or DBSonar, but I do need to be able to identify sessions / SQL statements that are long-running using the onstat commands. I'm currently on Informix IDS 10.00.FC5 for HP-UX, so I can't use OAT :o( If you have a process or steps that you use to identify long-running SQL, I would be extremely for any guidance. TIA. Jonathan B. Smaby Pomona College phone: (909) 621-8506 email: jonathan.smaby@pomona.edu -- Insanity is doing the same thing over and over again and expecting different results. - Albert Einstein, physicist (1879 - 1955) ------------------------------------------------------------- This message has been scanned by Postini anti-virus software.