Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 24 Oct 2007 @ 21:45:03 GMT


     
  <Prev Next>   <<First <Prev
Next>
Last>>
 


Subj:   Re: Space, another final frontier...
 
From:   Barner Eric

On a similar note...

If you have to do a full system unload reload, you can add on a few more percent for the datablock fragmentation that will occur when you restore.

Defrag from ferret will not repair this, got to create a new table via SQL, in the new environment, or alter table and change the block size.

We have experienced this when migrating to new hardware platform, and has caused us some extra unanticipated work in the cut over process.


Eric



     
  <Prev Next>   <<First <Prev
Next>
Last>>
 
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023