RE: sysmaster question

Posted in 2007

Jack Parker — Thu, 25 Jan 2007 16:31:56 -0500 — source: Usenet: comp.databases.informix

Not fragmented at all. j. -----Original Message----- From: FRANK [mailto:yunyaoqu@gmail.com] Sent: Thursday, January 25, 2007 4:14 PM To: Jack Parker Cc: Informix-List@Iiug. Org Subject: Re: sysmaster question HI, Jack, Is this table fragmented to more than one chunk? Frank On 1/25/07, Jack Parker < jack.parker4@verizon.net> wrote: poking about. I have a table, in a single dbspace, in a single chunk. (Cooked). According to sysptprof, there have been 4.2 million page reads against the table. According to syschkio, there have been 3.6 million pages read from the chunk. Obviously this is a discrepancy, how is it getting resolved? A request is made to disk to read a page, and the page has already been read? Then why doesn't it count in bufreads? This particular table accounts for 88% of my i/o against this disk, so add another 400K or so page reads to the 4.2 million number. Page writes seem to be more consistent with what I'd expect. cheeers j. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list