Re: Catching runnig SQLs

"Shevkar, Mukund" <mshevkar@hp.com> wrote in message news:<cfc68q$802$1@news.xmission.com>... > Hi > I want to catch running SQLs with their memory usage, time it was started and ended alongiwth username ,session id and if possible any information on unix pid. Is their a standard routine , script available for this? how can I do this? > Connections are over TCP and shared memory too. > Informix 7.31, HP-UX 11x > > Mukund > > sending to informix-list There are two sysmaster tables: syssqlcurses, and sysqexplain these should have all of the information that you can get from informix. to view current executing sql: select * from syssqexplain, sysscblst where sqx_sessionid = sid; A little experimenting and you can figure out what is going on with the tables.