Maximum Data Block Size

Database
Enthusiast

Maximum Data Block Size

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

Thanks,

Kishore

2 REPLIES
Enthusiast

Re: Maximum Data Block Size

This link will answer many questions.

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1093_111...

I think only the DBA can see value settings by way of   DBS Control utility.

Teradata Employee

Re: Maximum Data Block Size

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/Crea...

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.