Add chunk.

Hello, I am a newbie. Working with AIX 4.3.2 and IDS 7.30 UC7. After adding a second chunk to a dbspace I got the error message: extents overlap(oncheck -ce). Chunk was successfully added and onstat -d shows the new chunk. What is the problem? Thanks in advance, Fredo David

In article <3932b8f9.6270410@news.ivx.de>, F. David <FredoDavid@gmx.net> writes >Hello, >I am a newbie. >Working with AIX 4.3.2 and IDS 7.30 UC7. >After adding a second chunk to a dbspace I got the error message: >extents overlap(oncheck -ce). >Chunk was successfully added and onstat -d shows the new chunk. >What is the problem? > Sounds like an Informix bug. What does oncheck -pe give for the dbspace? >Thanks in advance, >Fredo David > -- David Williams

It's not telling you that the chunks overlap but that somehow, probably due to an engine bug, the engine has created extents in different tables that overlap, ie the start + length of some extent is greater than the start address of some other extent. Run the suggested oncheck -ce and see what is reported and suggested. Art S. Kagel "F. David" wrote: > > Hello, > I am a newbie. > Working with AIX 4.3.2 and IDS 7.30 UC7. > After adding a second chunk to a dbspace I got the error message: > extents overlap(oncheck -ce). > Chunk was successfully added and onstat -d shows the new chunk. > What is the problem? > > Thanks in advance, > Fredo David

>In article <3932b8f9.6270410@news.ivx.de>, F. David <FredoDavid@gmx.net> >writes >>Hello, >>I am a newbie. >>Working with AIX 4.3.2 and IDS 7.30 UC7. >>After adding a second chunk to a dbspace I got the error message: >>extents overlap(oncheck -ce). >>Chunk was successfully added and onstat -d shows the new chunk. >>What is the problem? >> > > Sounds like an Informix bug. What does oncheck -pe give for > the dbspace? Oncheck gave the information: For the added chunk Chunk: 13 /dev/idbs15 Size Used Free 50000 0 49997 Disk usage for chunk 13 start length OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 49997 For the first chunk Chunk: 2 /dev/idbs22 Size Used Free 50000 0 49997 Disk usage for chunk 2 start length OTHER RESERVED Pages 0 2 ERROR: Extents overlap CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 db:tbl 53 5500 ........... >-- >David Williams Fredo David

In article <39354ff3.1042125@news.ivx.de>, F. David <FredoDavid@gmx.net> writes > >>In article <3932b8f9.6270410@news.ivx.de>, F. David <FredoDavid@gmx.net> >>writes >>>Hello, >>>I am a newbie. >>>Working with AIX 4.3.2 and IDS 7.30 UC7. >>>After adding a second chunk to a dbspace I got the error message: >>>extents overlap(oncheck -ce). >>>Chunk was successfully added and onstat -d shows the new chunk. >>>What is the problem? >>> >> >> Sounds like an Informix bug. What does oncheck -pe give for >> the dbspace? >Oncheck gave the information: > >For the added chunk >Chunk: 13 /dev/idbs15 Size Used Free > 50000 0 49997 > >Disk usage for chunk 13 start length > >OTHER RESERVED Pages 0 2 >CHUNK FREE LIST PAGE 2 1 >FREE 3 49997 > >For the first chunk >Chunk: 2 /dev/idbs22 Size Used Free > 50000 0 49997 > >Disk usage for chunk 2 start length > >OTHER RESERVED Pages 0 2 >ERROR: Extents overlap >CHUNK FREE LIST PAGE 2 1 >TBLSPACE TBLSPACE 3 50 >db:tbl 53 5500 >........... > > >>-- >>David Williams > > >Fredo David Log a call with Informix, something funny is happening. -- David Williams

Thanks for help. Informix told me that it is a known bug. Not the database engine is the reason but the operating system. Some versions of AIX with some IDS show this problem. I could fix it and added the chunk without errors. F. David >It's not telling you that the chunks overlap but that somehow, probably >due to an engine bug, the engine has created extents in different tables >that overlap, ie the start + length of some extent is greater than the >start address of some other extent. Run the suggested oncheck -ce and see >what is reported and suggested. > >Art S. Kagel > > >Oncheck gave the information: >For the added chunk >Chunk: 13 /dev/idbs15 Size Used Free > 50000 0 49997 > >Disk usage for chunk 13 start length > >OTHER RESERVED Pages 0 2 >CHUNK FREE LIST PAGE 2 1 >FREE 3 49997 > >For the first chunk >Chunk: 2 /dev/idbs22 Size Used Free > 50000 0 49997 > >Disk usage for chunk 2 start length > >OTHER RESERVED Pages 0 2 >ERROR: Extents overlap >CHUNK FREE LIST PAGE 2 1 >TBLSPACE TBLSPACE 3 50 >db:tbl 53 5500 >........... >F. David > Sounds like an Informix bug. What does oncheck -pe give for > the dbspace? > >David Williams >"F. David" wrote: >> >> Hello, >> I am a newbie. >> Working with AIX 4.3.2 and IDS 7.30 UC7. >> After adding a second chunk to a dbspace I got the error message: >> extents overlap(oncheck -ce). >> Chunk was successfully added and onstat -d shows the new chunk. >> What is the problem? >> >> Thanks in advance, >> Fredo David