2xRe: rows in sysptprof !

>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. Thanks lot !! >samir BADAOUI wrote: > > > > Hi everybody, > > In mu sysmaster:sysptprof table I have find lot of tables with big >number of > > isreads,bufreads and pagreads. I want to know if those values are > > initialized to 0 when the associated tables are closed by the last user. >and > > if any one can tel me how Online insert values in this table (I mean >whene > > and if it's one row by table or not) > > > > Thanks lot > > > > ______________________________________________________ > > Get Your Private, Free Email at http://www.hotmail.com ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

It would probably help you to know that sysptprof is a view, not a table. Here's the definition of it: CREATE VIEW "informix".sysptprof ( dbsname, tabname, partnum, lockreqs, lockwts, deadlks, lktouts, isreads, iswrites, isrewrites, isdeletes, bufreads, bufwrites, seqscans, pagreads, pagwrites) AS SELECT x0.db sname, x0.tabname, x1.partnum, x1.pf_rqlock, x1.pf_wtlock, x1.pf _deadlk, x1.pf_lktouts, x1.pf_isread, x1.pf_iswrite, x1.pf_isrwr ite, x1.pf_isdelete, x1.pf_bfcread, x1.pf_bfcwrite, x1.pf_seqsca ns, x1.pf_dskreads, x1.pf_dskwrites FROM "informix".systabnames x0, "informix".sysptntab x1 WHERE (x0.partnum = x1.partnum ) ; This obviously doesn't answer all of your questions, especially the ones about just exactly what it is that increments each of the columns, but it might help you out anyway. -- --Marty Allred "The Rambling Man" Don't believe me? Try reading one of my messages. In article <7npk4o$nq8$1@news.xmission.com>, "samir BADAOUI" <samir_badaoui@hotmail.com> 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. > > Thanks lot !! > > >samir BADAOUI wrote: > > > > > > Hi everybody, > > > In mu sysmaster:sysptprof table I have find lot of tables with big > >number of > > > isreads,bufreads and pagreads. I want to know if those values are > > > initialized to 0 when the associated tables are closed by the last user. > >and > > > if any one can tel me how Online insert values in this table (I mean > >whene > > > and if it's one row by table or not) > > > > > > Thanks lot Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.