TABLESPACE design and SEGSIZE consideration

While designing the tablespace, Segment size is an important parameter to consider. Here are IBM recommendations for such calculation.

NO OF PAGES SEGSIZE
-----------..... -------

< = 28 ............4 TO 28
28 TO 128 .........32
> = 128 ...........64



How to determine that when will you cosider which type of tablespace.

NO OF PAGES ....TABLESPACE DESIGN
----------- ----------------------

> 100,000 .....CONSIDER PARTITIONING

> 10,000 ......ONE TABLE SEGMENTED TABLESPACE

Greater than 128 TO Less than 10,000 MULTIPLE-TABLE SEGMENTED TABLESPACES(But I think one table in one tablspace is best design for maintenance purpose)

Less than 128 ............MULTIPLE-TABLE SEGMENTED TABLESPACES(But I think one table in one tablspace is best design for maintenance purpose)



Cheers...
Prakash C. Singh
IBM Certified DB2 DBA