Table Block Mapping For Type I Areas

Many people know of the perils of record scatter and fragmentation with Type I areas. This tool provides an easy way to determine how scattered your data is and present that information in an easy to view HTML format. Primarily I use this tool to explain to non technical clients and managers why we need to migrate data from Type I to Type II areas.

You specify which tables are to be mapped by passing which areas or tables to the tool. CAN-DO style lists are supported in order to easily exclude larger tables from the list.

Note that generating the map requires reading every record for each table specified. I would suggest running the tool against a recently restored copy or at least don't run this during business hours on production.


tableblocks.p32.19 KB