Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005
Posts: 463
|
|
|
|
HI,
Simple table spaces: If neither LOB, NUMPARTS, nor SEGSIZE are specified, the table space that is created is a simple table space.
If neither NUMPARTS nor SEGSIZE are specified, the table space that is created is a simple table space
Segmented Table Space Declared temporary tables must reside in segmented table spaces in a database that is defined AS TEMP (the TEMP database). At least one segmented table space with at least an 8-KB page size must exist in the TEMP database before a declared temporary table can be defined and used. DB2 does not implicitly create a table space for declared temporary tables
If the table space is segmented, the number of pages left free must be less than the SEGSIZE value. If the number of pages to be left free is greater than or equal to the SEGSIZE value, then the number of pages is adjusted downward to one less than the SEGSIZE value
Specifies table locks. TABLE can be specified only for a segmented table space.
For more details you can refer any DB2 Manual
Regards
Rupesh |
|
.jpg)
