Archives of the TeradataForum
Message Posted: Fri, 14 Dec 2007 @ 15:30:09 GMT
| Subj: | | Re: Data BlockSize |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Fri, 14 Dec 2007 08:05 -->
Ferret PACKDISK is concerned with number of "free sectors" within a "logical cylinder", and only moves existing blocks between cylinders. (And
if an entire cylinder becomes free sectors, that cylinder is returned to the free list.)
Ferret DEFRAG is concerned with location of "free sectors" within a "logical cylinder", and only moves existing blocks within a cylinder to
make free sectors as logically contiguous as possible.
If you want to actually "reblock", i.e. change the size of existing blocks, you use ALTER TABLE DATABLOCKSIZE IMMEDIATE.
Under MP-RAS, you can script ferret via the cnsrun command. It's not in the PDF manuals, but a "man page" is installed with PDE.
| 
