what system table contains the sorting file size?!

Dear All... I test an esql/c application which select * from a-big-table order by non-index fileds in endless loop , and then I run onstat -g ses 77 showes there is a "77_SORT_0" which takes 77824K(or page?) memory .... so far so good ~~~ and then I am curious to know which system table contains this data?! I try to select * from sysmaster:syssesprof , there is a file : total_sorts , but this field is just the number os session's sort count , I want to know which systables contains the size of sorting file size, in my case , "77_SORT_0" or 77824K ( or page?) .. Thanks ~~

Version of IDS? OS? -- Bob -------------- Original message -------------- From: "MARS CHEN" <mars@jsun.com> > Dear All... > > I test an esql/c application which select * from a-big-table > order by non-index fileds in endless loop , and then I run > onstat -g ses 77 showes there is a "77_SORT_0" which takes 77824K(or page?) > memory .... so far so good ~~~> > and then I am curious to know which system table contains this data?! > I try to select * from sysmaster:syssesprof , there is a file : total_sorts > , but this field is just the number os session's sort count , > I want to know which systables contains the size of sorting file size, > in my case , "77_SORT_0" or 77824K ( or page?) .. > > Thanks ~~ > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >

The sys*rst* tables contain thread specific profile, tracking, and management data. Art S. Kagel On Wed, Jul 23, 2008 at 6:46 AM, MARS CHEN <mars@jsun.com> wrote: > Dear All... > > I test an esql/c application which select * from a-big-table > order by non-index fileds in endless loop , and then I run > onstat -g ses 77 showes there is a "77_SORT_0" which takes 77824K(or page?) > memory .... so far so good ~~~> > and then I am curious to know which system table contains this data?! > I try to select * from sysmaster:syssesprof , there is a file : total_sorts > , but this field is just the number os session's sort count , > I want to know which systables contains the size of sorting file size, > in my case , "77_SORT_0" or 77824K ( or page?) .. > > Thanks ~~ > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) 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.

Thanks ~~~ I've get the sysrstcb and try to get the "77_SORT_0" and the size , I think that need times , for it is like a linking list ... also , I think syssesprof would mean something to me , max_sortdiskspace,dsksorts,total_sorts , ...