Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 04 May 2002 @ 23:40:12 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Packdisk maintenance job
From:   Dennis Calkins


After you upgrade to 4.1 there is a new command in Ferret called SHOWFSP which will tell you the current FSP of every table larger than 2 cylinders (configuable) per amp ).

This command takes about 10 minutes to run and is very non intrusive to the rest of the system. Using this command you can play with different FSP values and see which values would work best.

Using this command you can identify which tables contain the most recoverable number of cylinders when they are packed to certain percentages.

Then you can SCOPE to those specific tables and run packdisk on just the tables which will result in the most recovered cylinders.

Since you are packing only specific tables and not the whole system, packdisk will run faster.

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