Re: The last executed SQL statement

Obnoxio The Clown wrote: > > >How to obtain the last executed SQL statement? > > If you're using IDS, onstat -g sql <sessionid> or onstat -g ses > <sessionid> Be careful using onstat -g sql on a multiprocessor machine with several CPUS and many users. The query this creates against the SMI tables may NEVER complete since you are chasing the end of a list that is growing constantly and with many users it is growing quickly and with many CPUS that growth does not have to stop to process your query so..... I've started onstat -g sql sessions, and the equivalent SQL thanks to a well meaning but misguided Informix consultant, that ran for days and did not complete. Even killing the session does not stop the query from continuing! One such session started eating resources until it crashed the engine, but that is rare, usually it just runs with no external effect. Art S. Kagel