Archives of the TeradataForum

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

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

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>>