Data Block size

Database
Enthusiast

Data Block size

Hi all,

I have a query regarding setting that Data block size while creating the table

we can give set the datablock size using

Datablocksize = integer (can be in bytes and kbytes)

What does the key words MINIMUM DATABLOCKSIZE and MAXIMUM DATABLOCKSIZE represents in the create table opetions?

Thanks in advance

3 REPLIES
Junior Contributor

Re: Data Block size

Why don't you simply check the manuals?

SQL Reference: Data Definition Statements, CREATE TABLE

Dieter
Enthusiast

Re: Data Block size

The maximum data block size for all systems is 130,560 bytes (255 sectors). per SQL Data Definition Language Syntax and Examples Release 14.0 B035-1144-111A page 53

Junior Contributor

Re: Data Block size

Newer versions support block sizes up to 1MB