onstat -g arc select statement

Hi All, is the someone who knows the onstat -g arc select statement equivalent? Thanks,

The data is in the sysdbstab table in sysmaster. select dbsnum, name, dbinfo('utc_to_datetime', level0) as level_0_time, logid0, hex(logpos0), dbinfo('utc_to_datetime', level1) as level_1_time, logid1, hex(logpos1), dbinfo('utc_to_datetime', level2) as level_2_time, logid2, hex(logpos2) from sysdbstab sdt order by 1; Art S. Kagel AdvanceDataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. 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 Mon, Jan 4, 2010 at 8:26 PM, JACK PAPA <informix2009@gmail.com> wrote: > Hi All, > > is the someone who knows the onstat -g arc select statement equivalent? > > Thanks, > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --000325558da611d258047c60fe44

Thanks Art, It worked as expected. Regards,