session host variables in sysmaster

Hi, i would like to know where onstat -g sql goes to get host variables for the current request. I have to query sysmaster from a client so i don't have onstat commands. I know current sql can be retrieved from sysconblock, but i didn't find where host variables are. I am working on IDS 11.50FC9. Regards

Take a look at the sysmaster tables starting with syssqltrace. John F. Miller III STSM, Lead Architect miller3@us.ibm.com 503-747-1366 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 03/17/2015 08:18:52 AM: > From: "JEAN-FRANCOIS BOUDRY" <jf.boudry@free.fr> > To: ids@iiug.org > Date: 03/17/2015 08:19 AM > Subject: session host variables in sysmaster [34832] > Sent by: ids-bounces@iiug.org > > Hi, > i would like to know where onstat -g sql goes to get host variables for the > current request. > I have to query sysmaster from a client so i don't have onstat commands. > I know current sql can be retrieved from sysconblock, but i didn't find where > host variables are. > I am working on IDS 11.50FC9. > > Regards > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

Hi, thank you, but i know sqltraces and it is not activated on production databases. The OLTP application generates a lot of requests (some thousands each second) and sqltrace is not usabled if not pointing on a specific session. The question was, where onstat -g sql get the host variables ? Because if applicable, this method doesn't affect performance, memory and is easy to use from everywhere. Regards