Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 09 Dec 2003 @ 07:02:50 GMT

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

Subj:   Re: Scheduling a Packdisk maintenance job
From:   Dennis Calkins


I guess my first question is why do you want to run packdisk frequently?

Maybe you need to set up some Table level Attributes to control Cylinder Fill Factor on your BULK load jobs to allow for updating of your tables row at a time.

If you leave extra space at load time you won't incur the CYLINDER SPLITS that require the packdisk to re coalese the cylinders.

Have you talked to the GSC about your space management issues? Maybe they can help.

You might want to view a previous post of mine


about how to use


to identify the tables which are using your diskspace and how to run


just against the tables that will get you the most cylinders back.

  <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: 28 Jun 2020