Archives of the TeradataForum
Message Posted: Fri, 14 Dec 2007 @ 10:54:00 GMT
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
|