tblspaces with bufreads but no isreads

Posted in 2004

Topics: Performance & Tuning, Storage & Space Management

Dave Kosenko — 29 Sep 2004 06:46:14 -0700 — source: Usenet: comp.databases.informix

Wonder if anyone has noticed this before and/or has any idea as to why this is the case. Monitoring my databases via sysmaster (sysptprof in particular), I see a fair amount of bufreads activity on tblspaces with no corresponding isread (or iswrite, etc.) activity. What sort of access of these tblspaces would cause such behavior? I thought maybe light scans might cause this, but that is not happening in this case, nor am I seeing sequential scans. The tblspaces in question are definitely tables, not detached indexes. I can't say that this behavior is out of the realm of normal, as I hadn't really noticed it before (actually I just added bufreads and bufwrites per tablespace to my monitoring tool), but it doesn't seem quite right to me. Thanks, Dave

↪ replying to Dave Kosenko

Madison Pruet — Thu, 30 Sep 2004 02:20:14 GMT — source: Usenet: comp.databases.informix

You got ER turned on? "Dave Kosenko" <dkosenko@hotmail.com> wrote in message news:d9d3b2cf.0409290546.43e2cb6a@posting.google.com... > Wonder if anyone has noticed this before and/or has any > idea as to why this is the case. Monitoring my databases > via sysmaster (sysptprof in particular), I see a fair > amount of bufreads activity on tblspaces with no corresponding > isread (or iswrite, etc.) activity. What sort of access > of these tblspaces would cause such behavior? I thought > maybe light scans might cause this, but that is not happening > in this case, nor am I seeing sequential scans. The > tblspaces in question are definitely tables, not detached > indexes. > > I can't say that this behavior is out of the realm of normal, > as I hadn't really noticed it before (actually I just added > bufreads and bufwrites per tablespace to my monitoring > tool), but it doesn't seem quite right to me. > > Thanks, > Dave