Archives of the TeradataForum

Message Posted: Fri, 16 Sep 2005 @ 20:49:50 GMT

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

The DATABLOCKSIZE is only stored in the table header of each individual table. It's not stored anywhere in the Data Dictionary so cannot be retrieved via regular SQL. The only way to get the value is to do a SHOW TABLE on each table.

If SHOW TABLE doesn't show DATABLOCKSIZE, that means that the value is set to the system default size. Before V2R4.1, the system default size is determined by the BLKS_PER_CYL in the /ntos/vconfig.out file, near the top in the SYSTEM section.

     DATABLOCKSIZE (Bytes/Sectors)  BLKS_PER_CYL
     (Sectors)    Minimum    Default     Maximum
     1488         6144/12    32256/63    65024/127
     3872         7168/14    65024/127   65024/127

On V2R4.1 and onward, the default is taken from PermDBSize in DBSControl under File System category. The default is 127 sectors (=65,024 bytes) but the maximum is 255 sectors (=130,560 bytes).

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