Re: Defraging

Edward Rosenthal wrote: > > fragmentation is spreading the data in your table ( or index or both) > across several disks. <SNIP> Yes, this is true, but what has it got to do with DEfraging a table? :-) "howard.jones" wrote: > > Dear all, > > We are in the process of defragging tables in our database..... > The process we follow is as follows, > Edit dbschema with new extents, > unload the table, drop it > run dbschema sql > reload table. > Once this has been done we are finding the table has the same extents as > before. > i.e. pointless exercise... > Why is this happening, does anyone have other ways of doing defrags. If you have set the extent sizes, then take a look at the extent map to see if that amount of contiguous spaces exists in any of the chunks in that dbspace. The table will be created with your specified size or smaller, depending on available space. You can unload a table and reload it exactly where it came from if you are not careful. Try oncheck -pe to see what space is available. Then you may need to drop multiple tables, or possibly the entire database as others suggested, BEFORE reloading the tables. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+