Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 14 Dec 2007 @ 10:54:00 GMT


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


Subj:   Re: Data BlockSize
 
From:   Christopher Stephens

No - this information isn't available in the data dictionary. The default block size on most systems is 64K (minus 1 sector of overhead). You can see the default setting on your system by looking at a few DBS Control settings.

Also, I just recently found out that datablocks are actually stored as variable size blocks. The "data block size" referred to in a table definition and in system settings refers to the maximum possible size of a block - not necessarily the size of every block in a table. You can experiment by looking at block allocations on a table with the "ferret" utility's SHOWBLOCKS command then using "ferret" to run PACKDISK.

If you find a cool way to script ferret, let us know!


- Chris



     
  <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