Re: onstat -ce reports error. What to do?

Uwe Feuerstein wrote: > As far as I can see your pages are ok. The check function for the > TBLSPACE TBLSPACE entries in "oncheck -ce" seems to be buggy in your > release. > > FREE 2563 564 > > > > ERROR: Extents overlap > > TBLSPACE TBLSPACE 3127 50 > > > > FREE 3177 400 No, not really. It was actually the lines before these that contained the error: PHYSICAL LOG Pages 63 2500 EXT LOG RESERVED PAGES 2563 8 FREE 2563 564 ERROR: Extents overlap Note that there are two extents - ext log reserved pages, and free - which both start at 2563. That is why he got the "extents overlap" error. And yes, it looks bad to me. No telling what will go bad with something like this in your chunk free list. Possibly it will re-allocate the pages to the next table you create, and overwrite your extended log reserved pages. If this is a production system, I'd recommend calling Informix Support (assuming you have support) and seeing if they can fix it. June -- june_t@hotmail.com Lost in the wilds of Palo Alto, living on M&M's and Pepperidge Farm cookies