All Forums Database
Kishore_1 208 posts Joined 03/10
08 Apr 2014
Maximum Data Block Size

How can I know the Maximum Data Block Size set for a Teradata system?
 
Thanks,
Kishore

Raja_KT 1246 posts Joined 07/09
08 Apr 2014

This link will answer many questions.
http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111A/ch04.023.05.html
I think only the DBA can see value settings by way of   DBS Control utility.

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

Adeel Chaudhry 773 posts Joined 04/08
09 Apr 2014

The following link gives the overview on DATABLOCKSIZE:
 
http://www.info.teradata.com/htmlpubs/DB_TTU_14_00/index.html#page/SQL_Reference/B035_1184_111A/Create_Table-Details.012.032.html
 
As a general practice, if you have alot of FTS on a table, use a larger value for DATABLOCKSIZE which results in less I/Os.

-- If you are stuck at something .... consider it an opportunity to think anew.

You must sign in to leave a comment.