Continuous pages in oncheck -pe output

Posted in 2008

GARY GU — Wed, 28 May 2008 02:08:24 — source: IIUG Forums & Mailing Lists

Hi, From oncheck -pe output I got some lines like: .... db1:informix.customer 8773 32 db1:informix.customer 8805 8 db1:informix.customer 8813 16 db1:informix.customer 8829 96 .... Should they be merged into one extent as they are continuous? Thanks, Gary

↪ replying to GARY GU

Art Kagel — Wed, 28 May 2008 02:54:30 — source: IIUG Forums & Mailing Lists

Likely they were not created contigously. It may be that the 8805 extent was created before the 8773 which was before the 8773 extent, etc. On Tue, May 27, 2008 at 10:08 PM, GARY GU <gary_gu@engin.com.au> wrote: > Hi, > >From oncheck -pe output I got some lines like: > > ..... > > db1:informix.customer 8773 32 > > db1:informix.customer 8805 8 > > db1:informix.customer 8813 16 > > db1:informix.customer 8829 96 > ..... > > Should they be merged into one extent as they are continuous? > > Thanks, > Gary > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitely or implicitely. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves.

↪ replying to GARY GU

Madison Pruet — Wed, 28 May 2008 03:10:46 — source: IIUG Forums & Mailing Lists

We can only merge extents if they are physically contigeous AND logici= ally sequential. I'm guessing that these extents are not logically sequent= ial. You could verify that by running oncheck -pt on the table/partition. ------------------------------------- Madison Pruet, STSM IDS Replication Architect = "GARY GU" = <gary_gu@engin.co = m.au> = To Sent by: ids@iiug.org = ids-bounces@iiug. = cc org = Subj= ect Continuous pages in oncheck -pe = 05/27/2008 09:08 output [12222] = PM = = = Please respond to = ids@iiug.org = = = Hi, >From oncheck -pe output I got some lines like: ..... db1:informix.customer 8773 32 db1:informix.customer 8805 8 db1:informix.customer 8813 16 db1:informix.customer 8829 96 ..... Should they be merged into one extent as they are continuous? Thanks, Gary ***********************************************************************= ******** Forum Note: Use "Reply" to post a response in the discussion forum. =