onstat & SMI

Good day. Is it possible to get information from SMI similar as "onstat -g sql <sid>" shows? Especially we need current sql and last parsed sql... Thank you in advance. P.S. IDS 11.50FC9 for AIX.

You can find some info in syssqlstat table. HTH Hrvoje On 16.10.2012. 12:13, JOHN SMITH wrote: > Good day. > > Is it possible to get information from SMI similar as "onstat -g sql <sid>" > shows? Especially we need current sql and last parsed sql... Thank you in > advance. > > P.S. IDS 11.50FC9 for AIX. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

> You can find some info in syssqlstat table. Unfortunately in my case the query "select * from syssqlstat" returns the same value in sqs_statement column for all sessions. To be more precise, exactly mine - "select * from syssqlstat"... :-(

Which Informix version do you have? Which OS? Are you running this query as informix user? On 25.10.2012. 10:08, JOHN SMITH wrote: >> You can find some info in syssqlstat table. > Unfortunately in my case the query "select * from syssqlstat" returns the same > value in sqs_statement column for all sessions. To be more precise, exactly > mine - "select * from syssqlstat"... :-( > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > >

Yes, I am running the query as user informix. Other information You can find in my first post.