RE: sysptprof and syssesprof
I cannot tell you the unit of an is-operation. Everyone I ask tells me it's an ISAM read/write and that is where the explanation stops ..... They can't tell me what ISAM means, accept it is some kind of page / buffer read. I CAN tell you that it is not just 1 record that is being read or written. But the reads, writes, rewrites and deletes are the actual reads, inserts, updates and deletes on the table. They can be useful when you look at activity on individual tables. Maybe someone else can give us an answer regarding IS (ISAM?) Dirk Reach Technologies -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of dareb@my-deja.com Sent: Friday, February 02, 2001 6:20 PM To: informix-list@iiug.org Subject: sysptprof and syssesprof Can anybody tell me what the columns isread, iswrite, isrewrites and isdeletes mean in the sysptprof and syssesprof tables? Also, do the pagereads and pagewrites columns represent actual I/O to disk? Thanks, Bill Dare Sent via Deja.com http://www.deja.com/
ISAM = Indexed Sequential Access Method = a way of putting data into storage structures and locating them by means of a key. Informix has a programming language - C-ISAM which allows you to use this method to create your own database and access it via a C API. I'm not sure to what extent C-ISAM underpins any of Informix's current product offerings, but you'll see the term a lot! Errol Dirk Moolman wrote: > > I cannot tell you the unit of an is-operation. Everyone I ask tells me it's > an ISAM read/write and that is where the explanation stops ..... They can't > tell me what ISAM means, accept it is some kind of page / buffer read. > I CAN tell you that it is not just 1 record that is being read or written. > > But the reads, writes, rewrites and deletes are the actual reads, inserts, > updates and deletes on the table. They can be useful when you look at > activity on individual tables. > > Maybe someone else can give us an answer regarding IS (ISAM?) > > Dirk > Reach Technologies > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of dareb@my-deja.com > Sent: Friday, February 02, 2001 6:20 PM > To: informix-list@iiug.org > Subject: sysptprof and syssesprof > > Can anybody tell me what the columns isread, iswrite, isrewrites and > isdeletes mean in the sysptprof and syssesprof tables? > Also, do the pagereads and pagewrites columns represent actual I/O to > disk? > > Thanks, > > Bill Dare > > Sent via Deja.com > http://www.deja.com/
In article <95heal$3dr$1@news.xmission.com>, "Dirk Moolman" <dirkm@reach.co.za> wrote: > > I cannot tell you the unit of an is-operation. Everyone I ask tells me it's > an ISAM read/write and that is where the explanation stops ..... They can't > tell me what ISAM means, accept it is some kind of page / buffer read. > I CAN tell you that it is not just 1 record that is being read or written. ISAM = Indexed Sequential Access Method = a way of putting data into storage structures and locating them by means of a key. Informix has a programming language - C-ISAM which allows you to use this method to create your own database and access it via a C API. I'm not sure to what extent C-ISAM underpins any of Informix's current product offerings, but you'll see the term a lot! The read/write would be governed by whatever parameters the programmer was using to write blocks of data away. Echo > But the reads, writes, rewrites and deletes are the actual reads, inserts, > updates and deletes on the table. They can be useful when you look at > activity on individual tables. > > Maybe someone else can give us an answer regarding IS (ISAM?) > > Dirk > Reach Technologies > > -----Original Message----- > From: owner-informix-list@iiug.iiug.org > [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of dareb@my-deja.com > Sent: Friday, February 02, 2001 6:20 PM > To: informix-list@iiug.org > Subject: sysptprof and syssesprof > > Can anybody tell me what the columns isread, iswrite, isrewrites and > isdeletes mean in the sysptprof and syssesprof tables? > Also, do the pagereads and pagewrites columns represent actual I/O to > disk? > > Thanks, > > Bill Dare > > Sent via Deja.com > http://www.deja.com/ > > Sent via Deja.com http://www.deja.com/