Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 27 Feb 2002 @ 19:34:20 GMT


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


Subj:   Re: Datablocksize and Freepercent
 
From:   Dennis Calkins

Hi,

The SHOW TABLE output normally shows these values if they are not the defaults. If they are the default than it won't show anything.

The defaults are in the dbscontrol.gdo internal to the server and there is no way from SQL to obtain the default values.

ferret showblocks will show you the distribution of datablock sizes but won't tell you what the current settings of a particular table is. It is not ununsual for table with 127 sector datablock size to have mostly 80 - 90 sector datablocks sizes due to maturity (inserts and deletes ).

ferret showspace will show you the actual current FSP for a table but again this may not be FSP set for the table just the FSP the table has matured to.

The new command in Ferret for 4.1 SHOWFSP will show you the actual current FSP of the table and how many cylinders would be freed or lost if the table was packed (packdisk) to its desired FSP.

desired FSP is defined as

    specified FSP in the case of
        showfsp -d x    (simulates a packdisk fsp = x)

    table level FSP in  the case of
        showfsp         (simulates a  packdisk with no FSP specified )
    when the table has a Table level FSP specified.

    system default FSP in the case of
        showfsp         (simulates a  packdisk with no FSP specified )
    when the table doesn't have any Table level attribute specified.


     
  <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: 27 Dec 2016