Re: Q: "onstat -g ppf" output

"Tony Edwards" <tony.edwards@bigfoot.com> wrote > Hi, > > The onstat -g ppf command displays information about any table that is > currently open in memory. If you run the command over and over you will see > tables reported and then not reported, I not sure what your trying to > achieve but you should keep this in mind (my guess would be which tables > are getting heavy sequential scan or general heavy activity:). > > The partnum when valid ( not a temporary or system table) will match the > systables partnum. > > I hope this helps... > Cheers, Tony. Thanks Tony. Sorry that I did not get back to you sooner. Your info was right on the money the problem that I seem to be encountering is that there seems to be a major delay. If I run a REALLY large query the tables partnum in sysmaster:systabname or <userdb>:systables does not appear in onstat -g ppf output for around 15 minutes. Can you give me any insight? Thanks in advance, Bill Riedy Database Administrator, First Albany Corporation == all views and opinions expressed are my own == -------------------==== Posted via Deja News ====----------------------- http://www.dejanews.com/ Search, Read, Post to Usenet