R
Ruanne Cluer
Guest
Purging Data and then guestimating how much space will result, is a bit like firing buckshot blindfolded. It could result in a chunk of blocks being freed up, it could result in most of the blocks only having fragments freed up. You also need to take into account Type I or Type II Storage areas. With Type II Storage Areas, the 'space' available will then only be available for the same object. iow, if there are 2 tables in the area, and you purge the first table, the resulting space will only be available for that table's new/update records. Purging Data is then really all about how many Blocks are added to the Free Chain as a result, there will also be blocks added to the RM Chain (not completely empty). To this end, the better reporting would be pre and post purge: 1. prostrct statistics dbname area 'area name' 2. proutil dbname -C chanalys area 'area name'
Continue reading...
Continue reading...