Re: Fragmentation

ckchan5@my-dejanews.com wrote: >I am using Informix 7.24 UC5, and I did fragmentation for all my tables and >indexes, the questions are : - > >1) How to check back all the fragmentation style ? (Round robin or expression) >2) How to know which dbspace use for each table fragmentation > >Regards > >-----== Posted via Deja News, The Leader in Internet Discussion ==----- >http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum 1) dbschema will tell you what fragmentation strategy you chose. 2) oncheck -pe will give you a report on how the dbspaces are being utilized. It's a good idea to run this every once in a while anyway because you can tell whether you have interleaved extents (a bad thing) and to a lesser extent (no pun intended) if you have a problem with data skew. Data skew is the condition where there are significant differences in the amount of data in the fragments of a fragmented table. For instance, if a table was fragmented by a customer's area code, there would probably be some data skew if you compare the area codes for Anchorage Alaska with those for New York City. You'll need a couple of other tools besides oncheck to figure this out, but the -pe option can at least show you the number of extents and their size. ------------------------------------------------------- "You're missing the point," said the fork to the spoon.