2xRe: rows in sysptprof !

---- you wrote: > > >Those stats are cleared by running onstat -z. > > > >Art S. Kagel > Hi Kagel, > yeh, I know that I can initialize those stats by onstat -z,but if not, are > they initialized when the table is closed by the last user. becose I want to > use those stats in my scipts. > Can you please tel me when rows are insered to sysptprof. and is there any > difference between temp tables and normal tables. No, they are cumulative values. They will be cleared when you bring your database server down, or issue onstat -z as previously mentioned. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com

a_blonde@mindless.com wrote: > > ---- you wrote: > > > > >Those stats are cleared by running onstat -z. > > > > > >Art S. Kagel > > Hi Kagel, > > yeh, I know that I can initialize those stats by onstat -z,but if not, are > > they initialized when the table is closed by the last user. becose I want to > > use those stats in my scipts. > > Can you please tel me when rows are insered to sysptprof. and is there any > > difference between temp tables and normal tables. Sorry you did not infer what I was implying. I thought I said the following, just very succinctly: > No, they are cumulative values. They will be cleared when you bring your database server down, or issue onstat -z as previously mentioned. Yeah, what he said. ;-) Art S. Kagel