SQL statement equivalent TO onstat -g ssc

Informix version 11:70 / 12.10 Platform : Linux / Unix Hi all I am looking for SQL statement which equivalent TO command : onstat -g ssc Anyone have any idea which tables that I should "reference to" in sysmaster DB ? Thanks

This info doesn't look to be externalized through any sysmaster SMI pseudo = table. From: "LEY PATRICK" <patrickley@gmail.com> To: ids@iiug.org Date: 23.06.2016 02:50 Subject: SQL statement equivalent TO onstat -g ssc [37304] Sent by: ids-bounces@iiug.org Informix version 11:70 / 12.10=20 Platform : Linux / Unix=20 Hi all=20 I am looking for SQL statement which equivalent TO command :=20 onstat -g ssc=20 Anyone have any idea which tables that I should "reference to" in=20 sysmaster DB=20 ?=20 Thanks=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20

Patrick: I don't think that the statement cache is exposed in sysmaster. The only reference to it in sysmaster that I know of is the efficiency profile record in syssqlcacheprof: select * from syssqlcahceprof where name = 'Statement Cache'; But that's just over all hits, misses, memory used, #entries. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Jun 22, 2016 at 8:50 PM, LEY PATRICK <patrickley@gmail.com> wrote: > Informix version 11:70 / 12.10 > Platform : Linux / Unix > > Hi all > > I am looking for SQL statement which equivalent TO command : > onstat -g ssc> > Anyone have any idea which tables that I should "reference to" in > sysmaster DB > ? > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001a114449582c83a10535efe77e